IBM Support

PI96136: LOAD SUPPORT FOR MULTIPLE SYSREC DATA SETS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • LOAD Support for Multiple SYSREC data sets
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 12 for z/OS users of the LOAD                        *
    * Utility.                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * LOAD Support for Multiple SYSREC data                        *
    * sets.                                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    Add support to the LOAD utility to allow specification of
    multiple input data sets in a single INDDN keyword.
    

Problem conclusion

  • The LOAD utility will be enhanced to allow multiple INDDN
    names at the top-level of the LOAD statement or on individual
    INTO TABLE PART clauses of the LOAD statement to support
    loading multiple input data sets as input to LOAD.
    
    The following syntax change will be made to the Utility Guide
    and Reference:
    
             .-DATA-.  .-INDDN--SYSREC---------.
    >>-LOAD--+------+--+-----------------------+--+-----------+-->
                       +-INDDN--ddname---------+  ?-PREFORMAT-'
                       |        .--,-------.   |
                       |        V          |   |
                       +-INDDN(----ddname--+-)-|
                       '-INCURSOR--cursor-name-'
    
    INDDN (ddname,?)
    If multiple ddname values are provided in a list, the data sets
    represented by those ddnames are dynamically concatenated to a
    single ddname which becomes the input to LOAD.
    
    
    INTO-TABLE-spec:
                                .-IGNOREFIELDS--NO--.
    >>-INTO--TABLE--table-name--+-------------------+------------->
                                '-IGNOREFIELDS--YES-'
    
    
    >-+-------------------------------------------------->
      |
      '-PART--integer--+-----------+-| resume-spec |----->
                       '-PREFORMAT-'
    
           >--------------------------------------------------+-->
                  .-INDDN -SYSREC---------------------------. |
           >------+-----------------------------------------+-'
                  +-INDDN -ddname-----+-------------------+-+
                  |                   '-DISCARDDN--ddname-' |
                  |        .--,----.                        |
                  |        V       |                        |
                  +-INDDN(--ddname-+-)+-------------------+-+
                  '-INCURSOR--cursor-name-------------------'
    
    INDDN (ddname,?)
    If multiple ddname values are provided in a list, the data
    sets represented by those ddnames are dynamically
    concatenated to a single ddname which becomes the input for
    the partition.
    

Temporary fix

Comments

  • ×**** PE19/06/25 FIX IN ERROR. SEE APAR PH11741  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PI96136

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-04-03

  • Closed date

    2019-03-29

  • Last modified date

    2019-06-25

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

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

    UI62234

Modules/Macros

  • DSNURELD DSNUGPRZ DSNURWI  DSNUGPRT DSNUGUCA DSNURPNI DSNUGPPF
    DSNURWIM DSNURPPI
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI62234

       UP19/04/16 P F904

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:
25 June 2019