cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Tempspace problem / how does tempspace work?

Former Member

on ‎08-29-2008 11:40 AM

0 Kudos

How does tempspace work?

We have got a problem (non SAP Application) concerning MaxDB temp space growing bigger than 1 GB in only a few seconds (using Version 7.6.02.10, Windows Server 2003 64 bit, Maxdb Cache Size=1000000 - 8GB, 16 GB RAM - usually 4GB free, Work-Dir on C:-Raid, All Data-Files and Log-Files on E:-Raid).

We have not been able to identify the reason for that huge temp-space (bad query?) - therefore we would like to eleminate the effects that are:

Lots of reading accesses of kernel.exe to Drive C: identified by filemon (no special file, just read no write, 4kb Blocksize) leading to a fully busy C:-Raid for Minutes and a very slow responding system.

Those drive accesses do not interact with Windows paging as pages/sec measured with permon stays near 0 at the same time wehreas the number of page faults/sec of the kernel.exe process seems to be 2 times the number during normal operation.

Restarting x-server (and for this reasing closing all running database requests) solves that problem.

Is there any possibility to stop MaxDB using/degrading the C-Raid when huge tempspace usage appears?

Any help is appreciated.

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎08-29-2008 12:51 PM
0 Kudos

Thanks for the fast reply. I will try to answer your questions.

Volume E is a raid 10 built of 14 15k SAS Drives. Quite massive for a 36GB Database.

Volume D resides on the same raid as volume e but is only used for backup files.

Volume C is a 2 15k SAS raid 1 mirror.

When that heavy c-drive usage occurs i opened dbmgui and a temp of 1.1gb was listet at that time (we have observed this behaviour several times).

Normal Temp is between 20mb and 300 mb.

At the time of that big temp windows permon reads as follows:

Pages/sec: next to 0

Disk idle time c: next to 0

Disk write time c: next to 0

Disk read time c: maxed

In the following Filemon log-part you will see that the massive accesses are not to the work directory but just C:

79 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 12773384192 Length: 4096

80 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 12337758208 Length: 4096

81 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 8190828544 Length: 4096

82 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 12599758848 Length: 4096

83 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9407926272 Length: 4096

84 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 3717402624 Length: 4096

85 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 11704889344 Length: 4096

86 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9425113088 Length: 4096

87 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9407930368 Length: 4096

88 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9425121280 Length: 4096

89 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 12599771136 Length: 4096

90 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 11696353280 Length: 4096

91 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9299853312 Length: 4096

92 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 8834232320 Length: 4096

93 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 12140376064 Length: 4096

94 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 11704897536 Length: 4096

95 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 8835805184 Length: 4096

96 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 11696357376 Length: 4096

97 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9299857408 Length: 4096

98 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 12140380160 Length: 4096

99 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9907781632 Length: 4096

100 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 10363772928 Length: 4096

101 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 8492359680 Length: 4096

102 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9907789824 Length: 4096

103 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 10363781120 Length: 4096

104 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 8492371968 Length: 4096

105 11:41:44 taskmgr.exe:2288 QUERY INFORMATION C:\tools\Filemon64.exe SUCCESS Attributes: A

106 11:41:44 taskmgr.exe:2288 OPEN C:\tools\Filemon64.exe SUCCESS Options: Open Access: 00100020

107 11:41:44 taskmgr.exe:2288 QUERY INFORMATION C:\tools\Filemon64.exe SUCCESS Length: 379456

108 11:41:44 taskmgr.exe:2288 CLOSE C:\tools\Filemon64.exe SUCCESS

109 11:41:44 taskmgr.exe:2288 READ C: SUCCESS Offset: 4470796288 Length: 4096

110 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9370972160 Length: 4096

111 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9370976256 Length: 4096

112 11:41:44 kernel.exe:6160 READ E:\sdb\data\wrk\PKM_1_D\DAT_0009 SUCCESS Offset: 152567808 Length: 8192

113 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 10383069184 Length: 4096

114 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9904848896 Length: 4096

115 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 12231426048 Length: 4096

116 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9741860864 Length: 4096

117 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 10383073280 Length: 4096

118 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9741864960 Length: 4096

119 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 9904828416 Length: 4096

120 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 12231430144 Length: 4096

121 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 3717382144 Length: 4096

122 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 7273254912 Length: 4096

123 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 7410323456 Length: 4096

124 11:41:44 kernel.exe:6160 READ C: SUCCESS Offset: 8842657792 Length: 4096

