|
Problem IC70505
|
Status: Closed |
INSTANCE CRASH WITH SIGNAL# 11 IN FUNCTION SQLRA_GET_VAR WITH ER ROR -901 "UNEXPECTED SETUP FOR A REOPT STATEMENT" IN THE DB2DIAG |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Instance crash with signal# 11 in function sqlra_get_var with
error -901 "Unexpected setup for a REOPT statement" in the
db2diag.log. When repeatly running a static statement with
function call and host variable, also if the package of the
statement is bound as REOPT ONCE.
db2diag.log shows
2010-07-28-10.08.28.488298-300 I6744821E866 LEVEL: Severe
PID : 21316 TID : 47499125451072PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-732 APPID: GA1E3C58.L511.1213C8144134
AUTHID : DB2INST1
EDUID : 362 EDUNAME: db2agent (ECPROD) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 38
sqlerrmc: Unexpected setup for a REOPT statement
sqlerrp : SQLRA092
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFB82 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
-----------------
DB2 build information: DB2 v9.7.0.1 s091114 SQL09071
timestamp: 2010-07-21-00.17.34.124475
instance name: db2inst1.000
EDU name : db2agent (ECPROD) 0
EDU ID : 46003
Signal #11
uname: S:Linux R:2.6.16.60-0.42.7-smp V:#1 SMP Tue Nov 3
11:20:42 UTC
2009 M:x86_64 N:eprodadm01
process id: 31494
thread id : 47335388211520 (0x2B0D20FFE940)
----
<POFDisassembly>
_Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x28cc
(/db2home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002B0A516303EC : 8B500885D20F8434
</POFDisassembly>
<StackTrace>
ossDumpStackTraceEx
OSSTrapFile6dumpExEmiP7siginfoPvm
sqlo_trce
sqloEDUCodeTrapHandle
address: 0x00002B0A50222C00
sqlra_get_varP8sqlrr_cbiibPbS1_
sqlrr_process_execute_requestP8sqlrr_cbi
sqlrr_executeP14db2UCinterfaceP9UCstpInfo
pvmPackage14executeSectionEP5sqlcaj
PVM12executeQueryEj
....
.... |
| Problem Summary: |
Instance crash with signal# 11 in function sqlra_get_var with
error -901 "Unexpected setup for a REOPT statement" in the
db2diag.log |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fixed in V97FP4 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC73398 IC82019
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.08.2010
02.05.2011
05.04.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
