IBM Support

IC70505: INSTANCE CRASH WITH SIGNAL# 11 IN FUNCTION SQLRA_GET_VAR WITH ER ROR -901 "UNEXPECTED SETUP FOR A REOPT STATEMENT" IN THE DB2DIAG

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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
    ....
    ....
    

Local fix

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
    

Problem conclusion

  • Fixed in V97FP4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70505

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-11

  • Closed date

    2011-05-02

  • Last modified date

    2012-04-05

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC73398 IC82019

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC70505

Modified date: 05 April 2012