Database Partition 0 -- Database METADB -- Active -- Up 0 days 00:00:02
Applications:
Address AppHandl NumAgentsCoorPid Status Appid
0x300E75E0 403 1 1249402 UOW-Waiting *LOCAL.mqinst.110927061327
0x300E7020 408 1 1126404 UOW-Waiting *LOCAL.mqinst.110927061326
Database Partition 0 -- Database METADB -- Active -- Up 0 days 00:00:02
Transactions:
Address AppHandl TranHdl Locks State Tflag Tflag2 Firstlsn Lastlsn LogSpace SpaceReserved TID AxRegCnt GXID
0x40261580 408 2 2 READ 0x00000000 0x00000000 0x000000000000 0x000000000000 0 0 0x000000AE05A3 1 0
0x40262000 403 3 0 READ 0x00000000 0x00000000 0x000000000000 0x000000000000 0 0 0x000000AE059D 1 0
Database Partition 0 -- Database METADB -- Active -- Up 0 days 00:00:02
Logs:
Current Log Number: 167604
Pages Written: 1
Address StartLSN State Size Pages Filename
0x4025F83C 0x0550857D0000 0x00000000 4096 4096 S0167604.LOG
0x4025F8CC 0x0550867D0000 0x00000000 4096 4096 S0167605.LOG
0x40233F3C 0x0550877D0000 0x00000000 4096 4096 S0167606.LOG 本帖最后由 duzh8006 于 2011-09-28 08:24 编辑
好像这个数据库自动deactive db 和active db ，确实没有手动执行的啊，需要怎么排查呢 所有连接都断了，数据库就会自动deactive，第一个连接上来，就会active db 怎么在list application的时候另外一个数据库codedb有时候没有连接，uptime确是连续的时间
这个metadb的uptime确不是连续时间 :em08::em08::em08::em08::em08::em08: 你当时的情况贴上来看看。
两个数据库的db2pd -appl 回复 16# mdkii
$ /home/mqinst/sqllib/adm/db2pd -db metadb -appl
Database Partition 0 -- Database METADB -- Active -- Up 2 days 16:17:19
Applications:
Address AppHandl NumAgentsCoorPid Status Appid
0x30123430 347 1 635050 UOW-Waiting *LOCAL.mqinst.111001001511
0x300E6FC0 131 1 1134794 UOW-Waiting *LOCAL.mqinst.110928080103
$ /home/mqinst/sqllib/adm/db2pd -db codedb -appl
Database Partition 0 -- Database CODEDB -- Active -- Up 4 days 16:39:53
Applications:
Address AppHandl NumAgentsCoorPid Status Appid
0x300E7D40 92 1 254018 ConnectCompleted AC100237.D4C0.110926074310 $ db2 list application show detail
CONNECT Auth Id Application Name Appl. Application Id Seq# Number ofCoordinating DBCoordinator Status Status Change Time DB NameDB Path
Handle Agents partition number pid/thread
------------------------------ -------------------- ---------- ------------------------------ ---- ---------- ---------------- --------------- ------------------------------ -------------------------- -------- --------------------
MQINST iwh2serv 347 *LOCAL.mqinst.111001001511 0002 1 0 635050 UOW Waiting Not Collected METADB /home/mqinst/mqinst/NODE0000/SQL00001/
MQINST iwh2log 131 *LOCAL.mqinst.110928080103 0012 1 0 1134794 UOW Waiting Not Collected METADB /home/mqinst/mqinst/NODE0000/SQL00001/
MQINST db2jccmain 92 AC100237.D4C0.110926074310 0001 1 0 254018 Connect Completed Not Collected CODEDB /home/mqinst/mqinst/NODE0000/SQL00006/ 2 days and 4 days，
How do you think“metadb的uptime确不是连续时间”
页:
1
[2]