IBM Support

Instance crashes on stored procedure using detach partition.

Troubleshooting


Problem

A stored procedure using detach partition may cause crash with FODC_AppErr.

Symptom

The following messages are seen in the db2diag.log file.


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/".

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - fodc","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21987177