Troubleshooting
Problem
Symptom
2016-07-07-07.03.35.066231-240 I4119881E739 LEVEL: Error
PID : 23373 TID : 140203003995904 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DBNAME
APPHDL : 0-53047 APPID: XX.XX.XX.XX.61114.009090909090
AUTHID : DB2INST1 HOSTNAME: myhost1
EDUID : 4728 EDUNAME: db2agent (DBNAME) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_free_sibling,
probe:200
DATA #2 : Hexdump, 45 bytes
0x00007F838E3F9530 : 7369 626C 696E 6720 7074 723D 3078 3078 sibling
ptr=0x0x
0x00007F838E3F9540 : 3766 3864 6230 3364 3663 3630 2063 7572
7f8db03d6c60 cur
0x00007F838E3F9550 : 736F 7245 5254 496E 6465 783D 34
sorERTIndex=4
2016-07-07-15.03.35.066624-240 E4120621E1802 LEVEL: Severe
PID : 23373 TID : 140203003995904 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DBNAME
APPHDL : 0-53047 APPID: XX.XX.XX.XX.61114.009090909090
AUTHID : DB2INST1 HOSTNAME: myhost1
EDUID : 4728 EDUNAME: db2agent (DBNAME) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_free_sibling,
probe:200
DATA #1 : String, 33 bytes
sibling with cursorERTIndex found
DATA #2 : PSM_CURSOR_VAR_INFO, PD_TYPE_SQLRA_PSM_CURSOR_INFO, 216 bytes
ERT Cursor Info :
------------------------------
Cursor ID (ERT Index) : 4
PSM Cursor ID : 3
PSM Block ID : 3
Nesting Level : 1
Invocation ID : 1
Anchor Nesting Level : 1
Anchor Invocation ID : 1
Number of References : 1
CSM Control Block : 00007f8db03d6bc0
Package Identifier : 00007f8db03d4700
UC Cursor Info :
----------------------------
bfCursorAttributes : 0x 210408020a
offset : 1
orientation : 8
flags : 0x00000000
qryOptVal : 4294967295
cursorID nestingLevel : 1
cursorID sequenceNum : 1
Next Cursor Info : 00007f8db03d43a0
Previous Cursor Info : 0000000000000000
Next Free Curosr Info : 0000000000000000
Num of Params : 0
Num of Param References : 0
Cursor Attribute: IS_OPEN:
- TRUE
Cursor Attribute: FOUND:
- TRUE
Cursor Attribute: ROW_COUNT:117
Cursor Flags: 0x00000020
- OUT OF SCOPE: FALSE
- HOST VAR IN QUERY: FALSE
- UNUSED: FALSE
- PARAMETERIZED: FALSE
- RETURNED TO CLIENT: FALSE
- WITH HOLD: TRUE
- PROCESSING OPEN: FALSE
- GLOBAL VARIABLE DEFAULT: FALSE
- FREED: FALSE
2016-07-07-15.03.35.157457-240 E4122424E824 LEVEL: Error
PID : 23373 TID : 140203003995904 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : DBNAME
APPHDL : 0-53047 APPID: XX.XX.XX.XX.61114.009090909090
AUTHID : DB2INST1 HOSTNAME: myhost1
EDUID : 4728 EDUNAME: db2agent (DBNAME) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:30
MESSAGE : ADM14005E The following error occurred: "AppErr". First
Occurrence
Data Capture (FODC) has been invoked in the following mode:
"Automatic". Diagnostic information has been recorded in the
directory named
"/u01/home/db2inst1/sqllib/db2dump/FODC_AppErr_2016-07-07-15.03.35
.157
035_23373_4728_000/".
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
30 April 2025
UID
swg21987177