PM71845: ADBTEP2 DSNU049I DSNUGPRS - INVALID OPERAND '.AAA' FOR KEYWORD 'CHECK'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADBTEP2 DSNU049I DSNUGPRS - INVALID OPERAND '.AAA' FOR KEYWORD
  'CHECK'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use ADMIN CHECK DATA statements     *
  *                 in Work Statement Lists (WSL) and who have   *
  *                 migrated databases from DB2 R710 to DB2 10   *
  *                 New Function Mode (NFM).                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      failed to trim the trailing blanks      *
  *                      from database and tablespace names      *
  *                      retrieved from the DB2 catalog when     *
  *                      translating an ADMIN CHECK DATA         *
  *                      statement, and the database and/or      *
  *                      tablespace contain trailing blanks      *
  *                      due to a migration of the object        *
  *                      from DB2 R710 NFM or earlier and        *
  *                      persists through DB2 10 NFM.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS failed to trim the
  trailing blanks from database and tablespace names retrieved
  from the DB2 catalog when translating an ADMIN CHECK DATA
  statement, and the database and/or tablespace contain trailing
  blanks due to a migration of the object from DB2 R710 and
  earlier to DB2 10 NFM. When running the following statement via
  ADBTEP2:
  
  ADMIN CHECK DATA
  TABLE "XXXX"."XXXXXXX_TBL"
  
  this translated to the following statement:
  
  CHECK DATA TABLESPACE XXXX    .XXXXXXX
  SORTDEVT SYSDA
  
  where XXXX is the database name and XXXXXXX is the
  tablespace name containing the table indicated in the
  ADMIN CHECK DATA statement. As the database was created
  prior to DB2 R810 NFM, the value stored in the NAME
  column of the SYSIBM.SYSTABLESPACE has trailing blanks.
  The blanks trailing the database name in the statement
  caused the following error in the CHECK utility:
  
  INVALID OPERAND '.XXXXXXX' FOR KEYWORD 'CHECK'
                             SORTNUM 4
                             ERRDDN(IOCERR)
                             WORKDDN(IOCWRK1,IOCWRK2)
  
  UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
  

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:

  UK82928

Modules/Macros

•    ADBTEPI
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK82928

     UP12/10/30 P F210

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.