125 11:41:44 dbmevtdisp.exe:2184 OPEN C:\data\sdb\indep-data\wrk\PKMMAIL\ SUCCESS Options: Open Directory Access: 00100001

126 11:41:44 dbmevtdisp.exe:268 OPEN C:\Program Files\sdb\data\wrk\PKM_1_D\ SUCCESS Options: Open Directory Access: 00100001

127 11:41:44 dbmevtdisp.exe:2184 DIRECTORY C:\data\sdb\indep-data\wrk\PKMMAIL\ SUCCESS FileBothDirectoryInformation: dbmsilevt.cfg

128 11:41:44 dbmevtdisp.exe:268 DIRECTORY C:\Program Files\sdb\data\wrk\PKM_1_D\ SUCCESS FileBothDirectoryInformation: dbmsilevt.cfg

129 11:41:44 dbmevtdisp.exe:2184 OPEN C:\data\sdb\indep-data\wrk\PKMMAIL\dbmsilevt.cfg SUCCESS Options: Open Access: Read

130 11:41:44 dbmevtdisp.exe:268 OPEN C:\Program Files\sdb\data\wrk\PKM_1_D\dbmsilevt.cfg SUCCESS Options: Open Access: Read

131 11:41:44 dbmevtdisp.exe:2184 CLOSE C:\data\sdb\indep-data\wrk\PKMMAIL\dbmsilevt.cfg SUCCESS

132 11:41:44 dbmevtdisp.exe:268 CLOSE C:\Program Files\sdb\data\wrk\PKM_1_D\dbmsilevt.cfg SUCCESS

The "kernel.exe:6160 READ C: SUCCESS Offset: 12773384192 Length: 4096" accesses only happen when temp is big (observation)

Accesses by dbmevtdisp.exe, etc. can be observed during normal operation as well, they pose no problem.

Kernel-Parameters:

2008-04-22 10:06:02 0x1DD4 20233 RTE Dump of all kernel parameters start

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 1

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 2

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 3

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 4

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 5

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 6

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 7

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 8

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 9

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 10

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 11

2008-04-22 10:06:02 0x1DD4 20206 RTE Using mode NORMAL for data volume 12

2008-04-22 10:06:02 0x1DD4 20234 RTE ADMIN=1

2008-04-22 10:06:02 0x1DD4 20234 RTE AKDUMP_ALLOWED=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE ALLOW_MULTIPLE_SERVERTASK_UKTS=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE AUTHENTICATION_ALLOW=

2008-04-22 10:06:02 0x1DD4 20234 RTE AUTHENTICATION_DENY=

2008-04-22 10:06:02 0x1DD4 20234 RTE AUTOSAVE=1

2008-04-22 10:06:02 0x1DD4 20234 RTE AUTO_RECREATE_BAD_INDEXES=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE BACKUPRESULT=1

2008-04-22 10:06:02 0x1DD4 20234 RTE BACKUP_BLOCK_CNT=64

2008-04-22 10:06:02 0x1DD4 20234 RTE BACKUPHISTFILE=dbm.knl

2008-04-22 10:06:02 0x1DD4 20234 RTE BACKUPMED_DEF=dbm.mdf

2008-04-22 10:06:02 0x1DD4 20234 RTE CACHE_SIZE=1000000

2008-04-22 10:06:02 0x1DD4 20234 RTE CALLSTACKLEVEL=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CATCACHE_MINSIZE=262144

2008-04-22 10:06:02 0x1DD4 20234 RTE CAT_CACHE_SUPPLY=50000

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECKDATA=1

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_BACKUP=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_COMMON=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_CONVERTER=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_DATACACHE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_DATAINDEX=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_DATAPAGELOG=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_FBM=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_HASHED_RESULTSET=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_IOMAN=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_KB_REGIONS=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_LOCK_SUPPLY=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_LOCK=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_LOGHISTORY=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_LOGPAGE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_LOGTRANS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_LOGVOLUME=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_QUERYREWRITE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_REGIONS=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_SRVTASKS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_TABLE_WIDTH=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_TASK_SPECIFIC_CATALOGCACHE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_TRANSLIST=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_TREE_LOCKS=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CHECK_TREE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CLUSTERED_LOBS=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE CLUSTER_WRITE_THRESHOLD=80

2008-04-22 10:06:02 0x1DD4 20234 RTE COLUMNCOMPRESSION=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE _COMMENT=

