IBM Support

IC88312: MINIMIZE DELAY AT LOAD STARTUP TIME RELATING TO A PREVIOUS LOAD INTO THE SAME TABLE NOT TERMINATING CLEANLY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If a LOAD was abruptly interrupted or killed in an "unclean" way
    (e.g. doing a "kill -9" on the client application process that
    submitted the LOAD operation), the next LOAD into the same table
    may encounter a delay of at least 1 minute at startup time, with
    messages in db2diag.log like
    
    
    2012-05-09-16.54.11.698719-240 I3736483E780        LEVEL:
    Warning
    PID     : 6642                 TID  : 46912954689856PROC :
    db2sysc
    INSTANCE: db2inst1              NODE : 000          DB   : V97
    APPHDL  : 0-59                 APPID:
    *LOCAL.db2inst1.120509205342
    AUTHID  : DB2INST1
    EDUID   : 93                   EDUNAME: db2agent (V97)
    FUNCTION: DB2 UDB, database utilities,
    sqluCreateLoadListElement, probe:15
    DATA #1 : LOADID, PD_TYPE_LOADID, 45 bytes
    LOADID: 93.2012-05-09-16.54.08.228691.0 (2;4)
    MESSAGE : A Load synchronization element for this table already
    exists and is
              associated with a different application ID.  Load will
    wait briefly
              before reusing this synchronization element and
    continuing normally.
              No user intervention is required.
    
    ... and then at least 1 minute later
    
    2012-05-09-16.55.12.500705-240 I3766076E607        LEVEL:
    Warning
    PID     : 6642                 TID  : 46912954689856PROC :
    db2sysc
    INSTANCE: db2inst1              NODE : 000          DB   : V97
    APPHDL  : 0-59                 APPID:
    *LOCAL.db2inst1.120509205342
    AUTHID  : DB2INST1
    EDUID   : 93                   EDUNAME: db2agent (V97)
    FUNCTION: DB2 UDB, database utilities,
    sqluCreateLoadListElement, probe:20
    DATA #1 : LOADID, PD_TYPE_LOADID, 45 bytes
    LOADID: 93.2012-05-09-16.54.08.228691.0 (2;4)
    MESSAGE : The Load synchronization element is now being reused.
    No user
              intervention is required.
    
    
    This APAR fix will proactively check if the previous application
    that ran the LOAD still exists, and allow the current LOAD to
    proceed immediately as soon as it determines the previous
    application no longer exists.  We will still see the same 2
    messages above in db2diag.log, but there will be minimal delay
    between them.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB Version 10.1 Fixpack 2.                   *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 UDB Version 10.1 Fixpack 2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88312

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-17

  • Closed date

    2013-01-17

  • Last modified date

    2013-01-17

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

    IC84034

  • 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

  • RA10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 January 2013