PM73625: INCONSISTENT ADBTEP2 MESSAGES AFTER SUCCESSFUL PROCESSING OF SQL SUCCESSFUL <ACTION> OF N ROW(S) VS ADB5180I SUCCESSFUL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Batch Restart program
  ADBTEP2 gives different messages after a successful action
  depending on the case of the DDL.
  
  For example an UPDATE >schema<.>table< SET COL1 = 1 will show
  SUCCESSFUL UPDATE     OF        n ROW(S)
  while an Update >schema<.>table< SET COL1 = 1 will show
  ADB5180I SUCCESSFUL
  

Local fix

• Use upper case syntax to see the 'SUCCESSFUL >action< OF n ROW(S
  ) message and lower case syntax to see the 'ADB5180I SUCCESSFUL'
  message.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use Batch Restart program       *
  *                 ADBTEP2.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for         *
  *                      z/OS Batch Restart program              *
  *                      ADBTEP2 gives different                 *
  *                      messages after a successful             *
  *                      action depending on the case            *
  *                      of the DDL.                             *
  *                                                              *
  *                      For example executing                   *
  *                      'UPDATE >schema<.>table<                *
  *                      SET COL1 = 1' will show message         *
  *                      'SUCCESSFUL UPDATE OF                   *
  *                      n ROW(S)', while executing              *
  *                      'Update >schema<.>table< SET            *
  *                      COL1 = 1' will show message             *
  *                      'ADB5180I SUCCESSFUL'.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS Batch Restart
  program ADBTEP2 gives different messages after a
  successful action depending on the case of the DDL.
  

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:

  UK90645 UK90646

Modules/Macros

•    ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK90645

     UP13/01/01 P F212

• RA20 PSY UK90646

     UP13/01/01 P F212

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.