IBM Support

IC77070: ASSIGNING STRING DATA TYPES TO LARGE OBJECT DATA TYPES IN AN INLINED SQL FUNCTION MAY ABEND DB2 INSTANCE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Assignment operations from values of string data types to
    variables of large object data types in an inlined SQL function
    may abend DB2 instance.
    The problem may produce the following (call stack / error
    message) in db2diag.log
    
    2011-05-17-10.13.30.231132+570 E9427244E1456       LEVEL: Severe
    PID     : 5681                 TID  : 47343927814464PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-32                 APPID:
    172.30.0.211.64932.110517004257
    AUTHID  : DB2INST
    EDUID   : 67                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:999
    MESSAGE : Memory validation failure, diagnostic file dumped.
    DATA #1 : String, 28 bytes
    Corrupt pool free tree node.
    DATA #2 : File name, 39 bytes
    5681.47343927814464.mem_diagnostics.txt
    CALLSTCK:
      [0] 0x00002B0F116F1F52 pdLog + 0x398
      [1] 0x00002B0F131DA847
    _ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKc +
    0x241
      [2] 0x00002B0F13F19C0B
    _ZN13SQLO_MEM_POOL10MemTreePutEP8SMemNodemP17SqloChunkSubgroup +
    0x4AB
      [3] 0x00002B0F13F18F5A sqlofmblkEx + 0x25A
      [4] 0x00002B0F11DF0F4E _Z8sqlristmP8sqlrr_cbP9sqlri_shdi +
    0x84
      [5] 0x00002B0F11D5C958
    _Z32sqlra_sqlW_mem_free_sibling_listP8sqlrr_cbP23sqlra_workspace
    _siblingPm
    + 0x17E8
      [6] 0x00002B0F11D5AEA1
    _Z24sqlra_sqlW_mem_freespaceP8sqlrr_cbmPmi + 0x3B5
      [7] 0x00002B0F11D57093
    _Z29sqlra_sqlW_get_static_sectionP8sqlrr_cbi + 0x10E9
      [8] 0x00002B0F13F42BEF
    _Z17sqlra_get_sectionP8sqlrr_cbPhsS1_sS1_tmP16db2UCprepareInfoP1
    5db2UCCursorInfo
    + 0x61F
      [9] 0x00002B0F13F34C45
    _Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP
    15db2UCCursorInfo
    + 0x4DB
    

Local fix

Problem summary

  • Assignment operations from values of string data types to
    
    variables of large object data types in an inlined SQL function
    may abend DB2 instance.
    The problem may produce the following (call stack / error
    message) in db2diag.log
    
    2011-05-17-10.13.30.231132+570 E9427244E1456       LEVEL: Severe
    PID     : 5681                 TID  : 47343927814464PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-32                 APPID:
    172.30.0.211.64932.110517004257
    AUTHID  : DB2INST
    EDUID   : 67                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:999
    MESSAGE : Memory validation failure, diagnostic file dumped.
    DATA #1 : String, 28 bytes
    Corrupt pool free tree node.
    DATA #2 : File name, 39 bytes
    5681.47343927814464.mem_diagnostics.txt
    CALLSTCK:
      [0] 0x00002B0F116F1F52 pdLog + 0x398
      [1] 0x00002B0F131DA847
    _ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKc +
    0x241
      [2] 0x00002B0F13F19C0B
    _ZN13SQLO_MEM_POOL10MemTreePutEP8SMemNodemP17SqloChunkSubgroup +
    0x4AB
      [3] 0x00002B0F13F18F5A sqlofmblkEx + 0x25A
      [4] 0x00002B0F11DF0F4E _Z8sqlristmP8sqlrr_cbP9sqlri_shdi +
    0x84
      [5] 0x00002B0F11D5C958
    _Z32sqlra_sqlW_mem_free_sibling_listP8sqlrr_cbP23sqlra_workspace
    _siblingPm
    + 0x17E8
      [6] 0x00002B0F11D5AEA1
    _Z24sqlra_sqlW_mem_freespaceP8sqlrr_cbmPmi + 0x3B5
      [7] 0x00002B0F11D57093
    _Z29sqlra_sqlW_get_static_sectionP8sqlrr_cbi + 0x10E9
      [8] 0x00002B0F13F42BEF
    _Z17sqlra_get_sectionP8sqlrr_cbPhsS1_sS1_tmP16db2UCprepareInfoP1
    5db2UCCursorInfo
    + 0x61F
      [9] 0x00002B0F13F34C45
    _Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP
    15db2UCCursorInfo
    + 0x4DB
    

Problem conclusion

  • Problem was first fixed in Version 9.7 Fix Pack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77070

  • 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-06-20

  • Closed date

    2012-03-01

  • Last modified date

    2012-03-01

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

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

    IC77493

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 #: IC77070

Modified date: 01 March 2012