IBM Support

IT17214: THE DATABASE MIGHT ABEND DUE TO PROGRAMMING ERROR IN LIST PREFETCH PROCESSING.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The symptom of the problem is following entry in the
    db2diag.log:
    
    2016-09-11-05.57.09.988817+000 I155200947E1183       LEVEL:
    Severe
    PID     : 39281                TID : 140468423747328 PROC :
    db2sysc 47
    INSTANCE: db2inst1             NODE : 047            DB   :
    SAMPLE
    APPHDL  : 0-53118              APPID:
    10.10.10.100.41775.160911055257
    AUTHID  : DB2INST1             HOSTNAME: sl55edwdbp13
    EDUID   : 233782               EDUNAME: db2agnts (SAMPLE) 47
    FUNCTION: DB2 UDB, data management, sqldmPrefetchList,
    probe:1966
    MESSAGE : LIST PREFETCH in reverse: 1190 32 ...
    DATA #1 : Hexdump, 128 bytes
    0x00007FD458E7C4E0 : A604 0000 2000 0000 2100 0000 2200 0000
    .... ...!..."...
    0x00007FD458E7C4F0 : 2300 0000 2400 0000 2500 0000 2600 0000
    #...$...%...&...
    0x00007FD458E7C500 : 2700 0000 2800 0000 2900 0000 2A00 0000
    '...(...)...*...
    0x00007FD458E7C510 : 2B00 0000 2C00 0000 2D00 0000 2E00 0000
    +...,...-.......
    0x00007FD458E7C520 : 2F00 0000 3000 0000 3100 0000 3200 0000
    /...0...1...2...
    0x00007FD458E7C530 : 3300 0000 3400 0000 3500 0000 3600 0000
    3...4...5...6...
    0x00007FD458E7C540 : 3700 0000 3800 0000 3900 0000 3A00 0000
    7...8...9...:...
    0x00007FD458E7C550 : 3B00 0000 3C00 0000 3D00 0000 3E00 0000
    ;...<...=...>...
    ...
    
    
    Consequence of above is FODC processing where in the stack we
    might observe (snippet):
    
    ...
    sqloDumpEDU
    sqldDumpContext
    sqlrr_dump_ffdc
    sqlzeDumpFFDC
    sqlzeMapZrc
    sqlrrMapZrc
    sqlriPrefetchRIDs
    sqlriListFetch
    qlrihsjn
    qlrihsjn
    sqlriSectInvoke
    ...
    
    
    Eventually, the problem is causing DB to be marked bad.
    

Local fix

  • During error processing, DB2 logs in the db2diag.log SQL
    statement:
    
    2016-09-11-05.57.10.035954+000 I155203356E12407      LEVEL:
    Severe
    PID     : 39281                TID : 140468423747328 PROC :
    db2sysc 47
    INSTANCE: db2inst1             NODE : 047            DB   :
    SAMPLE
    APPHDL  : 0-53118              APPID:
    10.10.10.100.41775.160911055257
    AUTHID  : DB2INST1             HOSTNAME: sl55edwdbp13
    EDUID   : 233782               EDUNAME: db2agnts (SAMPLE) 47
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling,
    probe:140
    MESSAGE : section stmt
    DATA #1 : Hexdump, 2338 bytes
    0x00007FD4649ED7A0 : 7365 6C65 6374 2061 3137 2E4D 5243 485F
    select A10.MYTAB
    ...
    
    Look to avoid statement causing the issue.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Fix Pack 1                               *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 11.1 Fix Pack 1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT17214

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-26

  • Closed date

    2017-05-09

  • Last modified date

    2017-05-09

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020