2008-04-22 10:06:02 0x1DD4 20234 RTE CONTROLPASSWORD=***

2008-04-22 10:06:02 0x1DD4 20234 RTE CONTROLUSERID=DBM

2008-04-22 10:06:02 0x1DD4 20234 RTE CONVERTER_REGIONS=16

2008-04-22 10:06:02 0x1DD4 20234 RTE DATABASEFULL=1

2008-04-22 10:06:02 0x1DD4 20234 RTE DATACACHE_RGNS=64

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_IO_BLOCK_COUNT=64

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_GROUPS=1

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0001=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0002=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0003=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0004=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0005=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0006=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0007=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0008=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0009=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0010=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0011=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_MODE_0012=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0001=E:\sdb\data\wrk\PKM_1_D\DAT_0001

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0002=E:\sdb\data\wrk\PKM_1_D\DAT_0002

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0003=E:\sdb\data\wrk\PKM_1_D\DAT_0003

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0004=E:\sdb\data\wrk\PKM_1_D\DAT_0004

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0005=E:\sdb\data\wrk\PKM_1_D\DAT_0005

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0006=E:\sdb\data\wrk\PKM_1_D\DAT_0006

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0007=E:\sdb\data\wrk\PKM_1_D\DAT_0007

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0008=E:\sdb\data\wrk\PKM_1_D\DAT_0008

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0009=E:\sdb\data\wrk\PKM_1_D\DAT_0009

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0010=E:\sdb\data\wrk\PKM_1_D\DAT_0010

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0011=E:\sdb\data\wrk\PKM_1_D\DAT_0011

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_NAME_0012=E:\sdb\data\wrk\PKM_1_D\DAT_0012

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0001=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0002=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0003=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0004=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0005=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0006=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0007=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0008=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0009=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0010=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0011=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_SIZE_0012=1048576

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0001=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0002=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0003=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0004=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0005=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0006=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0007=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0008=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0009=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0010=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0011=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATA_VOLUME_TYPE_0012=F

2008-04-22 10:06:02 0x1DD4 20234 RTE DATE_TIME_FORMAT=INTERNAL

2008-04-22 10:06:02 0x1DD4 20234 RTE DBFILLINGABOVELIMIT=70L80M85M90H95H96H97H98H99H

2008-04-22 10:06:02 0x1DD4 20234 RTE DBFILLINGBELOWLIMIT=70L80L85L90L95L

2008-04-22 10:06:02 0x1DD4 20234 RTE DDLTRIGGER=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE DEADLOCK_DETECTION=4

2008-04-22 10:06:02 0x1DD4 20234 RTE DEFAULT_CODE=UNICODE

2008-04-22 10:06:02 0x1DD4 20234 RTE DELAYCOMMIT=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE DELAYLOGWRITER=0

2008-04-22 10:06:02 0x1DD4 20234 RTE DIAG_HISTORY_NUM=2

2008-04-22 10:06:02 0x1DD4 20234 RTE DIAG_HISTORY_PATH=C:\Program Files\sdb\data\wrk\PKM_1_D\DIAGHISTORY

2008-04-22 10:06:02 0x1DD4 20234 RTE DIAGSEM=0

2008-04-22 10:06:02 0x1DD4 20234 RTE DWIO_AREA_FLUSH=50

2008-04-22 10:06:02 0x1DD4 20234 RTE DWIO_AREA_SIZE=50

2008-04-22 10:06:02 0x1DD4 20234 RTE DWLRU_TAIL_FLUSH=25

2008-04-22 10:06:02 0x1DD4 20234 RTE ENABLE_CHECK_INSTANCE=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE ENABLE_SYSTEM_TRIGGERS=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE ERROR=3

2008-04-22 10:06:02 0x1DD4 20234 RTE _EVENTFILE=knldiag.evt

2008-04-22 10:06:02 0x1DD4 20234 RTE _EVENTSIZE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE EVENT=1

2008-04-22 10:06:02 0x1DD4 20234 RTE EXPAND_COM_TRACE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE EXTERNAL_DUMP_REQUEST=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE FBMLOW_IO_RATE=10

2008-04-22 10:06:02 0x1DD4 20234 RTE FBM_VOLUME_BALANCE=10

2008-04-22 10:06:02 0x1DD4 20234 RTE FBM_VOLUME_COMPRESSION=50

2008-04-22 10:06:02 0x1DD4 20234 RTE FILEDIR_SPINLOCKPOOL_SIZE=10

