IBM Support

IC77908: NON-THREADED STORED PROCEDURE COMPILED IN 32 BIT MODE MAY CAUSE INSTANCE CRASH

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Non-threaded stored procedure compiled in 32 bit mode may cause
    an instance crash.
    db2diag.log has the following entry.
    
    2011-08-01-09.38.30.729525-300 I46180061E1463      LEVEL: Severe
    (OS)
    PID     : 9947                 TID  : 46963672213824PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000          DB   : xxxxx
    APPHDL  : 0-25429              APPID:
    10.1.2.82.2424.110801111830
    AUTHID  : xxxxxx
    EDUID   : 34964                EDUNAME: db2agent (xxxxx) 0
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloMemDetachFromSegments, probe:100
    MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid
    memory addr"
              DIA8561C A invalid memory block was encountered.
    CALLED  : OS, -, shmdt                            OSERR: EINVAL
    (22)
    DATA #1 : unsigned integer, 8 bytes
    0
    DATA #2 : unsigned integer, 8 bytes
    1
    DATA #3 : Pointer, 8 bytes
    0x00002ab742bd2000
    CALLSTCK:
      [0] 0x00002AAAAB7D7E77 pdLogSysRC + 0x2AD
      [1] 0x00002AAAABD0F509
    /home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1242509
      [2] 0x00002AAAABD0EFC8
    /home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1241FC8
      [3] 0x00002AAAABD0E9B4 sqlofshr + 0x206
      [4] 0x00002AAAAB86215B
    _Z13sqlccFreeIPCsP18SQLCC_INITSTRUCT_Tcc + 0x371
      [5] 0x00002AAAAC6BABCC
    /home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1BEDBCC
      [6] 0x00002AAAAC6BAE91
    _Z23sqlerRemoveAllIPCforRowP11sqlerFmpRowb + 0x2BF
      [7] 0x00002AAAAC6BBA77
    /home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1BEEA77
      [8] 0x00002AAAAC6BB8C3
    /home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1BEE8C3
      [9] 0x00002AAAAC6BC61C
    /home/db2insp1/sqllib/lib64/libdb2e.so.1 + 0x1BEF61C
    

Local fix

  • Not available.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All who use non-threaded stored procedure compiled in 32 bit *
    * mode                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * As same as Error description.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 9.7 FixPack 5.                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 FixPack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77908

  • 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

    2011-08-04

  • Closed date

    2011-12-29

  • Last modified date

    2011-12-29

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

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

    IC78144 IC82587

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77908

Modified date: 29 December 2011