In a pureScale environment when an XA Read only transaction
completes and the app receives SQL0997W, probes will appear in
the db2diag.log that have a Severe or Error level but should
really be Informational. No action is required by the customer
in this case and there is no problem with any DB2 functionality.
Here are example probes:
-----
2016-10-13-05.30.02.035269+540 I94484A992 LEVEL:
Severe
PID : 31260800 TID : 159347 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
XXXXXX
APPHDL : 0-32951 APPID: XXX.XXX.161013010910
AUTHID : db2inst1 HOSTNAME: XXXXXXXX
EDUID : 159347 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, base sys utilities,
sqeIcoordCB::PostCompletion, probe:734
RETCODE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
"SQLCA has been built and saved in component specific
control block."
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 997 sqlerrml: 2
sqlerrmc: 35
sqlerrp : SQLRR0AC
sqlerrd : (1) 0x80100023 (2) 0x00000023 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2016-10-13-05.30.02.035665+540 I95477A1052 LEVEL:
Severe
PID : 31260800 TID : 210901 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
XXXXXX
APPHDL : 1-13585 APPID:
XX.X.XX.XXX.53904.161012202801
AUTHID : db2inst1 HOSTNAME: XXXXXXXX
EDUID : 210901 EDUNAME: db2agntp (TESTDB) 0
FUNCTION: DB2 UDB, base sys utilities,
sqeIcoordCB::WaitForCompletion, probe:674
RETCODE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
"SQLCA has been built and saved in component specific
control block."
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
0x8005006D
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 997 sqlerrml: 2
sqlerrmc: 35
sqlerrp : SQLRR0AC
sqlerrd : (1) 0x80100023 (2) 0x00000023 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2016-10-13-05.30.02.036135+540 I96530A1014 LEVEL:
Severe
PID : 31260800 TID : 210901 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
XXXXXX
APPHDL : 1-13585 APPID:
XX.X.XX.XXX.53904.161012202801
AUTHID : db2inst1 HOSTNAME: XXXXXXXX
EDUID : 210901 EDUNAME: db2agntp (TESTDB) 0
FUNCTION: DB2 UDB, base sys utilities,
sqeIcoordCB::DispatchIndependentDBAgent, probe:125
RETCODE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
"SQLCA has been built and saved in component specific
control block."
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 997 sqlerrml: 2
sqlerrmc: 35
sqlerrp : SQLRR0AC
sqlerrd : (1) 0x80100023 (2) 0x00000023 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2016-10-13-05.30.02.036535+540 I97545A573 LEVEL: Error
PID : 31260800 TID : 210901 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
XXXXXX
APPHDL : 1-13585 APPID:
XX.X.XX.XXX.53904.161012202801
AUTHID : db2inst1 HOSTNAME: XXXXXXXX
EDUID : 210901 EDUNAME: db2agntp (TESTDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqleInvokeXaIcoord,
probe:109
MESSAGE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
"SQLCA has been built and saved in component specific
control block."
----- |