2008-04-22 10:06:02 0x1DD4 20234 RTE FORBID_LOAD_BALANCING=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE FORMATTING_MODE=PARALLEL

2008-04-22 10:06:02 0x1DD4 20234 RTE FORMAT_DATAVOLUME=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE HASHED_RESULTSET_CACHESIZE=262144

2008-04-22 10:06:02 0x1DD4 20234 RTE HASHED_RESULTSET=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE HEAP_CHECK_LEVEL=0

2008-04-22 10:06:02 0x1DD4 20234 RTE HIRES_TIMER_TYPE=CPU

2008-04-22 10:06:02 0x1DD4 20234 RTE HS_STORAGE_DLL=libhsscopy

2008-04-22 10:06:02 0x1DD4 20234 RTE HS_SYNC_INTERVAL=50

2008-04-22 10:06:02 0x1DD4 20234 RTE IDXFILELIST_SIZE=4096

2008-04-22 10:06:02 0x1DD4 20234 RTE INDEX_LEAF_CACHING=2

2008-04-22 10:06:02 0x1DD4 20234 RTE INIT_ALLOCATORSIZE=262144

2008-04-22 10:06:02 0x1DD4 20234 RTE INSTANCE_TYPE=OLTP

2008-04-22 10:06:02 0x1DD4 20234 RTE IOPROCSFOR_PRIO=0

2008-04-22 10:06:02 0x1DD4 20234 RTE IOPROCSFOR_READER=0

2008-04-22 10:06:02 0x1DD4 20234 RTE IOPROCSPER_DEV=1

2008-04-22 10:06:02 0x1DD4 20234 RTE IOPROCSSWITCH=2

2008-04-22 10:06:02 0x1DD4 20234 RTE JOIN_MAXTAB_LEVEL4=16

2008-04-22 10:06:02 0x1DD4 20234 RTE JOIN_MAXTAB_LEVEL9=5

2008-04-22 10:06:02 0x1DD4 20234 RTE JOIN_SEARCH_LEVEL=0

2008-04-22 10:06:02 0x1DD4 20234 RTE JOIN_TABLEBUFFER=128

2008-04-22 10:06:02 0x1DD4 20234 RTE _KERNELDIAGFILE=knldiag

2008-04-22 10:06:02 0x1DD4 20234 RTE KERNELDIAGSIZE=800

2008-04-22 10:06:02 0x1DD4 20234 RTE _KERNELDUMPFILE=knldump

2008-04-22 10:06:02 0x1DD4 20234 RTE _KERNELTRACEFILE=knltrace

2008-04-22 10:06:02 0x1DD4 20234 RTE KERNELTRACESIZE=5899

2008-04-22 10:06:02 0x1DD4 20234 RTE KERNELVERSION=KERNEL 7.6.02 BUILD 010-123-148-818

2008-04-22 10:06:02 0x1DD4 20234 RTE LOAD_BALANCING_CHK=0

2008-04-22 10:06:02 0x1DD4 20234 RTE LOAD_BALANCING_DIF=10

2008-04-22 10:06:02 0x1DD4 20234 RTE LOAD_BALANCING_EQ=5

2008-04-22 10:06:02 0x1DD4 20234 RTE LOCAL_REDO_LOG_BUFFER_SIZE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE LOCKSUPPLY_BLOCK=100

2008-04-22 10:06:02 0x1DD4 20234 RTE LOGABOVELIMIT=50L75L90M95M96H97H98H99H

2008-04-22 10:06:02 0x1DD4 20234 RTE LOGFULL=1

2008-04-22 10:06:02 0x1DD4 20234 RTE LOGSEGMENTFULL=1

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_BACKUP_TO_PIPE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_IO_BLOCK_COUNT=4

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_IO_QUEUE=50

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_MIRRORED=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_QUEUE_COUNT=1

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_SEGMENT_SIZE=2133

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_NAME_001=e:\sdb\data\wrk\PKM_1_D\LOG_001

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_NAME_002=e:\sdb\data\wrk\PKM_1_D\LOG_002

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_NAME_003=e:\sdb\data\wrk\PKM_1_D\LOG_003

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_NAME_004=e:\sdb\data\wrk\PKM_1_D\LOG_004

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_NAME_005=e:\sdb\data\wrk\PKM_1_D\LOG_005

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_NAME_006=e:\sdb\data\wrk\PKM_1_D\LOG_006

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_SIZE_001=131072

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_SIZE_002=131072

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_SIZE_003=131072

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_SIZE_004=131072

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_SIZE_005=131072

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_SIZE_006=131072

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_TYPE_001=F

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_TYPE_002=F

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_TYPE_003=F

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_TYPE_004=F

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_TYPE_005=F

