DB2在强行启动了过一会也会自己停掉
DB2在win服务器上启动不了了，重新启动过主机和数据库还是如此，没有使用归档也没有什么备份windows的服务器。即使强行启动了过一会也会自己停掉客户端就连不上了。DB2diaglog日志如下。
2013-03-05-12.43.04.365000+480 E2H858 LEVEL: Event
PID : 1916 TID : 2332 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5219 available:1884
Virtual Memory(MB): total:8007 free:11968
Swap Memory(MB): total:1863 free:6749
2013-03-05-12.43.05.568000+480 I862H1537 LEVEL: Event
PID : 420 TID : 3452 PROC : DB2START.EXE
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012ADB4 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012ADC4 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012ADD4 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AEA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-05-12.46.55.287000+480 I2401H365 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-05-12.46.55.333000+480 I2768H449 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
00000794472B9EF6
2013-03-05-12.46.55.333000+480 I3219H444 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-05-12.46.55.333000+480 E3665H439 LEVEL: Warning
PID : 1916 TID : 1708 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-05-12.46.58.177000+480 I4106H480 LEVEL: Error
PID : 1916 TID : 2764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.58.177000+480 I4588H480 LEVEL: Error
PID : 1916 TID : 3108 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.58.193000+480 I5070H1269 LEVEL: Severe
PID : 1916 TID : 2764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612700
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0d588000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612700 OPNum:2238108
begoff: 48
datlen: 16336
pagebinx: 1985
revnum: 1024
pagelsn: 079448EEDAF0 flag: 2
signature: 1316590786
cbits1to31: 5199c5a
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162764.000
2013-03-05-12.46.58.193000+480 I6341H1269 LEVEL: Severe
PID : 1916 TID : 3108 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612703
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0d668000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612703 OPNum:2238111
begoff: 48
datlen: 16336
pagebinx: 2041
revnum: 1024
pagelsn: 079448EFCB8D flag: 2
signature: 1316590786
cbits1to31: 3b608510
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB219163108.000
2013-03-05-12.46.58.927000+480 I7612H459 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is
"0000079449B3771E".
2013-03-05-12.46.58.927000+480 I8073H413 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : Crash recovery completed. Next LSN is 0000079449B3771E
2013-03-05-12.46.58.927000+480 E8488H421 LEVEL: Event
PID : 1916 TID : 2700 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-8 APPID: *LOCAL.DB2.130305044658
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1009
DATA #1 :
Starting STMM log from file number 763
2013-03-05-12.46.59.083000+480 I8911H480 LEVEL: Error
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.083000+480 I9393H1269 LEVEL: Severe
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612957
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0cf3c000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612957 OPNum:2238365
begoff: 48
datlen: 16336
pagebinx: 1582
revnum: 1024
pagelsn: 079449405D1C flag: 2
signature: 1316590786
cbits1to31: 4a598530
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162388.000
2013-03-05-12.46.59.349000+480 I10664H480 LEVEL: Error
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.349000+480 I11146H1273 LEVEL: Severe
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613003
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x118e8000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613003 OPNum:2238379
begoff: 48
datlen: 16336
pagebinx: 6289
revnum: 1024
pagelsn: 07944944DDD9 flag: 2
signature: 1316590786
cbits1to31: 4cc9136
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 16496, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162388.000
2013-03-05-12.46.59.583000+480 I12421H480 LEVEL: Error
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.583000+480 I12903H1273 LEVEL: Severe
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613058
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0bfcc000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613058 OPNum:2238434
begoff: 48
datlen: 16336
pagebinx: 594
revnum: 1024
pagelsn: 079449561EF0 flag: 2
signature: 1316590786
cbits1to31: 43a9b0e
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 32992, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162388.000
2013-03-05-12.46.59.818000+480 I14178H480 LEVEL: Error
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.818000+480 I14660H1273 LEVEL: Severe
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613073
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0d194000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613073 OPNum:2238449
begoff: 48
datlen: 16336
pagebinx: 1732
revnum: 1024
pagelsn: 0794495AD1B6 flag: 2
signature: 1316590786
cbits1to31: 43e94d6
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 49488, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162388.000
2013-03-05-12.46.59.927000+480 I15935H387 LEVEL: Error
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.927000+480 I16324H2395 LEVEL: Severe
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02D73EC4 : 0301 0000 0000 0000 00C0 7FF7 0900 0000 ................
0x02D73ED4 : 0000 0000 0000 0000 7C8F 596E E0DF 390B ........|.Yn..9.
0x02D73EE4 : A03E D702 0000 0000 343E D702 0080 660D .>......4>....f.
0x02D73EF4 : 0040 0000 100B 0000 0000 0000 60D5 EC11 .@..........`...
0x02D73F04 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612703
objectPageNum: 2238111
bucketGroupHashIndex: 724
hashnext: 0x11bc3d88
hashprev: 0x00000000
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0d668000
pinCount:
0x0B5E12F0 : 0000 0000 ....
dirtyprev: 0x0b5e19f8
dirtynext: 0x0b62c020
blockDesc: 0x00000000
pminlsn: 0000079448EF7DCB
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612703 OPNum:2238111
begoff: 48
datlen: 16336
pagebinx: 2041
revnum: 1024
pagelsn: 079448EFCB8D flag: a
signature: 1316590786
cbits1to31: 3b608510
cbits32to63: 0
2013-03-05-12.46.59.927000+480 I18721H368 LEVEL: Severe
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-05-12.46.59.927000+480 I19091H339 LEVEL: Severe
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11C8F440 : 0000 0000 ....
2013-03-05-12.46.59.927000+480 I19432H405 LEVEL: Warning
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11C8F314 : 0000 0000 ....
2013-03-05-12.48.01.208000+480 E19839H858 LEVEL: Event
PID : 1508 TID : 2016 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5255 available:1884
Virtual Memory(MB): total:8007 free:12033
Swap Memory(MB): total:1863 free:6778
2013-03-06-09.08.28.349000+480 I20699H360 LEVEL: Warning
PID : 1508 TID : 2352 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-09.08.28.490000+480 I21061H444 LEVEL: Warning
PID : 1508 TID : 2352 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448BCD0D4
2013-03-06-09.08.28.490000+480 I21507H439 LEVEL: Warning
PID : 1508 TID : 2352 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-09.08.28.490000+480 E21948H434 LEVEL: Warning
PID : 1508 TID : 3796 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-06-09.08.29.365000+480 I22384H372 LEVEL: Error
PID : 1508 TID : 888 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.365000+480 I22758H1160 LEVEL: Severe
PID : 1508 TID : 888 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612702
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0f738000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612702 OPNum:2238110
begoff: 48
datlen: 16336
pagebinx: 4133
revnum: 1024
pagelsn: 079448EF7B62 flag: 2
signature: 1316590786
cbits1to31: 18d1a431
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 38 bytes
D:PROGRA~1IBMSQLLIBDB21508888.000
2013-03-06-09.08.29.365000+480 I23920H377 LEVEL: Error
PID : 1508 TID : 888 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.568000+480 I24299H372 LEVEL: Error
PID : 1508 TID : 928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.568000+480 I24673H1160 LEVEL: Severe
PID : 1508 TID : 928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612701
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0f5f4000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612701 OPNum:2238109
begoff: 48
datlen: 16336
pagebinx: 4052
revnum: 1024
pagelsn: 079448EF2B1F flag: 2
signature: 1316590786
cbits1to31: 40724486
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 38 bytes
D:PROGRA~1IBMSQLLIBDB21508928.000
2013-03-06-09.08.29.568000+480 I25835H377 LEVEL: Error
PID : 1508 TID : 928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.724000+480 I26214H475 LEVEL: Error
PID : 1508 TID : 3636 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.724000+480 I26691H1264 LEVEL: Severe
PID : 1508 TID : 3636 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612719
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0ffac000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612719 OPNum:2238127
begoff: 48
datlen: 16336
pagebinx: 4674
revnum: 1024
pagelsn: 079448F4CEE5 flag: 2
signature: 1316590786
cbits1to31: 48110ad2
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB215083636.000
2013-03-06-09.08.29.927000+480 I27957H387 LEVEL: Error
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.927000+480 I28346H2395 LEVEL: Severe
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02D84614 : 0301 0000 0000 0000 0080 83F7 0900 0000 ................
0x02D84624 : 0000 0000 0000 0000 7C8F 596E D8E1 3B0B ........|.Yn..;.
0x02D84634 : F045 D802 0000 0000 8445 D802 0080 0210 .E.......E......
0x02D84644 : 0040 0000 100B 0000 0000 0000 20D5 E911 .@.......... ...
0x02D84654 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612718
objectPageNum: 2238126
bucketGroupHashIndex: 261
hashnext: 0x00000000
hashprev: 0x0b69bd30
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x10028000
pinCount:
0x0B66F790 : 0000 0000 ....
dirtyprev: 0x0b654420
dirtynext: 0x0b6503a8
blockDesc: 0x00000000
pminlsn: 0000079448F43136
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612718 OPNum:2238126
begoff: 48
datlen: 16336
pagebinx: 4689
revnum: 1024
pagelsn: 079448F47EC6 flag: 2
signature: 1316590786
cbits1to31: 265c651
cbits32to63: 0
2013-03-06-09.08.29.927000+480 I30743H368 LEVEL: Severe
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-09.08.29.927000+480 I31113H339 LEVEL: Severe
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11D0F35C : 0000 0000 ....
2013-03-06-09.08.29.927000+480 I31454H405 LEVEL: Warning
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11D0F230 : 0000 0000 ....
2013-03-06-09.09.31.318000+480 E31861H858 LEVEL: Event
PID : 2348 TID : 2052 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5159 available:1884
Virtual Memory(MB): total:8007 free:11936
Swap Memory(MB): total:1863 free:6777
2013-03-06-10.58.15.880000+480 I32721H1536 LEVEL: Event
PID : 3036 TID : 2556 PROC : db2stop.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012AD24 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012AD34 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012AD44 : 4F50 322E 4558 4500 4E4F 4D53 4700 464F OP2.EXE.NOMSG.FO
0x0012AD54 : 5243 4500 534E 0000 0000 0000 0000 0000 RCE.SN..........
0x0012AD64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADD4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-10.58.15.896000+480 I34259H387 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104
DATA #1 : String, 26 bytes
Force phase is in progress
DATA #2 : Hexdump, 4 bytes
0x02E8FECC : 0000 0000 ....
2013-03-06-10.58.15.896000+480 I34648H430 LEVEL: Event
PID : 2348 TID : 1012 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1000
DATA #1 : String, 47 bytes
[Force]->Number of applications to be forced :
DATA #2 : Hexdump, 4 bytes
0x01A0F8F8 : 0000 0000 ....
2013-03-06-10.58.15.912000+480 I35080H522 LEVEL: Event
PID : 2348 TID : 1012 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1020
DATA #1 : String, 49 bytes
[Force]->;Posting back to stop, no appls to force.
DATA #2 : Hexdump, 4 bytes
0x01A0F900 : 0000 0000 ....
DATA #3 : Hexdump, 4 bytes
0x01A0F8FC : 0200 0000 ....
2013-03-06-10.58.15.912000+480 I35604H313 LEVEL: Event
PID : 2348 TID : 1012 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1030
DATA #1 : String, 20 bytes
Clearing force flag.
2013-03-06-10.58.15.912000+480 I35919H318 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108
DATA #1 : String, 47 bytes
Force phase is completed and preparing to stop.
2013-03-06-10.58.15.912000+480 I36239H390 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0x02E8FEC4 : 0100 0000 ....
2013-03-06-10.58.15.912000+480 I36631H410 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0x02E8FEC4 : 0100 0000 ....
2013-03-06-10.58.15.912000+480 I37043H297 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2013-03-06-10.58.15.912000+480 I37342H312 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2013-03-06-10.58.15.927000+480 I37656H405 LEVEL: Warning
PID : 2348 TID : 1012 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x01A0FA64 : 0000 0000 ....
2013-03-06-10.58.15.958000+480 I38063H314 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2013-03-06-10.58.15.958000+480 I38379H385 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : Hexdump, 4 bytes
0x02E8FE6C : 0000 0000 ....
2013-03-06-10.58.16.037000+480 E38766H311 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2013-03-06-10.58.22.115000+480 I39079H1537 LEVEL: Event
PID : 672 TID : 3248 PROC : db2start.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012ADB4 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012ADC4 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012ADD4 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AEA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-10.58.23.380000+480 E40618H858 LEVEL: Event
PID : 516 TID : 2644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5166 available:1884
Virtual Memory(MB): total:8007 free:11881
Swap Memory(MB): total:1863 free:6715
2013-03-06-10.58.34.162000+480 I41478H365 LEVEL: Warning
PID : 516 TID : 2004 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-10.58.34.427000+480 I41845H449 LEVEL: Warning
PID : 516 TID : 2004 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448BCD0D4
2013-03-06-10.58.34.443000+480 I42296H444 LEVEL: Warning
PID : 516 TID : 2004 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-10.58.34.443000+480 E42742H439 LEVEL: Warning
PID : 516 TID : 2284 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3772938 from 6144000
2013-03-06-10.58.35.818000+480 I43183H480 LEVEL: Error
PID : 516 TID : 3428 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-10.58.35.818000+480 I43665H1268 LEVEL: Severe
PID : 516 TID : 3428 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612702
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0f710000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612702 OPNum:2238110
begoff: 48
datlen: 16336
pagebinx: 4131
revnum: 1024
pagelsn: 079448EF7B62 flag: 2
signature: 1316590786
cbits1to31: 18d1a431
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 38 bytes
D:PROGRA~1IBMSQLLIBDB25163428.000
2013-03-06-10.58.36.505000+480 I44935H387 LEVEL: Error
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-10.58.36.505000+480 I45324H2395 LEVEL: Severe
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02DF4854 : 0301 0000 0000 0000 00C0 83F7 0900 0000 ................
0x02DF4864 : 0000 0000 0000 0000 7C8F 596E D8E1 390B ........|.Yn..9.
0x02DF4874 : 3048 DF02 0000 0000 C447 DF02 0080 F00F 0H.......G......
0x02DF4884 : 0040 0000 080B 0000 0000 0000 E0D4 EC11 .@..............
0x02DF4894 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612719
objectPageNum: 2238127
bucketGroupHashIndex: 584
hashnext: 0x00000000
hashprev: 0x0b67bfa8
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0ff08000
pinCount:
0x0B6312F0 : 0000 0000 ....
dirtyprev: 0x0b632978
dirtynext: 0x0b630b68
blockDesc: 0x00000000
pminlsn: 0000079448F48145
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612719 OPNum:2238127
begoff: 48
datlen: 16336
pagebinx: 4641
revnum: 1024
pagelsn: 079448F4CEE5 flag: 2
signature: 1316590786
cbits1to31: 48110ad2
cbits32to63: 0
2013-03-06-10.58.36.505000+480 I47721H368 LEVEL: Severe
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-10.58.36.505000+480 I48091H339 LEVEL: Severe
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11CDF440 : 0000 0000 ....
2013-03-06-10.58.36.505000+480 I48432H405 LEVEL: Warning
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11CDF314 : 0000 0000 ....
2013-03-06-10.59.37.833000+480 E48839H858 LEVEL: Event
PID : 1324 TID : 4044 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5122 available:1884
Virtual Memory(MB): total:8007 free:11784
Swap Memory(MB): total:1863 free:6662
2013-03-06-11.09.24.427000+480 I49699H1536 LEVEL: Event
PID : 2988 TID : 864 PROC : db2stop.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012AD24 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012AD34 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012AD44 : 4F50 322E 4558 4500 4E4F 4D53 4700 464F OP2.EXE.NOMSG.FO
0x0012AD54 : 5243 4500 534E 0000 0000 0000 0000 0000 RCE.SN..........
0x0012AD64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADD4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-11.09.24.427000+480 I51237H387 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104
DATA #1 : String, 26 bytes
Force phase is in progress
DATA #2 : Hexdump, 4 bytes
0x02E0FECC : 0000 0000 ....
2013-03-06-11.09.24.427000+480 I51626H430 LEVEL: Event
PID : 1324 TID : 2088 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1000
DATA #1 : String, 47 bytes
[Force]->Number of applications to be forced :
DATA #2 : Hexdump, 4 bytes
0x01A0F8F8 : 0100 0000 ....
2013-03-06-11.09.24.427000+480 I52058H318 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108
DATA #1 : String, 47 bytes
Force phase is completed and preparing to stop.
2013-03-06-11.09.24.427000+480 I52378H390 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0x02E0FEC4 : 0100 0000 ....
2013-03-06-11.09.24.427000+480 I52770H410 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0x02E0FEC4 : 0100 0000 ....
2013-03-06-11.09.24.427000+480 I53182H297 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2013-03-06-11.09.24.427000+480 I53481H312 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2013-03-06-11.09.24.427000+480 I53795H405 LEVEL: Warning
PID : 1324 TID : 2088 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x01A0FA64 : 0000 0000 ....
2013-03-06-11.09.24.427000+480 I54202H314 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2013-03-06-11.09.24.427000+480 I54518H385 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : Hexdump, 4 bytes
0x02E0FE6C : 0000 0000 ....
2013-03-06-11.09.24.568000+480 E54905H311 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2013-03-06-11.09.30.521000+480 I55218H1537 LEVEL: Event
PID : 3332 TID : 2716 PROC : db2start.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012ADB4 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012ADC4 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012ADD4 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AEA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-11.09.31.724000+480 E56757H858 LEVEL: Event
PID : 3028 TID : 752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5161 available:1884
Virtual Memory(MB): total:8007 free:11869
Swap Memory(MB): total:1863 free:6708
2013-03-06-11.09.55.365000+480 I57617H365 LEVEL: Warning
PID : 3028 TID : 3920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-11.09.55.458000+480 I57984H449 LEVEL: Warning
PID : 3028 TID : 3920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448BCD0D4
2013-03-06-11.09.55.458000+480 I58435H444 LEVEL: Warning
PID : 3028 TID : 3920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-11.09.55.458000+480 E58881H439 LEVEL: Warning
PID : 3028 TID : 2316 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-06-11.09.56.349000+480 I59322H480 LEVEL: Error
PID : 3028 TID : 2216 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.09.56.349000+480 I59804H1269 LEVEL: Severe
PID : 3028 TID : 2216 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612716
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fdcc000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612716 OPNum:2238124
begoff: 48
datlen: 16336
pagebinx: 4562
revnum: 1024
pagelsn: 079448F3DE82 flag: 2
signature: 1316590786
cbits1to31: 6088230
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB230282216.000
2013-03-06-11.09.56.599000+480 I61075H387 LEVEL: Error
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.09.56.615000+480 I61464H2395 LEVEL: Severe
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02D74C44 : 0301 0000 0000 0000 0080 7FF7 0900 0000 ................
0x02D74C54 : 0000 0000 0000 0000 7C8F 596E E0DF 390B ........|.Yn..9.
0x02D74C64 : 204C D702 0000 0000 B44B D702 00C0 710F L.......K....q.
0x02D74C74 : 0040 0000 0C0B 0000 0000 0000 20D5 EC11 .@.......... ...
0x02D74C84 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612702
objectPageNum: 2238110
bucketGroupHashIndex: 401
hashnext: 0x11bcbca8
hashprev: 0x0b66c9e0
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0f71c000
pinCount:
0x0B6209C8 : 0000 0000 ....
dirtyprev: 0x0b622f58
dirtynext: 0x0b63f660
blockDesc: 0x00000000
pminlsn: 0000079448EF2D88
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612702 OPNum:2238110
begoff: 48
datlen: 16336
pagebinx: 4134
revnum: 1024
pagelsn: 079448EF7B62 flag: 2
signature: 1316590786
cbits1to31: 18d1a431
cbits32to63: 0
2013-03-06-11.09.56.615000+480 I63861H368 LEVEL: Severe
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-11.09.56.615000+480 I64231H339 LEVEL: Severe
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11C8F440 : 0000 0000 ....
2013-03-06-11.09.56.615000+480 I64572H405 LEVEL: Warning
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11C8F314 : 0000 0000 ....
2013-03-06-11.10.57.880000+480 E64979H858 LEVEL: Event
PID : 1416 TID : 2260 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5033 available:1884
Virtual Memory(MB): total:8007 free:11739
Swap Memory(MB): total:1863 free:6706
2013-03-06-11.12.10.146000+480 I65839H365 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-11.12.10.208000+480 I66206H449 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448BCD0D4
2013-03-06-11.12.10.208000+480 I66657H444 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-11.12.10.208000+480 E67103H439 LEVEL: Warning
PID : 1416 TID : 2424 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-06-11.12.10.787000+480 I67544H372 LEVEL: Error
PID : 1416 TID : 3780 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.10.787000+480 I67918H1161 LEVEL: Severe
PID : 1416 TID : 3780 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612716
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fd84000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612716 OPNum:2238124
begoff: 48
datlen: 16336
pagebinx: 4544
revnum: 1024
pagelsn: 079448F3DE82 flag: 2
signature: 1316590786
cbits1to31: 6088230
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB214163780.000
2013-03-06-11.12.10.787000+480 I69081H377 LEVEL: Error
PID : 1416 TID : 3780 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.11.115000+480 I69460H372 LEVEL: Error
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.11.115000+480 I69834H1161 LEVEL: Severe
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612700
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0f644000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612700 OPNum:2238108
begoff: 48
datlen: 16336
pagebinx: 4080
revnum: 1024
pagelsn: 079448EEDAF0 flag: 2
signature: 1316590786
cbits1to31: 5199c5a
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB214162456.000
2013-03-06-11.12.11.115000+480 I70997H377 LEVEL: Error
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.11.302000+480 I71376H372 LEVEL: Error
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.11.302000+480 I71750H1165 LEVEL: Severe
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612716
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fd84000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612716 OPNum:2238124
begoff: 48
datlen: 16336
pagebinx: 4544
revnum: 1024
pagelsn: 079448F3DE82 flag: a
signature: 1316590786
cbits1to31: 6088230
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 16496, 39 bytes
D:PROGRA~1IBMSQLLIBDB214162456.000
2013-03-06-11.12.11.302000+480 I72917H377 LEVEL: Error
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.12.240000+480 I73296H459 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is
"0000079449B3771E".
2013-03-06-11.12.12.240000+480 I73757H413 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : Crash recovery completed. Next LSN is 0000079449B3771E
2013-03-06-11.12.12.240000+480 E74172H421 LEVEL: Event
PID : 1416 TID : 664 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-8 APPID: *LOCAL.DB2.130306031212
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1009
DATA #1 :
Starting STMM log from file number 763
2013-03-06-11.12.12.271000+480 I74595H387 LEVEL: Error
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.12.271000+480 I74984H2395 LEVEL: Severe
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02DF47C4 : 0301 0000 0000 0000 00C0 83F7 0900 0000 ................
0x02DF47D4 : 0000 0000 0000 0000 7C8F 596E D8E1 390B ........|.Yn..9.
0x02DF47E4 : A047 DF02 0000 0000 3447 DF02 00C0 F40F .G......4G......
0x02DF47F4 : 0040 0000 080B 0000 0000 0000 E0D4 EC11 .@..............
0x02DF4804 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612719
objectPageNum: 2238127
bucketGroupHashIndex: 584
hashnext: 0x00000000
hashprev: 0x0b67b680
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0ff4c000
pinCount:
0x0B630BA8 : 0000 0000 ....
dirtyprev: 0x0b6312b0
dirtynext: 0x0b630c00
blockDesc: 0x00000000
pminlsn: 0000079448F48145
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612719 OPNum:2238127
begoff: 48
datlen: 16336
pagebinx: 4658
revnum: 1024
pagelsn: 079448F4CEE5 flag: 2
signature: 1316590786
cbits1to31: 48110ad2
cbits32to63: 0
2013-03-06-11.12.12.271000+480 I77381H368 LEVEL: Severe
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-11.12.12.271000+480 I77751H339 LEVEL: Severe
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11CDF440 : 0000 0000 ....
2013-03-06-11.12.12.271000+480 I78092H405 LEVEL: Warning
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11CDF314 : 0000 0000 ....
2013-03-06-11.13.13.537000+480 E78499H858 LEVEL: Event
PID : 1296 TID : 2648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5167 available:1884
Virtual Memory(MB): total:8007 free:11879
Swap Memory(MB): total:1863 free:6712
2013-03-06-14.47.55.162000+480 I79359H365 LEVEL: Warning
PID : 1296 TID : 2248 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-14.47.55.240000+480 I79726H449 LEVEL: Warning
PID : 1296 TID : 2248 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448CC54B7
2013-03-06-14.47.55.240000+480 I80177H444 LEVEL: Warning
PID : 1296 TID : 2248 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-14.47.55.240000+480 E80623H439 LEVEL: Warning
PID : 1296 TID : 1096 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-06-14.47.55.990000+480 I81064H372 LEVEL: Error
PID : 1296 TID : 3060 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.55.990000+480 I81438H480 LEVEL: Error
PID : 1296 TID : 3884 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.55.990000+480 I81920H480 LEVEL: Error
PID : 1296 TID : 2856 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.55.990000+480 I82402H1161 LEVEL: Severe
PID : 1296 TID : 3060 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613013
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x102c4000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613013 OPNum:2238389
begoff: 48
datlen: 16336
pagebinx: 4856
revnum: 1024
pagelsn: 07944948015C flag: 2
signature: 1316590786
cbits1to31: 1499811e
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212963060.000
2013-03-06-14.47.55.990000+480 I83565H377 LEVEL: Error
PID : 1296 TID : 3060 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.55.990000+480 I83944H480 LEVEL: Error
PID : 1296 TID : 2440 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.005000+480 I84426H1269 LEVEL: Severe
PID : 1296 TID : 3884 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612994
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fbc8000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612994 OPNum:2238370
begoff: 48
datlen: 16336
pagebinx: 4425
revnum: 1024
pagelsn: 079449420C39 flag: 2
signature: 1316590786
cbits1to31: 4a661c4e
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212963884.000
2013-03-06-14.47.56.005000+480 I85697H1269 LEVEL: Severe
PID : 1296 TID : 2856 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613004
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fe20000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613004 OPNum:2238380
begoff: 48
datlen: 16336
pagebinx: 4575
revnum: 1024
pagelsn: 079449452E29 flag: 2
signature: 1316590786
cbits1to31: 11b6b8c9
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212962856.000
2013-03-06-14.47.56.005000+480 I86968H480 LEVEL: Error
PID : 1296 TID : 2444 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.021000+480 I87450H1269 LEVEL: Severe
PID : 1296 TID : 2440 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613003
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0ff08000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613003 OPNum:2238379
begoff: 48
datlen: 16336
pagebinx: 4633
revnum: 1024
pagelsn: 07944944DDD9 flag: 2
signature: 1316590786
cbits1to31: 4cc9136
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212962440.000
2013-03-06-14.47.56.021000+480 I88721H480 LEVEL: Error
PID : 1296 TID : 2896 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.021000+480 I89203H1269 LEVEL: Severe
PID : 1296 TID : 2444 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613015
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x10554000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613015 OPNum:2238391
begoff: 48
datlen: 16336
pagebinx: 5020
revnum: 1024
pagelsn: 07944948A23C flag: 2
signature: 1316590786
cbits1to31: 9da029c
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212962444.000
2013-03-06-14.47.56.021000+480 I90474H1269 LEVEL: Severe
PID : 1296 TID : 2896 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613012
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x103d0000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613012 OPNum:2238388
begoff: 48
datlen: 16336
pagebinx: 4923
revnum: 1024
pagelsn: 07944947B107 flag: 2
signature: 1316590786
cbits1to31: c6a200a
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212962896.000
2013-03-06-14.47.56.068000+480 I91745H372 LEVEL: Error
PID : 1296 TID : 876 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.083000+480 I92119H1160 LEVEL: Severe
PID : 1296 TID : 876 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613007
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x100cc000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613007 OPNum:2238383
begoff: 48
datlen: 16336
pagebinx: 4730
revnum: 1024
pagelsn: 079449461F0C flag: 2
signature: 1316590786
cbits1to31: 10098c8a
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 38 bytes
D:PROGRA~1IBMSQLLIBDB21296876.000
2013-03-06-14.47.56.083000+480 I93281H377 LEVEL: Error
PID : 1296 TID : 876 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.162000+480 I93660H387 LEVEL: Error
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.162000+480 I94049H2395 LEVEL: Severe
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02E14074 : 0301 0000 0000 0000 0000 83F7 0900 0000 ................
0x02E14084 : 0000 0000 0000 0000 7C8F 596E D8E1 3B0B ........|.Yn..;.
0x02E14094 : 5040 E102 0000 0000 0000 0000 0000 440E P@............D.
0x02E140A4 : 0040 0000 080B 0000 0000 0000 E0D4 E911 .@..............
0x02E140B4 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612716
objectPageNum: 2238124
bucketGroupHashIndex: 86
hashnext: 0x00000000
hashprev: 0x0b6504b8
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0e440000
pinCount:
0x0B625F80 : 0000 0000 ....
dirtyprev: 0x0b625d60
dirtynext: 0x0b623790
blockDesc: 0x00000000
pminlsn: 0000079448F390EA
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612716 OPNum:2238124
begoff: 48
datlen: 16336
pagebinx: 2919
revnum: 1024
pagelsn: 079448F3DE82 flag: 2
signature: 1316590786
cbits1to31: 6088230
cbits32to63: 0
2013-03-06-14.47.56.162000+480 I96446H368 LEVEL: Severe
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-14.47.56.177000+480 I96816H339 LEVEL: Severe
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11D0F440 : 0000 0000 ....
2013-03-06-14.47.56.177000+480 I97157H405 LEVEL: Warning
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11D0F314 : 0000 0000 ....
2013-03-06-14.48.57.490000+480 E97564H858 LEVEL: Event
PID : 1108 TID : 2056 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5117 available:1884
Virtual Memory(MB): total:8007 free:11780
Swap Memory(MB): total:1863 free:6663
2013-03-06-16.53.14.146000+480 I98424H1536 LEVEL: Event
PID : 2676 TID : 780 PROC : db2stop.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012AD24 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012AD34 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012AD44 : 4F50 322E 4558 4500 4E4F 4D53 4700 534E OP2.EXE.NOMSG.SN
0x0012AD54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADD4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-16.53.14.162000+480 I99962H390 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0x02E5FEC4 : 0100 0000 ....
2013-03-06-16.53.14.162000+480 I100354H410 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0x02E5FEC4 : 0100 0000 ....
2013-03-06-16.53.14.162000+480 I100766H297 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2013-03-06-16.53.14.162000+480 I101065H312 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2013-03-06-16.53.14.162000+480 I101379H405 LEVEL: Warning
PID : 1108 TID : 2016 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x01A0FA64 : 0000 0000 ....
2013-03-06-16.53.14.177000+480 I101786H314 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2013-03-06-16.53.14.177000+480 I102102H385 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : Hexdump, 4 bytes
0x02E5FE6C : 0000 0000 ....
2013-03-06-16.53.14.380000+480 E102489H311 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2013-03-06-16.54.23.443000+480 I102802H1537 LEVEL: Event
PID : 2652 TID : 4076 PROC : db2start.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012ADB4 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012ADC4 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012ADD4 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AEA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-16.54.24.755000+480 E104341H858 LEVEL: Event
PID : 2332 TID : 2820 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5140 available:1884
Virtual Memory(MB): total:8007 free:11842
Swap Memory(MB): total:1863 free:6702
该怎么办呢？
2013-03-05-12.43.04.365000+480 E2H858 LEVEL: Event
PID : 1916 TID : 2332 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5219 available:1884
Virtual Memory(MB): total:8007 free:11968
Swap Memory(MB): total:1863 free:6749
2013-03-05-12.43.05.568000+480 I862H1537 LEVEL: Event
PID : 420 TID : 3452 PROC : DB2START.EXE
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012ADB4 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012ADC4 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012ADD4 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AEA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-05-12.46.55.287000+480 I2401H365 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-05-12.46.55.333000+480 I2768H449 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
00000794472B9EF6
2013-03-05-12.46.55.333000+480 I3219H444 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-05-12.46.55.333000+480 E3665H439 LEVEL: Warning
PID : 1916 TID : 1708 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-05-12.46.58.177000+480 I4106H480 LEVEL: Error
PID : 1916 TID : 2764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.58.177000+480 I4588H480 LEVEL: Error
PID : 1916 TID : 3108 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.58.193000+480 I5070H1269 LEVEL: Severe
PID : 1916 TID : 2764 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612700
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0d588000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612700 OPNum:2238108
begoff: 48
datlen: 16336
pagebinx: 1985
revnum: 1024
pagelsn: 079448EEDAF0 flag: 2
signature: 1316590786
cbits1to31: 5199c5a
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162764.000
2013-03-05-12.46.58.193000+480 I6341H1269 LEVEL: Severe
PID : 1916 TID : 3108 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612703
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0d668000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612703 OPNum:2238111
begoff: 48
datlen: 16336
pagebinx: 2041
revnum: 1024
pagelsn: 079448EFCB8D flag: 2
signature: 1316590786
cbits1to31: 3b608510
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB219163108.000
2013-03-05-12.46.58.927000+480 I7612H459 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is
"0000079449B3771E".
2013-03-05-12.46.58.927000+480 I8073H413 LEVEL: Warning
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : Crash recovery completed. Next LSN is 0000079449B3771E
2013-03-05-12.46.58.927000+480 E8488H421 LEVEL: Event
PID : 1916 TID : 2700 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-8 APPID: *LOCAL.DB2.130305044658
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1009
DATA #1 :
Starting STMM log from file number 763
2013-03-05-12.46.59.083000+480 I8911H480 LEVEL: Error
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.083000+480 I9393H1269 LEVEL: Severe
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612957
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0cf3c000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612957 OPNum:2238365
begoff: 48
datlen: 16336
pagebinx: 1582
revnum: 1024
pagelsn: 079449405D1C flag: 2
signature: 1316590786
cbits1to31: 4a598530
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162388.000
2013-03-05-12.46.59.349000+480 I10664H480 LEVEL: Error
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.349000+480 I11146H1273 LEVEL: Severe
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613003
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x118e8000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613003 OPNum:2238379
begoff: 48
datlen: 16336
pagebinx: 6289
revnum: 1024
pagelsn: 07944944DDD9 flag: 2
signature: 1316590786
cbits1to31: 4cc9136
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 16496, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162388.000
2013-03-05-12.46.59.583000+480 I12421H480 LEVEL: Error
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.583000+480 I12903H1273 LEVEL: Severe
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613058
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0bfcc000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613058 OPNum:2238434
begoff: 48
datlen: 16336
pagebinx: 594
revnum: 1024
pagelsn: 079449561EF0 flag: 2
signature: 1316590786
cbits1to31: 43a9b0e
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 32992, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162388.000
2013-03-05-12.46.59.818000+480 I14178H480 LEVEL: Error
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.818000+480 I14660H1273 LEVEL: Severe
PID : 1916 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613073
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0d194000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613073 OPNum:2238449
begoff: 48
datlen: 16336
pagebinx: 1732
revnum: 1024
pagelsn: 0794495AD1B6 flag: 2
signature: 1316590786
cbits1to31: 43e94d6
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 49488, 39 bytes
D:PROGRA~1IBMSQLLIBDB219162388.000
2013-03-05-12.46.59.927000+480 I15935H387 LEVEL: Error
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-05-12.46.59.927000+480 I16324H2395 LEVEL: Severe
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02D73EC4 : 0301 0000 0000 0000 00C0 7FF7 0900 0000 ................
0x02D73ED4 : 0000 0000 0000 0000 7C8F 596E E0DF 390B ........|.Yn..9.
0x02D73EE4 : A03E D702 0000 0000 343E D702 0080 660D .>......4>....f.
0x02D73EF4 : 0040 0000 100B 0000 0000 0000 60D5 EC11 .@..........`...
0x02D73F04 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612703
objectPageNum: 2238111
bucketGroupHashIndex: 724
hashnext: 0x11bc3d88
hashprev: 0x00000000
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0d668000
pinCount:
0x0B5E12F0 : 0000 0000 ....
dirtyprev: 0x0b5e19f8
dirtynext: 0x0b62c020
blockDesc: 0x00000000
pminlsn: 0000079448EF7DCB
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612703 OPNum:2238111
begoff: 48
datlen: 16336
pagebinx: 2041
revnum: 1024
pagelsn: 079448EFCB8D flag: a
signature: 1316590786
cbits1to31: 3b608510
cbits32to63: 0
2013-03-05-12.46.59.927000+480 I18721H368 LEVEL: Severe
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-05-12.46.59.927000+480 I19091H339 LEVEL: Severe
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11C8F440 : 0000 0000 ....
2013-03-05-12.46.59.927000+480 I19432H405 LEVEL: Warning
PID : 1916 TID : 1648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11C8F314 : 0000 0000 ....
2013-03-05-12.48.01.208000+480 E19839H858 LEVEL: Event
PID : 1508 TID : 2016 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5255 available:1884
Virtual Memory(MB): total:8007 free:12033
Swap Memory(MB): total:1863 free:6778
2013-03-06-09.08.28.349000+480 I20699H360 LEVEL: Warning
PID : 1508 TID : 2352 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-09.08.28.490000+480 I21061H444 LEVEL: Warning
PID : 1508 TID : 2352 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448BCD0D4
2013-03-06-09.08.28.490000+480 I21507H439 LEVEL: Warning
PID : 1508 TID : 2352 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-09.08.28.490000+480 E21948H434 LEVEL: Warning
PID : 1508 TID : 3796 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-06-09.08.29.365000+480 I22384H372 LEVEL: Error
PID : 1508 TID : 888 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.365000+480 I22758H1160 LEVEL: Severe
PID : 1508 TID : 888 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612702
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0f738000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612702 OPNum:2238110
begoff: 48
datlen: 16336
pagebinx: 4133
revnum: 1024
pagelsn: 079448EF7B62 flag: 2
signature: 1316590786
cbits1to31: 18d1a431
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 38 bytes
D:PROGRA~1IBMSQLLIBDB21508888.000
2013-03-06-09.08.29.365000+480 I23920H377 LEVEL: Error
PID : 1508 TID : 888 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.568000+480 I24299H372 LEVEL: Error
PID : 1508 TID : 928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.568000+480 I24673H1160 LEVEL: Severe
PID : 1508 TID : 928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612701
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0f5f4000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612701 OPNum:2238109
begoff: 48
datlen: 16336
pagebinx: 4052
revnum: 1024
pagelsn: 079448EF2B1F flag: 2
signature: 1316590786
cbits1to31: 40724486
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 38 bytes
D:PROGRA~1IBMSQLLIBDB21508928.000
2013-03-06-09.08.29.568000+480 I25835H377 LEVEL: Error
PID : 1508 TID : 928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.724000+480 I26214H475 LEVEL: Error
PID : 1508 TID : 3636 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.724000+480 I26691H1264 LEVEL: Severe
PID : 1508 TID : 3636 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-414 APPID: *LOCAL.DB2.130306010827
AUTHID : DB_SJPT
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612719
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0ffac000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612719 OPNum:2238127
begoff: 48
datlen: 16336
pagebinx: 4674
revnum: 1024
pagelsn: 079448F4CEE5 flag: 2
signature: 1316590786
cbits1to31: 48110ad2
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB215083636.000
2013-03-06-09.08.29.927000+480 I27957H387 LEVEL: Error
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-09.08.29.927000+480 I28346H2395 LEVEL: Severe
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02D84614 : 0301 0000 0000 0000 0080 83F7 0900 0000 ................
0x02D84624 : 0000 0000 0000 0000 7C8F 596E D8E1 3B0B ........|.Yn..;.
0x02D84634 : F045 D802 0000 0000 8445 D802 0080 0210 .E.......E......
0x02D84644 : 0040 0000 100B 0000 0000 0000 20D5 E911 .@.......... ...
0x02D84654 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612718
objectPageNum: 2238126
bucketGroupHashIndex: 261
hashnext: 0x00000000
hashprev: 0x0b69bd30
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x10028000
pinCount:
0x0B66F790 : 0000 0000 ....
dirtyprev: 0x0b654420
dirtynext: 0x0b6503a8
blockDesc: 0x00000000
pminlsn: 0000079448F43136
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612718 OPNum:2238126
begoff: 48
datlen: 16336
pagebinx: 4689
revnum: 1024
pagelsn: 079448F47EC6 flag: 2
signature: 1316590786
cbits1to31: 265c651
cbits32to63: 0
2013-03-06-09.08.29.927000+480 I30743H368 LEVEL: Severe
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-09.08.29.927000+480 I31113H339 LEVEL: Severe
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11D0F35C : 0000 0000 ....
2013-03-06-09.08.29.927000+480 I31454H405 LEVEL: Warning
PID : 1508 TID : 2976 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11D0F230 : 0000 0000 ....
2013-03-06-09.09.31.318000+480 E31861H858 LEVEL: Event
PID : 2348 TID : 2052 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5159 available:1884
Virtual Memory(MB): total:8007 free:11936
Swap Memory(MB): total:1863 free:6777
2013-03-06-10.58.15.880000+480 I32721H1536 LEVEL: Event
PID : 3036 TID : 2556 PROC : db2stop.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012AD24 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012AD34 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012AD44 : 4F50 322E 4558 4500 4E4F 4D53 4700 464F OP2.EXE.NOMSG.FO
0x0012AD54 : 5243 4500 534E 0000 0000 0000 0000 0000 RCE.SN..........
0x0012AD64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADD4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-10.58.15.896000+480 I34259H387 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104
DATA #1 : String, 26 bytes
Force phase is in progress
DATA #2 : Hexdump, 4 bytes
0x02E8FECC : 0000 0000 ....
2013-03-06-10.58.15.896000+480 I34648H430 LEVEL: Event
PID : 2348 TID : 1012 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1000
DATA #1 : String, 47 bytes
[Force]->Number of applications to be forced :
DATA #2 : Hexdump, 4 bytes
0x01A0F8F8 : 0000 0000 ....
2013-03-06-10.58.15.912000+480 I35080H522 LEVEL: Event
PID : 2348 TID : 1012 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1020
DATA #1 : String, 49 bytes
[Force]->;Posting back to stop, no appls to force.
DATA #2 : Hexdump, 4 bytes
0x01A0F900 : 0000 0000 ....
DATA #3 : Hexdump, 4 bytes
0x01A0F8FC : 0200 0000 ....
2013-03-06-10.58.15.912000+480 I35604H313 LEVEL: Event
PID : 2348 TID : 1012 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1030
DATA #1 : String, 20 bytes
Clearing force flag.
2013-03-06-10.58.15.912000+480 I35919H318 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108
DATA #1 : String, 47 bytes
Force phase is completed and preparing to stop.
2013-03-06-10.58.15.912000+480 I36239H390 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0x02E8FEC4 : 0100 0000 ....
2013-03-06-10.58.15.912000+480 I36631H410 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0x02E8FEC4 : 0100 0000 ....
2013-03-06-10.58.15.912000+480 I37043H297 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2013-03-06-10.58.15.912000+480 I37342H312 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2013-03-06-10.58.15.927000+480 I37656H405 LEVEL: Warning
PID : 2348 TID : 1012 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x01A0FA64 : 0000 0000 ....
2013-03-06-10.58.15.958000+480 I38063H314 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2013-03-06-10.58.15.958000+480 I38379H385 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : Hexdump, 4 bytes
0x02E8FE6C : 0000 0000 ....
2013-03-06-10.58.16.037000+480 E38766H311 LEVEL: Event
PID : 2348 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2013-03-06-10.58.22.115000+480 I39079H1537 LEVEL: Event
PID : 672 TID : 3248 PROC : db2start.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012ADB4 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012ADC4 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012ADD4 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AEA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-10.58.23.380000+480 E40618H858 LEVEL: Event
PID : 516 TID : 2644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5166 available:1884
Virtual Memory(MB): total:8007 free:11881
Swap Memory(MB): total:1863 free:6715
2013-03-06-10.58.34.162000+480 I41478H365 LEVEL: Warning
PID : 516 TID : 2004 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-10.58.34.427000+480 I41845H449 LEVEL: Warning
PID : 516 TID : 2004 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448BCD0D4
2013-03-06-10.58.34.443000+480 I42296H444 LEVEL: Warning
PID : 516 TID : 2004 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-10.58.34.443000+480 E42742H439 LEVEL: Warning
PID : 516 TID : 2284 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3772938 from 6144000
2013-03-06-10.58.35.818000+480 I43183H480 LEVEL: Error
PID : 516 TID : 3428 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-10.58.35.818000+480 I43665H1268 LEVEL: Severe
PID : 516 TID : 3428 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306025833
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612702
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0f710000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612702 OPNum:2238110
begoff: 48
datlen: 16336
pagebinx: 4131
revnum: 1024
pagelsn: 079448EF7B62 flag: 2
signature: 1316590786
cbits1to31: 18d1a431
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 38 bytes
D:PROGRA~1IBMSQLLIBDB25163428.000
2013-03-06-10.58.36.505000+480 I44935H387 LEVEL: Error
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-10.58.36.505000+480 I45324H2395 LEVEL: Severe
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02DF4854 : 0301 0000 0000 0000 00C0 83F7 0900 0000 ................
0x02DF4864 : 0000 0000 0000 0000 7C8F 596E D8E1 390B ........|.Yn..9.
0x02DF4874 : 3048 DF02 0000 0000 C447 DF02 0080 F00F 0H.......G......
0x02DF4884 : 0040 0000 080B 0000 0000 0000 E0D4 EC11 .@..............
0x02DF4894 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612719
objectPageNum: 2238127
bucketGroupHashIndex: 584
hashnext: 0x00000000
hashprev: 0x0b67bfa8
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0ff08000
pinCount:
0x0B6312F0 : 0000 0000 ....
dirtyprev: 0x0b632978
dirtynext: 0x0b630b68
blockDesc: 0x00000000
pminlsn: 0000079448F48145
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612719 OPNum:2238127
begoff: 48
datlen: 16336
pagebinx: 4641
revnum: 1024
pagelsn: 079448F4CEE5 flag: 2
signature: 1316590786
cbits1to31: 48110ad2
cbits32to63: 0
2013-03-06-10.58.36.505000+480 I47721H368 LEVEL: Severe
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-10.58.36.505000+480 I48091H339 LEVEL: Severe
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11CDF440 : 0000 0000 ....
2013-03-06-10.58.36.505000+480 I48432H405 LEVEL: Warning
PID : 516 TID : 2928 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11CDF314 : 0000 0000 ....
2013-03-06-10.59.37.833000+480 E48839H858 LEVEL: Event
PID : 1324 TID : 4044 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5122 available:1884
Virtual Memory(MB): total:8007 free:11784
Swap Memory(MB): total:1863 free:6662
2013-03-06-11.09.24.427000+480 I49699H1536 LEVEL: Event
PID : 2988 TID : 864 PROC : db2stop.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012AD24 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012AD34 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012AD44 : 4F50 322E 4558 4500 4E4F 4D53 4700 464F OP2.EXE.NOMSG.FO
0x0012AD54 : 5243 4500 534E 0000 0000 0000 0000 0000 RCE.SN..........
0x0012AD64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADD4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-11.09.24.427000+480 I51237H387 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104
DATA #1 : String, 26 bytes
Force phase is in progress
DATA #2 : Hexdump, 4 bytes
0x02E0FECC : 0000 0000 ....
2013-03-06-11.09.24.427000+480 I51626H430 LEVEL: Event
PID : 1324 TID : 2088 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1000
DATA #1 : String, 47 bytes
[Force]->Number of applications to be forced :
DATA #2 : Hexdump, 4 bytes
0x01A0F8F8 : 0100 0000 ....
2013-03-06-11.09.24.427000+480 I52058H318 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108
DATA #1 : String, 47 bytes
Force phase is completed and preparing to stop.
2013-03-06-11.09.24.427000+480 I52378H390 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0x02E0FEC4 : 0100 0000 ....
2013-03-06-11.09.24.427000+480 I52770H410 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0x02E0FEC4 : 0100 0000 ....
2013-03-06-11.09.24.427000+480 I53182H297 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2013-03-06-11.09.24.427000+480 I53481H312 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2013-03-06-11.09.24.427000+480 I53795H405 LEVEL: Warning
PID : 1324 TID : 2088 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x01A0FA64 : 0000 0000 ....
2013-03-06-11.09.24.427000+480 I54202H314 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2013-03-06-11.09.24.427000+480 I54518H385 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : Hexdump, 4 bytes
0x02E0FE6C : 0000 0000 ....
2013-03-06-11.09.24.568000+480 E54905H311 LEVEL: Event
PID : 1324 TID : 1680 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2013-03-06-11.09.30.521000+480 I55218H1537 LEVEL: Event
PID : 3332 TID : 2716 PROC : db2start.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012ADB4 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012ADC4 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012ADD4 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AEA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-11.09.31.724000+480 E56757H858 LEVEL: Event
PID : 3028 TID : 752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5161 available:1884
Virtual Memory(MB): total:8007 free:11869
Swap Memory(MB): total:1863 free:6708
2013-03-06-11.09.55.365000+480 I57617H365 LEVEL: Warning
PID : 3028 TID : 3920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-11.09.55.458000+480 I57984H449 LEVEL: Warning
PID : 3028 TID : 3920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448BCD0D4
2013-03-06-11.09.55.458000+480 I58435H444 LEVEL: Warning
PID : 3028 TID : 3920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-11.09.55.458000+480 E58881H439 LEVEL: Warning
PID : 3028 TID : 2316 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-06-11.09.56.349000+480 I59322H480 LEVEL: Error
PID : 3028 TID : 2216 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.09.56.349000+480 I59804H1269 LEVEL: Severe
PID : 3028 TID : 2216 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306030954
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612716
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fdcc000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612716 OPNum:2238124
begoff: 48
datlen: 16336
pagebinx: 4562
revnum: 1024
pagelsn: 079448F3DE82 flag: 2
signature: 1316590786
cbits1to31: 6088230
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB230282216.000
2013-03-06-11.09.56.599000+480 I61075H387 LEVEL: Error
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.09.56.615000+480 I61464H2395 LEVEL: Severe
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02D74C44 : 0301 0000 0000 0000 0080 7FF7 0900 0000 ................
0x02D74C54 : 0000 0000 0000 0000 7C8F 596E E0DF 390B ........|.Yn..9.
0x02D74C64 : 204C D702 0000 0000 B44B D702 00C0 710F L.......K....q.
0x02D74C74 : 0040 0000 0C0B 0000 0000 0000 20D5 EC11 .@.......... ...
0x02D74C84 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612702
objectPageNum: 2238110
bucketGroupHashIndex: 401
hashnext: 0x11bcbca8
hashprev: 0x0b66c9e0
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0f71c000
pinCount:
0x0B6209C8 : 0000 0000 ....
dirtyprev: 0x0b622f58
dirtynext: 0x0b63f660
blockDesc: 0x00000000
pminlsn: 0000079448EF2D88
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612702 OPNum:2238110
begoff: 48
datlen: 16336
pagebinx: 4134
revnum: 1024
pagelsn: 079448EF7B62 flag: 2
signature: 1316590786
cbits1to31: 18d1a431
cbits32to63: 0
2013-03-06-11.09.56.615000+480 I63861H368 LEVEL: Severe
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-11.09.56.615000+480 I64231H339 LEVEL: Severe
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11C8F440 : 0000 0000 ....
2013-03-06-11.09.56.615000+480 I64572H405 LEVEL: Warning
PID : 3028 TID : 1572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11C8F314 : 0000 0000 ....
2013-03-06-11.10.57.880000+480 E64979H858 LEVEL: Event
PID : 1416 TID : 2260 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5033 available:1884
Virtual Memory(MB): total:8007 free:11739
Swap Memory(MB): total:1863 free:6706
2013-03-06-11.12.10.146000+480 I65839H365 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-11.12.10.208000+480 I66206H449 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448BCD0D4
2013-03-06-11.12.10.208000+480 I66657H444 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-11.12.10.208000+480 E67103H439 LEVEL: Warning
PID : 1416 TID : 2424 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-06-11.12.10.787000+480 I67544H372 LEVEL: Error
PID : 1416 TID : 3780 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.10.787000+480 I67918H1161 LEVEL: Severe
PID : 1416 TID : 3780 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612716
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fd84000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612716 OPNum:2238124
begoff: 48
datlen: 16336
pagebinx: 4544
revnum: 1024
pagelsn: 079448F3DE82 flag: 2
signature: 1316590786
cbits1to31: 6088230
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB214163780.000
2013-03-06-11.12.10.787000+480 I69081H377 LEVEL: Error
PID : 1416 TID : 3780 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.11.115000+480 I69460H372 LEVEL: Error
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.11.115000+480 I69834H1161 LEVEL: Severe
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612700
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0f644000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612700 OPNum:2238108
begoff: 48
datlen: 16336
pagebinx: 4080
revnum: 1024
pagelsn: 079448EEDAF0 flag: 2
signature: 1316590786
cbits1to31: 5199c5a
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB214162456.000
2013-03-06-11.12.11.115000+480 I70997H377 LEVEL: Error
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.11.302000+480 I71376H372 LEVEL: Error
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.11.302000+480 I71750H1165 LEVEL: Severe
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612716
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fd84000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612716 OPNum:2238124
begoff: 48
datlen: 16336
pagebinx: 4544
revnum: 1024
pagelsn: 079448F3DE82 flag: a
signature: 1316590786
cbits1to31: 6088230
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 16496, 39 bytes
D:PROGRA~1IBMSQLLIBDB214162456.000
2013-03-06-11.12.11.302000+480 I72917H377 LEVEL: Error
PID : 1416 TID : 2456 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.12.240000+480 I73296H459 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is
"0000079449B3771E".
2013-03-06-11.12.12.240000+480 I73757H413 LEVEL: Warning
PID : 1416 TID : 2572 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130306031209
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : Crash recovery completed. Next LSN is 0000079449B3771E
2013-03-06-11.12.12.240000+480 E74172H421 LEVEL: Event
PID : 1416 TID : 664 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-8 APPID: *LOCAL.DB2.130306031212
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1009
DATA #1 :
Starting STMM log from file number 763
2013-03-06-11.12.12.271000+480 I74595H387 LEVEL: Error
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-11.12.12.271000+480 I74984H2395 LEVEL: Severe
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02DF47C4 : 0301 0000 0000 0000 00C0 83F7 0900 0000 ................
0x02DF47D4 : 0000 0000 0000 0000 7C8F 596E D8E1 390B ........|.Yn..9.
0x02DF47E4 : A047 DF02 0000 0000 3447 DF02 00C0 F40F .G......4G......
0x02DF47F4 : 0040 0000 080B 0000 0000 0000 E0D4 EC11 .@..............
0x02DF4804 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612719
objectPageNum: 2238127
bucketGroupHashIndex: 584
hashnext: 0x00000000
hashprev: 0x0b67b680
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0ff4c000
pinCount:
0x0B630BA8 : 0000 0000 ....
dirtyprev: 0x0b6312b0
dirtynext: 0x0b630c00
blockDesc: 0x00000000
pminlsn: 0000079448F48145
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612719 OPNum:2238127
begoff: 48
datlen: 16336
pagebinx: 4658
revnum: 1024
pagelsn: 079448F4CEE5 flag: 2
signature: 1316590786
cbits1to31: 48110ad2
cbits32to63: 0
2013-03-06-11.12.12.271000+480 I77381H368 LEVEL: Severe
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-11.12.12.271000+480 I77751H339 LEVEL: Severe
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11CDF440 : 0000 0000 ....
2013-03-06-11.12.12.271000+480 I78092H405 LEVEL: Warning
PID : 1416 TID : 1560 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11CDF314 : 0000 0000 ....
2013-03-06-11.13.13.537000+480 E78499H858 LEVEL: Event
PID : 1296 TID : 2648 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5167 available:1884
Virtual Memory(MB): total:8007 free:11879
Swap Memory(MB): total:1863 free:6712
2013-03-06-14.47.55.162000+480 I79359H365 LEVEL: Warning
PID : 1296 TID : 2248 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2013-03-06-14.47.55.240000+480 I79726H449 LEVEL: Warning
PID : 1296 TID : 2248 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000079449B3771E MinbuffLSN
0000079448CC54B7
2013-03-06-14.47.55.240000+480 I80177H444 LEVEL: Warning
PID : 1296 TID : 2248 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 6 chunks
2013-03-06-14.47.55.240000+480 E80623H439 LEVEL: Warning
PID : 1296 TID : 1096 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 :
Resetting max shredder memory to 3773150 from 6144000
2013-03-06-14.47.55.990000+480 I81064H372 LEVEL: Error
PID : 1296 TID : 3060 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.55.990000+480 I81438H480 LEVEL: Error
PID : 1296 TID : 3884 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.55.990000+480 I81920H480 LEVEL: Error
PID : 1296 TID : 2856 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.55.990000+480 I82402H1161 LEVEL: Severe
PID : 1296 TID : 3060 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613013
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x102c4000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613013 OPNum:2238389
begoff: 48
datlen: 16336
pagebinx: 4856
revnum: 1024
pagelsn: 07944948015C flag: 2
signature: 1316590786
cbits1to31: 1499811e
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212963060.000
2013-03-06-14.47.55.990000+480 I83565H377 LEVEL: Error
PID : 1296 TID : 3060 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.55.990000+480 I83944H480 LEVEL: Error
PID : 1296 TID : 2440 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.005000+480 I84426H1269 LEVEL: Severe
PID : 1296 TID : 3884 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2612994
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fbc8000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612994 OPNum:2238370
begoff: 48
datlen: 16336
pagebinx: 4425
revnum: 1024
pagelsn: 079449420C39 flag: 2
signature: 1316590786
cbits1to31: 4a661c4e
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212963884.000
2013-03-06-14.47.56.005000+480 I85697H1269 LEVEL: Severe
PID : 1296 TID : 2856 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613004
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0fe20000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613004 OPNum:2238380
begoff: 48
datlen: 16336
pagebinx: 4575
revnum: 1024
pagelsn: 079449452E29 flag: 2
signature: 1316590786
cbits1to31: 11b6b8c9
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212962856.000
2013-03-06-14.47.56.005000+480 I86968H480 LEVEL: Error
PID : 1296 TID : 2444 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.021000+480 I87450H1269 LEVEL: Severe
PID : 1296 TID : 2440 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613003
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0ff08000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613003 OPNum:2238379
begoff: 48
datlen: 16336
pagebinx: 4633
revnum: 1024
pagelsn: 07944944DDD9 flag: 2
signature: 1316590786
cbits1to31: 4cc9136
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212962440.000
2013-03-06-14.47.56.021000+480 I88721H480 LEVEL: Error
PID : 1296 TID : 2896 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.021000+480 I89203H1269 LEVEL: Severe
PID : 1296 TID : 2444 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613015
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x10554000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613015 OPNum:2238391
begoff: 48
datlen: 16336
pagebinx: 5020
revnum: 1024
pagelsn: 07944948A23C flag: 2
signature: 1316590786
cbits1to31: 9da029c
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212962444.000
2013-03-06-14.47.56.021000+480 I90474H1269 LEVEL: Severe
PID : 1296 TID : 2896 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-77 APPID: *LOCAL.DB2.130306064754
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613012
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x103d0000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613012 OPNum:2238388
begoff: 48
datlen: 16336
pagebinx: 4923
revnum: 1024
pagelsn: 07944947B107 flag: 2
signature: 1316590786
cbits1to31: c6a200a
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 39 bytes
D:PROGRA~1IBMSQLLIBDB212962896.000
2013-03-06-14.47.56.068000+480 I91745H372 LEVEL: Error
PID : 1296 TID : 876 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.083000+480 I92119H1160 LEVEL: Severe
PID : 1296 TID : 876 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:10;obj:5;type:0} Parent={0;0}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
2613007
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x100cc000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2613007 OPNum:2238383
begoff: 48
datlen: 16336
pagebinx: 4730
revnum: 1024
pagelsn: 079449461F0C flag: 2
signature: 1316590786
cbits1to31: 10098c8a
cbits32to63: 0
DATA #7 : String, 9 bytes
SQLB_PAGE
DATA #8 : Dumped object of size 16384 bytes at offset 0, 38 bytes
D:PROGRA~1IBMSQLLIBDB21296876.000
2013-03-06-14.47.56.083000+480 I93281H377 LEVEL: Error
PID : 1296 TID : 876 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbGetVictimSlot, probe:727
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.162000+480 I93660H387 LEVEL: Error
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:40
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
2013-03-06-14.47.56.162000+480 I94049H2395 LEVEL: Severe
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:300
DATA #1 : String, 13 bytes
*ioRequest =
DATA #2 : Hexdump, 76 bytes
0x02E14074 : 0301 0000 0000 0000 0000 83F7 0900 0000 ................
0x02E14084 : 0000 0000 0000 0000 7C8F 596E D8E1 3B0B ........|.Yn..;.
0x02E14094 : 5040 E102 0000 0000 0000 0000 0000 440E P@............D.
0x02E140A4 : 0040 0000 080B 0000 0000 0000 E0D4 E911 .@..............
0x02E140B4 : 0000 0000 0200 0000 0E00 0F87 ............
DATA #3 : Buffer page descriptor, PD_TYPE_SQLB_BPD, 120 bytes
Pagekey: {pool:10;obj:5;type:0} PPNum:2612716
objectPageNum: 2238124
bucketGroupHashIndex: 86
hashnext: 0x00000000
hashprev: 0x0b6504b8
osslatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
m_pSemPoolElement = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
flags = 0x0000
identity = SQLB_BPD::bpdLatch::critical_section (30)
}
}
UFlags: 103
permanentState: 0
transientState: 0
fixcount: 1
bpp: 0x0e440000
pinCount:
0x0B625F80 : 0000 0000 ....
dirtyprev: 0x0b625d60
dirtynext: 0x0b623790
blockDesc: 0x00000000
pminlsn: 0000079448F390EA
hatenext: 0x00000000
hateprev: 0x00000000
newbpdidx: 3221225472
DATA #4 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:10;obj:5;type:0} PPNum:2612716 OPNum:2238124
begoff: 48
datlen: 16336
pagebinx: 2919
revnum: 1024
pagelsn: 079448F3DE82 flag: 2
signature: 1316590786
cbits1to31: 6088230
cbits32to63: 0
2013-03-06-14.47.56.162000+480 I96446H368 LEVEL: Severe
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x01DA0174 : 0000 0000 ....
2013-03-06-14.47.56.177000+480 I96816H339 LEVEL: Severe
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x11D0F440 : 0000 0000 ....
2013-03-06-14.47.56.177000+480 I97157H405 LEVEL: Warning
PID : 1296 TID : 3752 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x11D0F314 : 0000 0000 ....
2013-03-06-14.48.57.490000+480 E97564H858 LEVEL: Event
PID : 1108 TID : 2056 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5117 available:1884
Virtual Memory(MB): total:8007 free:11780
Swap Memory(MB): total:1863 free:6663
2013-03-06-16.53.14.146000+480 I98424H1536 LEVEL: Event
PID : 2676 TID : 780 PROC : db2stop.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012AD24 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012AD34 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012AD44 : 4F50 322E 4558 4500 4E4F 4D53 4700 534E OP2.EXE.NOMSG.SN
0x0012AD54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AD94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADD4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-16.53.14.162000+480 I99962H390 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0x02E5FEC4 : 0100 0000 ....
2013-03-06-16.53.14.162000+480 I100354H410 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0x02E5FEC4 : 0100 0000 ....
2013-03-06-16.53.14.162000+480 I100766H297 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2013-03-06-16.53.14.162000+480 I101065H312 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2013-03-06-16.53.14.162000+480 I101379H405 LEVEL: Warning
PID : 1108 TID : 2016 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x01A0FA64 : 0000 0000 ....
2013-03-06-16.53.14.177000+480 I101786H314 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2013-03-06-16.53.14.177000+480 I102102H385 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : Hexdump, 4 bytes
0x02E5FE6C : 0000 0000 ....
2013-03-06-16.53.14.380000+480 E102489H311 LEVEL: Event
PID : 1108 TID : 1508 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2013-03-06-16.54.23.443000+480 I102802H1537 LEVEL: Event
PID : 2652 TID : 4076 PROC : db2start.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 39 bytes
D:PROGRA~1IBMSQLLIBbinDB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x0012ADB4 : 443A 5C50 524F 4752 417E 315C 4942 4D5C D:PROGRA~1IBM
0x0012ADC4 : 5351 4C4C 4942 5C62 696E 5C44 4232 5354 SQLLIBbinDB2ST
0x0012ADD4 : 4152 322E 4558 4500 4E4F 4D53 4700 0000 AR2.EXE.NOMSG...
0x0012ADE4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012ADF4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AE94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0012AEA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-03-06-16.54.24.755000+480 E104341H858 LEVEL: Event
PID : 2332 TID : 2820 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL09014"
with level identifier "01050107".
Informational tokens are "DB2 v9.1.400.359", "s071028", "WR21396", Fix Pack "4".
DATA #2 : System Info, 1564 bytes
System: WIN32_NT GCNHHSJPT Service Pack 2 5.2 x86 Family 6, model 47, stepping 2
CPU: total:5 online:5 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:6144 free:5140 available:1884
Virtual Memory(MB): total:8007 free:11842
Swap Memory(MB): total:1863 free:6702
该怎么办呢？
14同行回答
浏览1894
已经确认数据库不能连接了,难道真的只有用 db2dart /ddel 导出所有的数据，我看了一下损坏的tablespace 可以完全不用的，要是Oracle我直接生成去掉这个tablespace的控制文件就可以启动库了。难道DB2这么保守？收起
浏览1961
浏览2110
还有怎么给你们米呢？收起
浏览2086
请教前辈，运行了一下db2dark发现以下信息。
Table inspection start: DB_SJPT.T_RP_GC_HQCKXX
Data inspection phase start. Data obj: 5 In pool: 10
Error: BPS check read error for pool page 2613020, from object ID 5, pool 10,
Error: BPS Header Page Number incorrect. Expecting 2238396, Found 0.
Error: BPS Header pool relative page number incorrect. Expecting 2613020, Found 0.
Error: BPS Header object ID incorrect. Expecting 5, Found 0.
Error: BPS Header tablespace ID incorrect. Expecting 10, Found 0.
Error: BPS Header problems found
Error: in page 2238396, pool page 2613020, of Object 5, in tablespace 10.
Error: Page data will be dumped to report.
000 *0000 0000 0000 0000 0000 0000 0000 0000* *................*
010 *0000 0000 0000 0000 0000 0000 0000 0000* *................*
020 *0000 0000 0000 0000 0000 0000 0000 0000* *................*收起
Table inspection start: DB_SJPT.T_RP_GC_HQCKXX
Data inspection phase start. Data obj: 5 In pool: 10
Error: BPS check read error for pool page 2613020, from object ID 5, pool 10,
Error: BPS Header Page Number incorrect. Expecting 2238396, Found 0.
Error: BPS Header pool relative page number incorrect. Expecting 2613020, Found 0.
Error: BPS Header object ID incorrect. Expecting 5, Found 0.
Error: BPS Header tablespace ID incorrect. Expecting 10, Found 0.
Error: BPS Header problems found
Error: in page 2238396, pool page 2613020, of Object 5, in tablespace 10.
Error: Page data will be dumped to report.
000 *0000 0000 0000 0000 0000 0000 0000 0000* *................*
010 *0000 0000 0000 0000 0000 0000 0000 0000* *................*
020 *0000 0000 0000 0000 0000 0000 0000 0000* *................*收起
浏览2107
2013-03-05-12.46.58.177000+480 I4588H480 LEVEL: Error
PID : 1916 TID : 3108 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
文件被其他进程锁住了，windows的话，重启下机器，然后试试收起
PID : 1916 TID : 3108 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SJPT
APPHDL : 0-7 APPID: *LOCAL.DB2.130305044655
AUTHID : ADMINISTRATOR
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:20
MESSAGE : ZRC=0x870F000E=-2029060082=SQLO_LOCK "ERROR_LOCK_VIOLATION (DOS)"
DIA8511C A locked file was encountered.
文件被其他进程锁住了，windows的话，重启下机器，然后试试收起
浏览2058
谢谢。收起
浏览2062