PI96136: LOAD SUPPORT FOR MULTIPLE SYSREC DATA SETS

Obtain the fix for this APAR.

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 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.