IBM Support

IT27171: DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATAPART FUNCTION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Db2 can trap during an HPU (High Performance Unload) unload job,
    with the following stack in a trap file:
    
    0x090000000C1173E0
    InitializeOneDatapart__20sqluCStorageDatapartFiP8SQLD_TCB + 0x60
    0x090000000C121CB8 zFixTCBs__10sqluCTableFP8sqeAgentUsT2PciT4N25
    + 0x438
    0x090000000C1216E0
    zFixTCBwithName__10sqluCTableFP8sqeAgentiPcT2T3T2 + 0x60
    0x090000000CF473DC
    sqluRegisterUnloadStart__FPUcT1P8sqeAgentP12SQLB_GLOBALSP22SQLU_
    LOADAPI_UNLOAD_CBiT6PiP15sql_static_dataP5sqlca + 0x1EDC
    0x090000000CF44954
    sqlu_register_table_unload__FPUcT1iP15sqlu_media_listP13SQLUVLCB
    _TYPEP15sql_static_dataP5sqlca + 0x854
    0x090000000C1626A4 sqluvtun_route_in__FP12SQLE_DB2RA_T + 0x424
    0x090000000DC7D580 sqlesrvr__FP14db2UCinterface + 0x1D80
    0x090000000DC7AFA8 sqleMappingFnServer__FP5sqldaP5sqlca + 0x6A8
    (...)
    
    In almost every case, when the same HPU job is submitted again
    it succeeds.
    
    The root cause is not totally known; this APAR fix prevents Db2
    from trapping, and causes the HPU operation to fail instead.  It
    also records additional diagnostic information, which might aid
    in understanding the root cause shall the problem recurs again.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All using HPU feature                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 11.1 fixpack 6                            *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in Version 11.1 Fixpack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27171

  • 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

    2018-12-03

  • Closed date

    2021-03-22

  • Last modified date

    2021-03-22

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

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

    IT35935 IT35936

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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"}]

Document Information

Modified date:
23 March 2021