PM37985: INCORRECT NAMES SHOWING IN DB2 COMMANDS AND DB2 UTILITY STATEMEN TS -STA DB(NOT NULL)| UNLOAD TABLESPACE NOT NULL.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS' APPLY jobs contain
  incorrect database and tablespace names used in DB2 commands:
    -STA DB(NOT NULL) SPACE()  ACCESS(RO)
  and DB2 Utility syntax:
    UNLOAD TABLESPACE NOT NULL.
  causing the APPLY job to fail with the STROnnnn step with a
  return code 8 and a message:
    -STA DB(NOT NULL) SPACE()  ACCESS(RO)
  DSN9010I  aaaaa- REQUIRED PARAMETER FOR KEYWORD 'SPACE' IS
  MISSING
  DSN9023I  aaaaa- DSN9SCND '-STA DB' ABNORMAL COMPLETION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who increase the number of partitions   *
  *                 in the compared table spaces and specify     *
  *                 'Suppress DROP of objects' = YES' on panel   *
  *                 GOC5 'Generate Compare Jobs'.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool for      *
  *                      z/OS APPLY jobs contain incorrect       *
  *                      database and table space names when     *
  *                      executing DB2 command:                  *
  *                                                              *
  *                      -STA DB(NOT NULL) SPACE() ACCESS(RO)    *
  *                                                              *
  *                      and DB2 Utility syntax:                 *
  *                                                              *
  *                      UNLOAD TABLESPACE NOT NULL.             *
  *                                                              *
  *                      causing the APPLY job to fail on        *
  *                      the STROnnnn step with a return         *
  *                      code 8 and message:                     *
  *                                                              *
  *                      -STA DB(NOT NULL) SPACE()  ACCESS(RO)   *
  *                      DSN9010I  aaaaa- REQUIRED PARAMETER     *
  *                      FOR KEYWORD 'SPACE' IS MISSING          *
  *                      DSN9023I  aaaaa- DSN9SCND               *
  *                      '-STA DB' ABNORMAL COMPLETION.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool generates an incorrect database
  name and table space name in the APPLY job.
  

Problem conclusion

• The 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:

Modules/Macros

•    GOC2CMF  GOC2CMP  GOC2CMR  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK69686

     UP11/07/15 P F107

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.