PM23997: UNLOAD FAILS MSGDSNU094I KEYWORD PUNCHDDN UNLDDN DUPLICATED NO FFA10 720 ONLY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS, using ALC function to move a
  table from one tablespace to another, builds UNLOAD utility
  control statement which contains duplicate keywords PUNCHDDN
  and UNLDDN as shown below:
  .
  000195   UNLOAD TABLESPACE DBT3D.PM53001
  000196    PUNCHDDN ALCNT1
  000197    UNLDDN ALCULD1
  000198     FROM TABLELD1
  000199 "DB2TEST"."TBL_A"
  000200   PUNCHDDN(ALCNT1)
  000201   UNLDDN(ALCULD1)
  .
  Utility fails rc8 rc08 with messages DSNU094I DSNU012I .
  Problem only occurs when:
    Use customized utility options: yes
  is specified in panel ADB27A .
  .
  Additional keywords: msgdsnu012i dsnugptc dsnugptf
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the ALC function to             *
  *                 change the table definition and specify      *
  *                 templates and utility options for the        *
  *                 UNLOAD utility.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Administration Tool for      *
  *                      z/OS, when using the ALC function       *
  *                      to move a table from one table          *
  *                      space to another, the generated         *
  *                      UNLOAD utility control statement        *
  *                      contains duplicate keywords             *
  *                      PUNCHDDN and UNLDDN.                    *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When using the ALC function to change a table and ATL
  templates ALCNT and ALULD are defined, the generated
  UNLOAD utility control statement contains duplicate
  keywords PUNCHDDN and UNLDDN when both
  'Generate template statements' and 'Use customized utility
  options' are set to Yes.
  

Problem conclusion

• The program has been modified by removing the duplicated
  keywords PUNCHDDN and UNLDDN in the UNLOAD utility
  control statement when 'Use customized utility options' is
  set to Yes.  The program has been modified to enable the
  use of the UNLOAD utility options when using WSL (work
  statement lists) with user defined templates used for the
  UNLOAD.
  

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:

  UK63558

Modules/Macros

•    ADB27ACM ADB27TL  ADB27TUL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK63558

     UP11/01/07 P F101

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.