PI25390: GOC - LOAD FAILS WITH S0C4 ABEND, WHEN ALT A TABLE IF COLUMN TRUNCATION = D- DISCARD, UNLOAD METHOD = P.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GOC - LOAD FAILS WITH S0C4 ABEND, WHEN ALT A TABLE IF COLUMN
  TRUNCATION = D- DISCARD, UNLOAD METHOD = P.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS who would like to use DB2 parallel      *
  *                 UNLOAD/LOAD for a dropped and recreated      *
  *                 table during change processes like 'ALT      *
  *                 Alter Table' (ALT), Object Compare, and      *
  *                 Change Management (CM).                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for         *
  *                      z/OS does not support specifying        *
  *                      'P - Parallel unload' in the            *
  *                      'Unload method' field on panel          *
  *                      ADB2C11A 'Generate Analyze Job'         *
  *                      to activate DB2 UNLOAD/LOAD             *
  *                      in parallel when using Change           *
  *                      Management.                             *
  *                                                              *
  *                      The DB2 Administration Tool for         *
  *                      z/OS does not support specifying        *
  *                      'P' in the parameter 'unload_method'    *
  *                      to activate DB2 UNLOAD/LOAD             *
  *                      in parallel when using the Change       *
  *                      Management batch (CM Batch)             *
  *                      interface.                              *
  *                                                              *
  *                      The LOAD utility will fail with the     *
  *                      error below if the data is discarded    *
  *                      during the execution of Work            *
  *                      Statement List (WSL) when               *
  *                      specifying 'P - Parallel unload' in     *
  *                      the 'Unload method' field to            *
  *                      generate the WSL on panel GOC5          *
  *                      'Generate Compare Jobs' or panel        *
  *                      ADBPALT 'ALTER - Build Analyze          *
  *                      and Apply Job':                         *
  *                                                              *
  *                      - DSNU364I DSNURPPL -                   *
  *                      PARTITIONS WILL BE LOADED IN            *
  *                      PARALLEL, NUMBER OF TASKS = >l<         *
  *                      - DSNU364I DSNURPPL - MAXIMUM           *
  *                      PARTITION PARALLELISM IS >l<            *
  *                      BASED ON NUMBER OF INPUT FILES          *
  *                      - DSNU338I DSNURWBF - INVALID           *
  *                      COLUMN SPECIFICATION FOR                *
  *                      >column_name<                           *
  *                      - DSNU302I DSNURWBF - (RE)LOAD          *
  *                      PHASE STATISTICS - NUMBER OF            *
  *                      INPUT RECORDS PROCESSED=>m<             *
  *                      - DSNU338I DSNURWBF - INVALID           *
  *                      COLUMN SPECIFICATION FOR                *
  *                      >column_name<                           *
  *                      - DSNU302I DSNURWBF - (RE)LOAD          *
  *                      PHASE STATISTICS - NUMBER OF            *
  *                      INPUT RECORDS PROCESSED=>n<             *
  *                      - DSNU017I DSNUGSAT - UTILITY           *
  *                      DATA BASE SERVICES MEMORY               *
  *                      EXECUTION ABENDED,                      *
  *                      REASON=X'00E40323'                      *
  *                      - DSNU016I DSNUGBAC - UTILITY           *
  *                      BATCH MEMORY EXECUTION                  *
  *                      ABENDED, REASON=X'00E40347'             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS does not support
  specifying 'P - Parallel unload' in the 'Unload method'
  field on panel ADB2C11A 'Generate Analyze Job' to activate
  DB2 UNLOAD/LOAD in parallel when using Change Management.
  
  The DB2 Administration Tool for z/OS does not support
  specifying 'P' in the parameter 'unload_method' to activate
  DB2 UNLOAD/LOAD in parallel when using the Change Management
  batch (CM Batch) interface.
  
  The LOAD utility will fail with the error below if the data is
  discarded during the execution of Work Statement List (WSL)
  when specifying 'P - Parallel unload' in the 'Unload method'
  field to generate the WSL on panel GOC5 'Generate Compare
  Jobs' or panel ADBPALT 'ALTER - Build Analyze and Apply Job':
  
  - DSNU364I DSNURPPL - PARTITIONS WILL BE LOADED
  IN PARALLEL, NUMBER OF TASKS = >l<
  - DSNU364I DSNURPPL - MAXIMUM PARTITION PARALLELISM IS >l<
  BASED ON NUMBER OF INPUT FILES
  - DSNU338I DSNURWBF - INVALID COLUMN SPECIFICATION FOR
  >column_name<
  - DSNU302I DSNURWBF - (RE)LOAD PHASE STATISTICS - NUMBER
  OF INPUT RECORDS PROCESSED=>m<
  - DSNU338I DSNURWBF - INVALID COLUMN SPECIFICATION FOR
  >column_name<
  - DSNU302I DSNURWBF - (RE)LOAD PHASE STATISTICS - NUMBER
  OF INPUT RECORDS PROCESSED=>n<
  - DSNU017I DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY
  EXECUTION ABENDED, REASON=X'00E40323'
  - DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION
  ABENDED, REASON=X'00E40347'
  

