Topic
  • No replies
jmueller
jmueller
26 Posts

Pinned topic missing table after databae crash

‏2013-05-07T09:16:43Z |

Hello OPM Community,

after database crash with takeover (PowerHA) following message is flooding the db2diag.log file:

2013-05-07-09.41.46.207629+120 E19954369A481      LEVEL: Error

 

PID     : 716966               TID  : 27264       PROC : db2sysc 0
INSTANCE: db2icp               NODE : 000         DB   : ICP
APPHDL  : 0-6930               APPID: 172.16.111.94.51012.130507055545
AUTHID  : DB2ICP
EDUID   : 27264                EDUNAME: db2agent (ICP) 0
FUNCTION: DB2 UDB, database monitor, sqmSqlTarget::readSystables, probe:20
MESSAGE : ADM2016W  The table "OPMNU2G66A1" (ID "0") was not found.
 
2013-05-07-09.41.46.210474+120 I19954851A646      LEVEL: Warning
PID     : 716966               TID  : 27264       PROC : db2sysc 0
INSTANCE: db2icp               NODE : 000         DB   : ICP
APPHDL  : 0-6930               APPID: 172.16.111.94.51012.130507055545
AUTHID  : DB2ICP
EDUID   : 27264                EDUNAME: db2agent (ICP) 0
FUNCTION: DB2 UDB, database monitor, sqmSqlTarget::readSystables, probe:20
MESSAGE : ZRC=0x800D014C=-2146631348=SQLM_RC_NOTAB "table not found"
DATA #1 : String, 133 bytes
Event Monitor Name: OPMNU2G66A1;
TableName: OPMNU2G66A1;
The table is not found, and corresponding event type will not be recorded!
 

What can I do to stop the messages?

 

Status from event monitor:

 

 EVMONNAME                        STATE TARGET
 -------------------------------- ----- ------
 OQTEV201201102801003501903454020     0 
 OPMWU2G66A                           1 
 OQTEV201201101501305303802168660     0 
 OPMNU2G66A1                          0

Best regards

Joachim