2008-04-22 10:06:02 0x1DD4 20234 RTE LOG_VOLUME_TYPE_006=F

2008-04-22 10:06:02 0x1DD4 20234 RTE LRU_FOR_SCAN=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXBACKUPDEVS=2

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXCPU=6

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXDATAVOLUMES=64

2008-04-22 10:06:02 0x1DD4 20234 RTE _MAXEVENTS=100

2008-04-22 10:06:02 0x1DD4 20234 RTE _MAXEVENTTASKS=2

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXGARBAGECOLL=1

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXLOCKS=40080

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXLOGVOLUMES=7

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXPAGER=64

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXRGN_REQUEST=-1

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXSERVERTASKS=134

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXTASKSTACK=1024

2008-04-22 10:06:02 0x1DD4 20234 RTE _MAXTRANS=4008

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXUSERTASKS=500

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXVOLUMES=72

2008-04-22 10:06:02 0x1DD4 20234 RTE MAX_HASHTABLE_MEMORY=5120

2008-04-22 10:06:02 0x1DD4 20234 RTE MAX_LOG_QUEUE_COUNT=0

2008-04-22 10:06:02 0x1DD4 20234 RTE MAXMESSAGE_FILES=0

2008-04-22 10:06:02 0x1DD4 20234 RTE MAX_MESSAGE_LIST_LENGTH=100

2008-04-22 10:06:02 0x1DD4 20234 RTE MAX_RETENTION_TIME=480

2008-04-22 10:06:02 0x1DD4 20234 RTE MAX_SERVERTASK_STACK=500

2008-04-22 10:06:02 0x1DD4 20234 RTE MAX_SINGLE_HASHTABLE_SIZE=512

2008-04-22 10:06:02 0x1DD4 20234 RTE MAX_SPECIALTASK_STACK=500

2008-04-22 10:06:02 0x1DD4 20234 RTE MBLOCKDATA_SIZE=32768

2008-04-22 10:06:02 0x1DD4 20234 RTE MBLOCKQUAL_SIZE=32768

2008-04-22 10:06:02 0x1DD4 20234 RTE MBLOCKSTACK_SIZE=32768

2008-04-22 10:06:02 0x1DD4 20234 RTE MBLOCKSTRAT_SIZE=16384

2008-04-22 10:06:02 0x1DD4 20234 RTE MCOD=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE MEMORY_ALLOCATION_LIMIT=0

2008-04-22 10:06:02 0x1DD4 20234 RTE MINI_DUMP=NORMAL

2008-04-22 10:06:02 0x1DD4 20234 RTE MINREPLYSIZE=4096

2008-04-22 10:06:02 0x1DD4 20234 RTE MINSERVERTASKS=134

2008-04-22 10:06:02 0x1DD4 20234 RTE MIN_RETENTION_TIME=60

2008-04-22 10:06:02 0x1DD4 20234 RTE MONITOR_READ=2147483647

2008-04-22 10:06:02 0x1DD4 20234 RTE MONITOR_ROWNO=0

2008-04-22 10:06:02 0x1DD4 20234 RTE MONITOR_SELECTIVITY=0

2008-04-22 10:06:02 0x1DD4 20234 RTE MONITOR_TIME=2147483647

2008-04-22 10:06:02 0x1DD4 20234 RTE MPDISP_LOOPS=1

2008-04-22 10:06:02 0x1DD4 20234 RTE MPDISP_PRIO=DEFAULT

2008-04-22 10:06:02 0x1DD4 20234 RTE MPRGN_BUSY_WAIT=DEFAULT

2008-04-22 10:06:02 0x1DD4 20234 RTE MPRGN_DIRTY_READ=DEFAULT

2008-04-22 10:06:02 0x1DD4 20234 RTE MP_RGN_LOOP=-1

2008-04-22 10:06:02 0x1DD4 20234 RTE MPRGN_PRIO=DEFAULT

2008-04-22 10:06:02 0x1DD4 20234 RTE MPRGN_QUEUE=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OFFICIAL_NODE=

2008-04-22 10:06:02 0x1DD4 20234 RTE OMS_HEAP_BLOCKSIZE=10000

