IBM Support

JR30505: APAR IZ24442_IZ29235 HAS A FIX WHEREBY IT DOES NOT PERFORM A DB2 LOAD FOR ZERO ROWS USING DB2 EE STAGE LOAD TRUNCATE MODE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After applying the patch for APAR IZ24442_IZ29235 the DB2 EE
    Stage using LOAD TRUNCATE with 0 rows, does not execute the
    command.
    

Local fix

  • Use WRITE/TRUNCATE or the db2 load command.
    
    This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users using DB2 Enterprise Stage
    ****************************************************************
    PROBLEM DESCRIPTION:
    Unable to  truncate DB2 table using DB2 Enterprise SJR30505tage
    LOAD write method with zero record input
    ****************************************************************
    RECOMMENDATION:
    Apply the patch for APAR JR30505.
    ****************************************************************
    

Problem conclusion

  • DB2 Enterprise Stage Load write method checks if input record
    has no record. If it contains no record, operator was finishing
    the job without executing LOAD.
    
    If we have zero record input from source, the DB2 Enterprise
    stage won't be able to truncate table.
    This was implemented to avoid AIX bug, and this problem was
    resolved by AIX patch Y86254.060621.epkg.
    
    If customer has applied AIX patch Y86254.060621.epkg, user can
    install this patch to enable DB2 table truncation using  zero
    record input. For other platforms, no Operating System patch is
    required.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR30505

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-09-26

  • Closed date

    2008-10-09

  • Last modified date

    2010-12-09

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

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

Modules/Macros

  • PXDB2
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R801 PSN

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 December 2010