IBM Support

IC70133: 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 program error.

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:                                              *
    * DB2 Version 9.7 FIX PACK 2, 3, 3a and 4                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error description field for more information.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 FixPack 5.                        *
    ****************************************************************
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IC70133

  • 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

    2010-07-22

  • Closed date

    2012-01-03

  • Last modified date

    2012-03-08

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

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

    IC73046 IC77930

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

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

Document Information

Modified date:
08 March 2012