PH19072: NEW FUNCTION FOR THE LOAD REPLACE UTILITY TO DEFINE AUXILIARY PAGESETS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New function for the LOAD REPLACE utility to define auxiliary
  pagesets.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of LOAD utility                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * New DEFINEAUX keyword option for the                         *
  * LOAD utility                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR introduces a new keyword option, DEFINEAUX, to the
  LOAD utility, which enables the LOAD utility to define the
  target LOB or XML objects regardless they would be populated
  or not.
  The IBM Knowledge Center is updated for these changes:
  https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/
  ugref/src/tpc/db2z_loadsyntax.
  LOAD syntax diagram:
  >--LOAD--...
     |-DEFINEAUX--NO--|
  >--|----------------|-----|--into-table-spec--|--
     |-DEFINEAUX--YES-|
  DEFINEAUX
  Specifies whether the LOAD utility will define all target LOB
  or XML table spaces and their indexes if they are DEFINE NO at
  the start of the utility execution, which does not require the
  LOAD utility to populate these auxiliary objects.  This keyword
  can only be specified for LOAD SHRLEVEL NONE with REPLACE or
  RESUME keyword specified at the global level.
  NO
  Specifies that LOAD takes no special action to define the
  target LOB or XML objects.  These auxiliary objects would be
  defined as needed when LOAD populates data into them.
  This is the default behavior.
  YES
  Specifies that LOAD takes specific action to define all target
  LOB and XML objects and their indexes at the start of the
  utility execution, regardless they would be populated or not
  as part of the LOAD execution.
  

Problem conclusion

Temporary fix

Comments

• Code has been modified to deliver the aforementioned
  new function under the LOAD utility.
  

APAR Information

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

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

  UI70477

Modules/Macros

• DSNURRST DSNURILD DSNURWIR DSNUGDDF DSNUGRAR DSNUGUCA DSNUGPRT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI70477

     UP20/07/21 P F007

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.