ORACLEDBA db2不懂,请大家帮忙解决下,挺急的。
数据库关闭后启动,前滚了数个小时然后数据库关闭了(客户描述)
1) 表空间一直处于rolling foward状态
list tablespaces
Tablespace ID = 6
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 7
Name = YYMIS_INDX
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0040
Detailed explanation:
Roll forward in progress
Tablespace ID = 8
Name = YYMIS_BCLIST
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0040
Detailed explanation:
Roll forward in progress
2)后台日志
2007-12-17-07.05.39.859874+480 I463279634A342 LEVEL: Info
PID : 172882 TID : 1 PROC : db2loggr (YYMIS) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:1390
DATA #1 :
ExtNum 122 state 101 baselsn 00000019B1648000 nextlsn 00000019B16480AB
2007-12-17-07.05.41.195337+480 I463279977A377 LEVEL: Warning
PID : 45574 TID : 1 PROC : db2logmgr (YYMIS) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000122.LOG to VENDOR chain 0 from
/lvyymis/db2_log/NODE0000/.
2007-12-17-07.05.41.373627+480 E463280355A343 LEVEL: Info
PID : 172884 TID : 1 PROC : db2loggr (YYMIS) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog, probe:1440
DATA #1 :
Cleaning up logs from RenameArchNum 122 to delLimit 123.
2007-12-17-07.05.42.000700+480 I463280699A400 LEVEL: Warning
PID : 197410 TID : 1 PROC : db2agent (YYMIS) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.071216230541
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbIsAllowed, probe:1075
DATA #1 : String, 36 bytes
Tablespace 7 : state= 64, action= 0.
2007-12-17-07.05.42.001542+480 I463281100A400 LEVEL: Warning
PID : 197410 TID : 1 PROC : db2agent (YYMIS) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-11 APPID: *LOCAL.db2inst1.071216230541
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbIsAllowed, probe:1075
DATA #1 : String, 36 bytes
Tablespace 8 : state= 64, action= 0.
2007-12-17-07.05.42.033960+480 I463281501A529 LEVEL: Warning
PID : 197410 TID : 1 PROC : db2agent (YYMIS) 0
INSTANCE: db2inst1 NODE : 000 DB : YYMIS
APPHDL : 0-11 APPID: *LOCAL.db2inst1.071216230541
AUTHID : DB2INST1
FUNCTION: DB2 UDB, Self tuning memory manager, stmmStartSortDbMonitorIfNecessary, probe:1465
MESSAGE : STMM Sort Memory Tuning cannot be activated because the Database
Manager Configuration Parameter SHEAPTHRES is not set to 0.
2007-12-17-07.05.42.037224+480 I463282031A771 LEVEL: Error
PID : 151874 TID : 1 PROC : db2evmgi (DB2DETAILDEADLOCK) 0
INSTANCE: db2inst1 NODE : 000 DB : YYMIS
APPHDL : 0-14 APPID: *LOCAL.DB2.071216230544
AUTHID : DB2INST1
FUNCTION: DB2 UDB, database monitor, sqmEvmonWriter::initTarget, probe:40
MESSAGE : ZRC=0x800D002B=-2146631637=SQLM_RC_EVFULL "monitor full of data"
DIA8052C The Event Monitor "" has reached its file capacity. Delete
the files in the target directory "" or move them to another
directory.
DATA #1 : String, 17 bytes
DB2DETAILDEADLOCK
DATA #2 : String with size, 72 bytes
/lvyymis/db2_yymis/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock