Interrupts (internal or user driven) can result in some extra
db2diag logging. These messages are flagged as 'ERROR' but they
are not an error when the root cause is an Interrupt. If the
cause is an Interrupt there is no concern and the messages
should be ignored. This APAR eliminates these db2diag.log
messages.
Some Examples:
2010-01-25-17.09.49.134278-360 I6181181A8313 LEVEL: Error
PID : 1183844 TID : 7492 PROC : db2sysc 6
INSTANCE: dmdiadm1 NODE : 006 DB : DEV103
APPHDL : 0-297 APPID: *N0.dmdiadm1.100125230808
AUTHID : ESHIRLE
EDUID : 7492 EDUNAME: db2agntp (UHCBET01) 6
FUNCTION: DB2 UDB, data management, sqldFetchDictionary,
probe:3112
MESSAGE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT
DETECTED"
DIA8003C The interrupt has been received.
DATA #1 : String, 24 bytes
Fetch Dictionary Failed.
DATA #2 : String, 12 bytes
fetch Phase:
DATA #3 : unsigned integer, 4 bytes
0
DATA #4 : String, 14 bytes
Fetch Options:
DATA #5 : Hex integer, 4 bytes
0x00000003
DATA #6 : String, 8 bytes
RecType:
DATA #7 : unsigned integer, 4 bytes
0
DATA #8 : String, 6 bytes
dmsWA:
DATA #9 : Hexdump, 1416 bytes
0x0700000008FFC370 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0700000008FFC380 : 0000 0000 2010 0000 0000 0000 0000 0000
.... ...........
::
::
0x0700000008FFC8E0 : 0700 0000 08FF CA30 0700 0000 7177 F280
.......0....qw..
0x0700000008FFC8F0 : 0000 0036 4DF4 0333 ...6M..3
DATA #10: String, 7 bytes
recptr:
DATA #11: Hexdump, 2 bytes
0x070000002B4BBA44 : 0000 ..
DATA #12: String, 6 bytes
recid:
DATA #13: zrid, PD_TYPE_SQLZ_RID, 8 bytes
Page=197; Slot=1; Dpid=0
2010-01-25-17.09.49.608662-360 I6189495A514 LEVEL: Error
PID : 1183844 TID : 7492 PROC : db2sysc 6
INSTANCE: dmdiadm1 NODE : 006 DB : DEV103
APPHDL : 0-297 APPID: *N0.dmdiadm1.100125230808
AUTHID : ESHIRLE
EDUID : 7492 EDUNAME: db2agntp (UHCBET01) 6
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
logging fu, probe:0
MESSAGE : SQLD_TCB:
DATA #1 : String, 41 bytes
Perm Table(163:4)=TBSPACEID=163.TABLEID=4
2010-01-25-17.09.49.626623-360 I6190010A170 LEVEL: Error
PID:1183844 TID:7492 NODE:006 Title: SQLD_TCB
Dump File:/dmdiadm1/sqllib/db2dump/1183844.7492.006.dump.bin |
