PK97116: OC AND CM DROP / CREATE SCENARIOS FAIL RC08 IN IC JOBSTEP WITH RESERVED TABLESPACE NAME "ROLE" AND TEMPLATE NAME SYSCOPY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool Change Management (CM) or DB2 Object
  Compare drop / create scenarios where tablespace name is a
  reserved keyword in DB2, such as "ROLE", and the default
  TEMPLATE name of SYSCOPY is used for DB2 Utility Image Copy (IC)
  the IC jobstep fails rc8 due to JCL error. Problem is seen as
  invalid dataset name (DSN) in SYSCOPY TEMPLATE because the
  tablespace name appears within quotes in the DSN parm of the
  TEMPLATE.
  .
  Joblog output appears similar to the following:
  .
    TEMPLATE SYSCOPY DSN 'VNDO327.PM25506.DSN8.IC.ADWD."ROLE"'
  DSNU049I    DSNUGPS2 - INVALID OPERAND
     ''VNDO327.PM25506.DSN8.IC.ADWD."ROLE"'' FOR KEYWORD 'DSN'
  DSNU005I    DSNUGPS2 -          UNIT SYSDA
  DSNU005I    DSNUGPS2 - COPY TABLESPACE ADWD."ROLE"
  DSNU005I    DSNUGPS2 -     COPYDDN(SYSCOPY)
  DSNU012I    DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST
              RETURN CODE=8
  ADBT015I  Failure attempting to execute   ADB2UTIL  with parm
  DSN8,C0004602,,
  .
  ADB5184E Program terminating due to error with non-SQL command
  .
  Additional symptom keywords: msgdsnu049i msgadbt015i
    msgadb5184e role
  

Local fix

• Use any other TEMPLATE name other than SYSCOPY, such as
    COPYDDN .
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison               *
  *                 Tool for z/OS where compare involves         *
  *                 drop/create scenarios where the              *
  *                 table space name is a reserved               *
  *                 keyword in DB2                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Object Comparison Tool           *
  *                      drop/create scenarios where the         *
  *                      table space name is a reserved          *
  *                      keyword in DB2, such as "ROLE",         *
  *                      the default template name               *
  *                      SYSCOPY is used for the DB2             *
  *                      utility image copy (IC), and the IC     *
  *                      jobstep fails with RC=8 due to a        *
  *                      JCL error. The problem is seen as       *
  *                      an invalid dataset name (DSN) in        *
  *                      the SYSCOPY template because            *
  *                      the table space name appears            *
  *                      within quotes in the DSN parameter      *
  *                      of the template.                        *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When the compare involves a drop/create of a table
  that is based on a table space having DB2 reserved
  keywords like "ROLE" as the table space name, then
  the apply job fails while running the image
  copy utility.
  
  In addition, the image copy is generated twice in this
  case.
  

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:

  UK59529

Modules/Macros

•    GOCGAJOB
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK59529

     UP10/08/12 P F008

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.