2008-04-22 10:06:02 0x1DD4 20234 RTE OMS_HEAP_COUNT=6

2008-04-22 10:06:02 0x1DD4 20234 RTE OMS_HEAP_LIMIT=0

2008-04-22 10:06:02 0x1DD4 20234 RTE OMS_HEAP_THRESHOLD=100

2008-04-22 10:06:02 0x1DD4 20234 RTE OMSREGIONS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE OMSRGNS=7

2008-04-22 10:06:02 0x1DD4 20234 RTE OMS_RUN_IN_UDE_SERVER=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE OMS_STREAM_TIMEOUT=30

2008-04-22 10:06:02 0x1DD4 20234 RTE OMS_VERS_THRESHOLD=2097152

2008-04-22 10:06:02 0x1DD4 20234 RTE ONLINE=1

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_AGGREGATION=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_FETCH_REVERSE=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_FIRST_ROWS=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_JOIN_HASHTABLE=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_JOIN_HASH_MINIMAL_RATIO=1

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_JOIN_ONEPHASE=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_JOIN_OPERATOR_SORT=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_JOIN_OUTER=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_JOIN_PARALLEL_MINSIZE=1000000

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_JOIN_PARALLEL_SERVERS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_MIN_MAX=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_OPERATOR_JOIN=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_QUAL_ON_INDEX=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_QUERYREWRITE=OPERATOR

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIMIZE_STAR_JOIN=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIM_CACHE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIM_INV_ONLY=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIM_JOIN_FETCH=0

2008-04-22 10:06:02 0x1DD4 20234 RTE OPTIM_MAX_MERGE=500

2008-04-22 10:06:02 0x1DD4 20234 RTE OUTOFSESSIONS=3

2008-04-22 10:06:02 0x1DD4 20234 RTE PACKETSIZE=131072

2008-04-22 10:06:02 0x1DD4 20234 RTE PAGESIZE=8192

2008-04-22 10:06:02 0x1DD4 20234 RTE PREALLOCATE_IOWORKER=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE PRIOBASE_COM=10

2008-04-22 10:06:02 0x1DD4 20234 RTE PRIOBASE_IOC=80

2008-04-22 10:06:02 0x1DD4 20234 RTE PRIOBASE_RAV=80

2008-04-22 10:06:02 0x1DD4 20234 RTE PRIOBASE_REX=40

2008-04-22 10:06:02 0x1DD4 20234 RTE PRIOBASE_U2U=100

2008-04-22 10:06:02 0x1DD4 20234 RTE PRIOFACTOR=80

2008-04-22 10:06:02 0x1DD4 20234 RTE PROTECT_DATACACHE_MEMORY=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE READAHEADBLOBS=32

2008-04-22 10:06:02 0x1DD4 20234 RTE REQUEST_TIMEOUT=5000

2008-04-22 10:06:02 0x1DD4 20234 RTE RESERVEDSERVERTASKS=69

2008-04-22 10:06:02 0x1DD4 20234 RTE RESTARTTIME=600

2008-04-22 10:06:02 0x1DD4 20234 RTE ROWRGNS=8

2008-04-22 10:06:02 0x1DD4 20234 RTE _RTEDUMPFILE=rtedump

2008-04-22 10:06:02 0x1DD4 20234 RTE RTE_TEST_REGIONS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE RUNDIRECTORY=C:\Program Files\sdb\data\wrk\PKM_1_D

2008-04-22 10:06:02 0x1DD4 20234 RTE SEQUENCE_CACHE=1

2008-04-22 10:06:02 0x1DD4 20234 RTE SERVERDBFOR_SAP=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE SESSION_TIMEOUT=900

2008-04-22 10:06:02 0x1DD4 20234 RTE SET_VOLUME_LOCK=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE SHAREDSQL_CLEANUPTHRESHOLD=25

2008-04-22 10:06:02 0x1DD4 20234 RTE SHAREDSQL_COMMANDCACHESIZE=262144

2008-04-22 10:06:02 0x1DD4 20234 RTE SHAREDSQL=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE SHOW_MAX_KB_STACK_USE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE SHOW_MAX_STACK_USE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE SPINLOCK_BACKOFF_BASE=1

2008-04-22 10:06:02 0x1DD4 20234 RTE SPINLOCK_BACKOFF_FACTOR=2

2008-04-22 10:06:02 0x1DD4 20234 RTE SPINLOCK_BACKOFF_MAXIMUM=64

