When using db2expln with "-cache" option to describe an access
plan, db2expln can cause the instance to trap if it's given a
non-existent SQL statement as an input.
1. db2expln sample output
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL and XQUERY Explain Tool
Error during explain call.
Message Text =
SQL1224N The database manager is not able to accept new
requests, has terminated all requests in progress, or has
terminated the specified request because of an error or a forced
interrupt.
SQLSTATE=55032
sqlcaid = SQLCA
sqlcabc = 136
sqlcode = -1224
sqlstate = 55032
sqlerrml = 36
sqlerrmc = "-2097151964", "*", "*", "*", "*"", "SEMAPHORE WAIT"
sqlerrp = SQLJCMN
sqlerrd0 = 0x8136001C = -2127167460
sqlerrd1 = 0x0000001C = 28
sqlerrd2 = 0x00000000 = 0
sqlerrd3 = 0x00000000 = 0
sqlerrd4 = 0x00000000 = 0
sqlerrd5 = 0x00000000 = 0
sqlwarn = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '
'
2. db2diag.log
2013-06-02-20.43.06.070987-240 I14962A573 LEVEL: Error
PID : 635130 TID : 1544 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID:
*LOCAL.db2inst1.130603004305
AUTHID : db2inst1
EDUID : 1544 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:9
MESSAGE : Error in agent servicing application with PRODUCT
SIGNATURE:
DATA #1 : Hexdump, 8 bytes
0x0780000000AF6984 : 5351 4C30 3930 3736
SQL09076
2013-06-02-20.43.06.071151-240 I15536A573 LEVEL: Error
PID : 635130 TID : 1544 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID:
*LOCAL.db2inst1.130603004305
AUTHID : db2inst1
EDUID : 1544 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:10
MESSAGE : Error in agent servicing application with APPLICATION
NAME:
DATA #1 : Hexdump, 8 bytes
0x0780000000AF685A : 6462 3265 7870 6C6E
db2expln
2013-06-02-20.43.06.071321-240 I16110A490 LEVEL: Severe
PID : 635130 TID : 1544 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID:
*LOCAL.db2inst1.130603004305
AUTHID : db2inst1
EDUID : 1544 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler,
probe:10
MESSAGE : DIA0505I Execution of a component signal handling
function has begun.
2013-06-02-20.43.06.071720-240 I16601A513 LEVEL: Severe
PID : 635130 TID : 1544 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID:
*LOCAL.db2inst1.130603004305
AUTHID : db2inst1
EDUID : 1544 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler,
probe:911
DATA #1 : String, 38 bytes
Source Type not DRDA AS. SourceType =
DATA #2 : signed integer, 4 bytes
4 |
