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

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ADMIN CHECK DATA function
  utility jobs end:
  ADB5044I *** INPUT STATEMENT:
   ADMIN CHECK DATA
   TABLE "aaaa"."aaaaaaaaaaa"
     SORTDEVT SYSDA
     SORTNUM 4
     ERRDDN(aaaaaa)
     WORKDDN(aaaaaaa,aaaaaaa);
  DSNU005I    nnn nn:nn:nn.nn DSNUGPRS - CHECK DATA TABLESPACE
  aaaa    .aaaaaaa  SORTDEVT SYSDA
  DSNU049I    nnn nn:nn:nn.nn DSNUGPRS - INVALID OPERAND
  '.aaaaaaa' FOR KEYWORD 'CHECK'
  DSNU012I    nnn nn:nn:nn.nn DSNUGBAC - UTILITY EXECUTION
  TERMINATED, HIGHEST RETURN CODE=8
  

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.SYSDATABASE 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:

  UK81363

Modules/Macros

•    ADBTEPI
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81363

     UP12/08/30 P F208

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.