PM76369: EXECUTING STAND-ALONE UNLOAD UTILITY ON TABLE IN CLASSIC PARTITIONED OR PBR TABLESPACE BY WSL USING 12/12/04 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS.
  Executing stand-alone UNLOAD utility on table in classic
  partitioned or PBR tablespace by WSL using HPU-High Performance
  Unload results in RC=8 with error message:
  "INZC003E ERROR DDNAME ULD NOT ALLOCATED AND/OR NOT ROOT
  OF ANY ALLOCATED DDNAMES"
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 and DB2 Administration Tool for z/OS.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running an UNLOAD within a work    *
  *                      statement list (WSL), using High        *
  *                      Performance Unload for z/OS (HPU) as    *
  *                      the unload method, and using a punch    *
  *                      DD name other than SYSPUNCH or          *
  *                      unload DD name other than SYSREC,       *
  *                      the unload will fail because the DD's   *
  *                      are not allocated. The job fails        *
  *                      with a RC8 / Return Code 8 and the      *
  *                      following HPU error will be produced:   *
  *                                                              *
  *                      INZC003E ERROR DDNAME                   *
  *                      UTLREC NOT ALLOCATED                    *
  *                      AND/OR NOT ROOT OF ANY                  *
  *                      ALLOCATED DDNAMES                       *
  *                                                              *
  *                      INZU366I UTILITY RETURN CODE            *
  *                      8 (REASON CODE 0x107a002)               *
  *                      ADBT015I  Failure attempting            *
  *                      to execute INZUTILB with parm           *
  *                      ssid,TEST1,HIDDEN(YES)                  *
  *                              8                               *
  *                      ADB5184E The run is ending due to an    *
  *                      error with a non-SQL command.           *
  *                      Additional messages may have been       *
  *                      sent to the DD SYSTSPRT                 *
  *                           Additional diagnostics             *
  *                           NNNINYN                            *
  *                           commit_all_req=N                   *
  *                           asw_req       =N                   *
  *                           asw_app       =N                   *
  *                           asw_stmt_app  =I                   *
  *                           chk_rec_found =N                   *
  *                           SQLCODE -626? =N                   *
  *                                                              *
  *                      If the table space is partitioned,      *
  *                      this error will be produced:            *
  *                                                              *
  *                      INZC003E ERROR DDNAME ULD               *
  *                      NOT ALLOCATED  AND/OR NOT               *
  *                      ROOT OF ANY ALLOCATED                   *
  *                      DDNAMES                                 *
  *                                                              *
  *                      The first error occurs because the DD   *
  *                      is not allocated. The second occurs     *
  *                      because the OUTDDN(>value<) is forced   *
  *                      to OUTDDN(ULD) for partitioned object   *
  *                      unloads.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When running an UNLOAD within a Work Statement List (WSL),
  using High Performance Unload for z/OS (HPU) as the unload
  method, and using a punch DD name other than SYSPUNCH or
  unload DD name other than SYSREC, the unload will fail because
  the DD's are not allocated. The job fails with a RC8 / Return
  Code 8 and the following HPU error will be produced:
  
  INZC003E ERROR DDNAME UTLREC NOT ALLOCATED AND/OR NOT ROOT
  OF ANY ALLOCATED DDNAMES
  
  
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)
  ADBT015I  Failure attempting to execute INZUTILB with parm
  ssid,TEST1,HIDDEN(YES)
             8
  ADB5184E The run is ending due to an error with a non-SQL
  command.
  Additional messages may have been sent to the DD SYSTSPRT
       Additional diagnostics
       NNNINYN
       commit_all_req=N
       asw_req       =N
       asw_app       =N
       asw_stmt_app  =I
       chk_rec_found =N
       SQLCODE -626? =N
  
  If the table space is partitioned, this error will be
  produced:
  
  INZC003E ERROR DDNAME ULD NOT ALLOCATED AND/OR NOT
  ROOT OF ANY ALLOCATED DDNAMES
  
  The first error occurs because the DD is not allocated. The
  second occurs because the OUTDDN(>value<) is forced to
  OUTDDN(ULD) for partitioned object unloads.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK90384 UK90385

Modules/Macros

•    ADBTTP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK90384

     UP12/12/19 P F212

• RA20 PSY UK90385

     UP12/12/19 P F212

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.