IBM Support

IC77930: LOAD OPERATIONS WITH COPY YES OPTION MAY FAIL WITH SQLO_SEM_TIMEOUT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • LOAD operations with COPY YES option may timeout and fail, when
    there is no data to write to the LOAD COPY image for a
    120-second period.  This could happen if (for example):
    -- all the rows processed within 120 seconds are being rejected,
    or
    -- load's build phase (which does not write to LOAD COPY image)
    lasts longer than 120 seconds
    
    db2diag.log will have below entry for the LOAD
    
    -----
    2010-07-11-11.11.111.123456+123 E60128A423         LEVEL: Severe
    PID     : 181060               TID  : 20391       PROC : db2sysc
    0
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 20391                EDUNAME: db2lmw0 0
    FUNCTION: DB2 UDB, database utilities, sqluMCContinueBackup,
    probe:830
    MESSAGE : ZRC=0x870F00B9=-2029059911=SQLO_SEM_TIMEOUT
                "Return code from sqlowait when time out value has
    been reached"
    -----
    

Local fix

  • a) Use COPY NO or NONRECOVERABLE, instead of COPY YES load
    option
    b) Reduce the invalid data of load, if failure occurs during
    load phase
    c) Use INDEXING MODE DEFERRED if possible, if failure occurs
    during build phase
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * LOAD operations with COPY YES option may timeout and fail,   *
    * when there                                                   *
    * is no data to write to the LOAD COPY image for a 120-second  *
    * period.                                                      *
    * This could happen if (for example) all the rows processed    *
    * within 120                                                   *
    * seconds are being rejected.  Db2diag.log may have below      *
    * entry for                                                    *
    * the LOAD.                                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 verision 9.5 FP9                              *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC77930

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-04

  • Closed date

    2012-02-20

  • Last modified date

    2012-02-20

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

    IC70133

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

Fix information

Applicable component levels

  • R950 PSY

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

Document Information

Modified date:
20 February 2012