PI44594: DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT TRIM DATABASE AND TABLE SPACE WHEN USING CM NO AND RUN REORG/REBUILD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS does not trim database
  and table space when using CM NO and Run REORG/REBUILD
  created by WSL statements when DBname is shorter than
  8 characters
  Additional info:  message DSNU005I  >timestamp<  DSNUGPRS..
   DSNUGPRS - REORG TABLESPACE shortDBname  .TSname SCOPE PENDING
   DSNUGPRS - INVALID OPERAND '.TSname' FOR KEYWORD 'REORG'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who run the REORG utility on a table    *
  *                 space created on a database whose name is    *
  *                 shorter than 8 characters.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      appended space(s) to the database       *
  *                      name in the REORG statement, which      *
  *                      caused a REORG failure:                 *
  *                                                              *
  *                      DSNU049I DSNUGPRS - INVALID OPERAND     *
  *                      '.>table space name<'                   *
  *                      FOR KEYWORD 'REORG'                     *
  *                                                              *
  *                      For example:                            *
  *                                                              *
  *                      REORG TABLESPACE                        *
  *                      >database name<   .>table space name<   *
  *                      DSNU005I DSNUGPRS - REORG TABLESPACE    *
  *                                  >dbname<  .>tsname<         *
  *                                  SCOPE PENDING               *
  *                      DSNU049I DSNUGPRS - INVALID OPERAND     *
  *                                 '.>tsname<'                  *
  *                                  FOR KEYWORD 'REORG'         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Admin appended space(s) to the database name in the REORG
  statement during the CHG process, which caused a REORG failure
  if the database name is shorter than 8 characters.
  

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:

  UI30637

Modules/Macros

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI30637

     UP15/08/29 P F508

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.