IBM Support

PI77159: PI77159 ADD SUPPORT FOR NEW IGNORE OPTIONS FOR THE LOAD UTILITY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • PI77159 ADD SUPPORT FOR NEW IGNORE OPTIONS FOR THE LOAD UTILITY
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 12 for z/OS users of LOAD                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Add additional options on the IGNORE                         *
    * keyword of LOAD.                                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    Users require the ability to specify additional keywords on
    the IGNORE option of LOAD to ignore records rejected by LOAD
    for various reasons.
    

Problem conclusion

  • PI77159 introduces the following changes to externals:
    
    The following change will be made to the DB2 Utility Guide and
    Reference in the LOAD syntax section.  These syntax changes and
    description should fully explain the intended function.
    
    >-+---------------------------------+--+-------------------+->
      |             .-------------.     |  '-| decfloat-spec |-'
      |             V             |     |
      '-IGNORE(--+---WHEN------+--+--)--'
                 +---PART------+
                 +---CONV------+
                 +---VALPROC---+
                 +---IDERROR---+
                 +---IDERROR---+
                 +---DUPKEY----+
    
    IGNORE(...)
    Specifies that the LOAD utility ignores records that it rejects
    for the specified reasons. If discarding is specified, no
    ignored rows are loaded or written to the DISCARD data set. If
    discarding is not specified, ignored records do not cause the
    LOAD utility to terminate. Use the record count messages in the
    utility output to determine the number of records ignored.
    
    WHEN     Specifies that records that do not satisfy the WHEN
             clause are ignored
    PART     Specifies that records that do not satisfy any
             partition being loaded are ignored
    CONV     Specifies that records that cause a conversion error
             are ignored
    VALPROC  Specifies that records that fail a validation
             procedure are ignored
    IDERROR  Specifies that records that have an identity column
             value that is out of range are ignored
    DUPKEY   Specifies that records that cause a duplicate key
             error are ignored
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI77159

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-23

  • Closed date

    2017-06-27

  • Last modified date

    2017-08-02

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

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

    UI48240

Modules/Macros

  • DSNUGPRS DSNURWBG DSNUGPRT DSNURDIC DSNURBXD DSNUGUCA DSNUGPPF
    DSNURVIX DSNURDNP DSNURCRF DSNURWBF
    

Publications Referenced
SC278860    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI48240

       UP17/07/07 P F707

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU050","label":"BU NOT IDENTIFIED"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 August 2017