PK22717: ALC VIA WSL FAILS RC=8 WITH DB2 MESSAGE DSNU071I DSNUBBID KEYWOR D 'COPY' REQUIRES KEYWORD 'COPYDDN'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool ALC command produced a WSL which
  when executed failed RC=8 with the msg DSNU071I DSNUBBID -
  KEYWORD 'COPY' REQUIRES KEYWORD 'COPYDDN'.
  The use of the 'UO' option in the DB2 Object Comparision tool
  before issuing the ALC line command in the DB2 Administration
  tool appears to be the cause of the issue.
  

Local fix

• Correct WSL manually to add required COPYDDN(aaaa) syntax.
  The COPY PARALLEL option specified in panel ADB2USC is
  being seen as the Administation Tool PARALLEL keyword
  so a semi-colon is being added to the COPY syntax, therefore
  remove the semi-colon or do not specify COPY PARALLEL.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, and users  *
  *                 of  DB2  Object  Comparison Tool, who do an  *
  *                 ALC  on  a  table  requesting an image copy  *
  *                 after setting  utility  options  in  Object  *
  *                 Compare, are affected.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When creating image copy step of an ALC *
  *                      the image copy utility options setup in *
  *                      Object Compare previously were          *
  *                      transferred to the ALC job.             *
  *                      .*                                      *
  *                      ALC command produced a WSL which failed *
  *                      when executed, with RC=8 and DSNU071I   *
  *                      DSNUBBID - KEYWORD 'COPY' REQUIRES      *
  *                      KEYWORD 'COPYDDN'.                      *
  *                      .*                                      *
  *                      The use of the 'UO' option in the DB2   *
  *                      Object Comparision Tool before issuing  *
  *                      the ALC line command in the DB2 Admin   *
  *                      Tool appears to be the cause of the     *
  *                      issue.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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:

  UK17750

Modules/Macros

•    ADB2USCO ADB27A
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK17750

     UP06/09/08 P F609

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.