PH19073: TOLERATE FAILURE ON AN INVALID LOAD PARALLEL SPECIFICATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Tolerate failure on an invalid LOAD PARALLEL specification
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of the LOAD                        *
  * utility using PARALLEL keyword.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The LOAD utility execution terminates                        *
  * with a RC8 when the PARALLEL keyword                         *
  * is specified with certain LOAD                               *
  * scenarios.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Prior to this APAR, certain LOAD utility executions with the
  PARALLEL keyword would fail with RC8 with one of the following
  messages:
  DSNU070I - KEYWORD OR OPERAND 'PARALLEL' INVALID WITH
  'invalid_keyword'
  DSNU076I - KEYWORD=PARALLEL INVALID FOR 'invalid_type'
  TABLE SPACE= 'table_space'
  This APAR will relax the restriction in the LOAD utility by
  ignoring the PARALLEL keyword in the following situations:
  A single input data set is specified and the LOAD statement
  includes any of the following options: SPANNED YES,
  FORMAT INTERNAL, INCURSOR, PRESORTED, FORMAT SQL/DS.
  The table space to be loaded is a partition-by-growth table
  space and the LOAD statement includes the SHRLEVEL NONE option.
  The table to be loaded has XML columns and is in a simple or
  segmented table space, and the LOAD statement includes the
  SHRLEVEL CHANGE option.
  The table to be loaded has LOB or XML columns, and the LOAD
  statement includes the SHRLEVEL NONE option.
  Additional Keywords: MSGDSNU070I MSGDSNU076I MSGDSNU073I
  

Problem conclusion

• The LOAD code was modified to no longer end with RC8 when the
  PARALLEL keyword is specified with certain LOAD scenarios and
  will continue processing by ignoring the PARALLEL keyword and
  issuing the following message.
  DSNU073I - KEYWORD 'PARALLEL' IGNORED
  

Temporary fix

Comments

APAR Information

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

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

  UI68104

Modules/Macros

• DSNURWI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI68104

     UP20/03/06 P F003

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.