2008-04-22 10:06:02 0x1DD4 20234 RTE SPINLOCK_LOOP_COUNT=30000

2008-04-22 10:06:02 0x1DD4 20234 RTE STANDBY=1

2008-04-22 10:06:02 0x1DD4 20234 RTE SUBTREE_LOCKS=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE SYMBOL_DEMANGLING=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE SYMBOL_RESOLUTION=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE SYSTEMERROR=3

2008-04-22 10:06:02 0x1DD4 20234 RTE TABRGNS=8

2008-04-22 10:06:02 0x1DD4 20234 RTE TASKCLUSTER01=tw;al;ut;2000sv,100bup;10ev,10gc;

2008-04-22 10:06:02 0x1DD4 20234 RTE TASKCLUSTER02=ti,100dw;84us;

2008-04-22 10:06:02 0x1DD4 20234 RTE TASKCLUSTER03=equalize

2008-04-22 10:06:02 0x1DD4 20234 RTE TIME_MEASUREMENT=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_AK=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_ALLOCATOR=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_CATALOG=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_CLIENTKERNELCOM=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_COMMON=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_COMMUNICATION=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_CONVERTER=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_DATACHAIN=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_DATAINDEX=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_DATAPAM=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_DATATREE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_DBPROC=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_DEFAULT=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_DELETE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_FBM=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_FILEDIR=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_FRAMECTRL=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_INDEX=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_INSERT=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_IOMAN=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_IPC=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_JOIN=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_KSQL=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_LOCK=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_LOGACTION=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_LOGHISTORY=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_LOGPAGE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_LOGTRANS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_LOGVOLUME=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_LONG=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_MEMORY=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_MESSAGES=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OBJECTCONTAINER=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OBJECT_ADD=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OBJECT_ALTER=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OBJECT_FREE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OBJECT_GET=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OBJECT=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_CONTAINERDIR=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_CONTEXT=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_ERROR=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_FLUSHCACHE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_INTERFACE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_KEYRANGE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_KEY=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_LOCK=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_MEMORY=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_NEWOBJ=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_SESSION=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_STREAM=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_VAROBJECT=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OMS_VERSION=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_OPTIMIZE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_ORDER_STANDARD=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_ORDER=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGER=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES_BUP=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES_EV=2

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES_GC=20

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES_LW=5

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES_PG=3

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES_SV=5

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES_TI=2

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES_US=10

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES_UT=5

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PAGES=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_PRIMARY_TREE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_QUERYREWRITE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_RUNTIME=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_SELECT=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_SHAREDSQL=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_SQLMANAGER=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_SRVTASKS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_STOP_ERRORCODE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_SYNCHRONISATION=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_SYSVIEW=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_TABLE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_TIME=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_UPDATE=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE TRACE_VOLUME=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRANS_HISTORY_SIZE=0

2008-04-22 10:06:02 0x1DD4 20234 RTE TRANSRGNS=8

2008-04-22 10:06:02 0x1DD4 20234 RTE TRANS_THRESHOLD_VALUE=60

2008-04-22 10:06:02 0x1DD4 20234 RTE UKT_CPU_RELATIONSHIP=NONE

2008-04-22 10:06:02 0x1DD4 20234 RTE _UNICODE=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE UPDATESTAT_PARALLEL_SERVERS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE UPDATESTAT_SAMPLE_ALGO=1

2008-04-22 10:06:02 0x1DD4 20234 RTE UPDSTATWANTED=1

2008-04-22 10:06:02 0x1DD4 20234 RTE USED_MAX_LOG_QUEUE_COUNT=6

2008-04-22 10:06:02 0x1DD4 20234 RTE USESELECTFETCH=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE USEVARIABLEINPUT=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE USEASYNC_IO=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE USE_BACKUP_SECURITY_DESCRIPTOR=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE USE_COROUTINES=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE USE_FIBERS=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE USEIOPROCS_ONLY=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE USE_OPEN_DIRECT=NO

2008-04-22 10:06:02 0x1DD4 20234 RTE USE_SYSTEM_PAGE_CACHE=YES

2008-04-22 10:06:02 0x1DD4 20234 RTE UTILITYPROTFILE=dbm.utl

2008-04-22 10:06:02 0x1DD4 20234 RTE UTILITY_PROTSIZE=100

2008-04-22 10:06:02 0x1DD4 20234 RTE VOLUMENO_BIT_COUNT=8

2008-04-22 10:06:02 0x1DD4 20234 RTE WORKDATASIZE=8192