Problem conclusion

• The program has been modified to enable specifying
  'P - Parallel unload' in the 'Unload method' field on
  panel ADB2C11A 'Generate Analyze Job' to activate
  DB2 UNLOAD/LOAD in parallel when using Change
  Management.
  
  The program has been modified to enable specifying
  'P' in the parameter 'unload_method' to activate DB2
  UNLOAD/LOAD in parallel when using the Change
  Management batch (CM Batch) interface.
  
  The program has been modified to resolve the LOAD
  utility error during the execution of Work Statement
  List (WSL) when specifying 'P - Parallel unload' in the
  'Unload method' field to generate the WSL on panel
  GOC5 'Generate Compare Jobs' or panel ADBPALT
  'ALTER - Build Analyze and Apply Job'.
  
  After applying this APAR, please note the following changes
  for using DB2 Parallel UNLOAD/LOAD:
  
  1. DB2 Parallel UNLOAD/LOAD will be activated in the
  change processes when the following factors are true:
  
  -  The changes are compatible with DB2 Parallel UNLOAD/LOAD
     when a table is loaded into a partitioned table space and
     the number of partitions has not been changed.
  -  For non CM Batch, the 'Unload method' field on panels GOC5
     'Generate Compare Job' / ADBPALT 'Build Analyze and Apply
     Job' / ADB2C11A 'Generate Analyze Job' is set to 'P'.
     For CM Batch, the 'unload_method' parameter is set to 'P'.
  
  
  2. When DB2 UNLOAD is requested to be done in parallel, if the
  user-defined template ALULD or ALULDC is specified in non CM
  Batch path or if the parameter
  'util_template_unload_unlddn_name',
  'util_template_unload_unlddnc_name',
  'util_clone_template_unload_unlddn_name' or
  'util_clone_template_unload_unlddnc_name' is specified to use
  user-defined template in CM Batch path, an additional P&PA
  qualifier will be added to the template if &PA is not already
  present in the template which will extend the length of the
  result data set name by 7 bytes.
  
  TIP: Please consider the extended length of the resulting
  data set when specifying the maximum data set length for the
  template.
  
  3. When DB2 UNLOAD is requested to be done in parallel, if the
  user-defined template ALULD or ALULDC is not used in non CM
  Batch path or if the parameter 'util_template_unload_unlddn_name
  'util_template_unload_unlddnc_name',
  'util_clone_template_unload_unlddn_name' or
  'util_clone_template_unload_unlddnc_name' is not used in CM
  Batch path, the default data sets defined in variables
  ASYRECH/ASYRECHC of skeleton ADB2UCUS will be used as a
  parallel unload template for base and clone objects, so they
  must include &&PART. or &&PA., and the default data sets defined
  in variables ASYRECW/ASYRECWC of skeleton ADB2UCUS will be used
  for converting unload data if needed for base and clone
  objects, so they must include &&PART. or &&PA as well.
  
  4. When DB2 UNLOAD is requested to be done in parallel, if the
  user-defined template DISCARDDN is used in non CM Batch
  path or if the parameter 'util_template_discarddn_name' or
  'util_clone_template_discarddn_name' is used in CM Batch path,
  an additional P&PA qualifier will be added to the template if
  &PA is not already present in the template which will extend
  the length of the result data set name by 7 bytes.
  
  TIP: Please consider the extended length of the resulting
  data set when specifying the maximum data set length for the
  template.
  
  5. When DB2 UNLOAD is requested to be done in parallel, if the
  user-defined template DISCARDDN is not used in non CM Batch
  path or if the parameter 'util_template_discarddn_name' or
  'util_clone_template_discarddn_name'  is not used in CM Batch
  path, the default data set defined in variable SYSDISC of
  skeleton ADB2UCUS will be used as a parallel discard template
  and be forced to append an additional P&PA qualifier if &PA is
  not already present in the data set name which will extend
  the length of the result data set name by 7 bytes.
  
  TIP: Please consider the extended length of the resulting
  data set before running the job.
  
  Updates to the DB2 Administration Tool for z/OS, User's Guide
  and Reference, Version 11, Release 1 will be available in the
  following techdoc after 10/31/2014:
  
  http://www-01.ibm.com/support/docview.wss?uid=swg27041314
  

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:

  UI22293

Modules/Macros

•    GOC5H
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB10 PSY UI22293

     UP14/10/22 P F410

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.