2008-04-22 10:06:02 0x1DD4 20234 RTE WORKSTACKSIZE=8192

2008-04-22 10:06:02 0x1DD4 20234 RTE XP_CONVERTER_REGIONS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE XP_DATA_CACHE_RGNS=0

2008-04-22 10:06:02 0x1DD4 20234 RTE XP_MAXPAGER=0

Edited by: Joern Menkhoff on Aug 29, 2008 2:12 PM

Show replies
Show replies
lbreddemann
Active Contributor
‎09-01-2008 10:39 AM
0 Kudos

Hi Joern,

I took the effort and tried to reproduce this behavior but did not succeed.

As I don't know any code part that directly accesses just a windows drive but not a file, I assume the filemon output is incorrect here.

Please try to reproduce the whole thing and use the more current "Process Monitor" instead (www.sysinternals.com).

Make sure that the following fields are displayed:

Process Name

Sequence Number

Operation

Category

Path

Detail

Result

Relative Time

Duration

User Name

Process ID

Thread ID

Parent PID

Reproduce the issue, save the ProcMon-Data and send it to me via email.

Also you may want to install the current patch of MaxDB (available here from SDN) and check the paramter setup. The SDN Wiki for MaxDB holds some [recommendations|https://wiki.sdn.sap.com/wiki/x/mYfzAQ].

Best regards,

Lars

lbreddemann
Active Contributor
‎09-03-2008 2:05 PM
0 Kudos

Ok, just to update this thread, so that all readers can see, what recommendation I wrote back.

I got some screenshots and the parameter setup of the database.

The screenshots showed the Procmon and that the accesses of the KERNEL.EXE actually where to the file c:\pagefile.sys and not just to c:\. Therefore we can assume that there was some paging going on.

Checking the parameters we find that the DB has quite a lot of memory:

CACHE_SIZE=1000000 (pages) = 1000000 * 8KB = 8000000 KB = 7812,5 MB = 7,62 GB

just for the Cache and not including the task-specific memory needs (like Stack).

Also the instance in question runs on a old patch (7.6.02 Build 10) which has still some known bugs unfixed.

Bugs like [PTS 1149611|http://maxdb.sap.com/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1149611] that causes a memory leak if the parameter OPTIMIZE_OPERATOR_JOIN is set to YES (which is the case here)

Also HASHED_RESULTSET=YES is set and bug [PTS 1149231|http://maxdb.sap.com/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1149231] is present in that version of MaxDB and causing a high memory usage.

In general also the NON-SAP instances of MaxDB should setup the parameters as proposed in the [MaxDB Wiki|https://wiki.sdn.sap.com/wiki/x/mYfzAQ].

Since the mentioned bugs are fixed in the currently available MaxDB patch, I recommend to install this patch soon.

regards,

Lars

Former Member
‎09-03-2008 2:16 PM
0 Kudos

Thank you for your help.

We have already applied the suggested paramater changes and will closely watch the success.

When the error will not occur any more in the next few days i will mark the question as answered.

In addition to that we will upgrade the Database as soon as possible.

lbreddemann
Active Contributor
‎08-29-2008 11:56 AM
0 Kudos

Hi Joern,

first of all: there is no way to distinguish I/O for temporary data and I/O for permanent data.

So if the I/O really is due to a temporary data access is not sure.

Anyhow - there are some possible reasons why there might be a large usage of temporary data. Please post the parameter part of the knldiag file to the message.

BTW: what kind of RAID are you using on Volume E:\ ? Logfiles on e.g. RAID 5 is a pretty bad idea.

Ah - and yes: you already used Filemon to see massive I/O in the WORKDIRECTORY (do you mean RUNDIRECTORY?). Well there are usually only the tracefiles, so perhabs you've either lots of errors or something else is in there.

To what file is the I/O directed?

regards,

Lars

Show replies
Show replies
markus_doehr2
Active Contributor
‎08-29-2008 11:51 AM
0 Kudos

> We have got a problem (non SAP Application) concerning MaxDB temp space growing bigger than 1 GB in only a few seconds (using Version 7.6.02.10, Windows Server 2003 64 bit, Maxdb Cache Size=1000000 - 8GB, 16 GB RAM - usually 4GB free, Work-Dir on C:-Raid, All Data-Files and Log-Files on E:-Raid).

Can you tell us where you get the info that it's "temp" space?

Markus

Show replies
Show replies
Ask a Question