PI96986: ADMIN TOOL BET COMMAND BATCH JOB DOES NOT PRODUCE REPORT IF ADBL EXECUTED WITHOUT PLAN PARAMETER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The BET command or line command may be executed on
  one of the following panels:
  - ADB21T 'Tables, Views, and Aliases'
  - ADB21K 'Packages'
  - ADBPZAT 'Display Accelerated Tables'
  If the ADBL clist had been executed without the PLAN parameter,
  batch job generated by the BET command produces
  the following statement, which is missing the default plan
  name 'ADB':
  %ADBRPGM  ADBDET DB2SYS(<ssid>) +
  As a result, if the batch job is run, it does not produce the
  expected 'Details for Objects' report.
  This APAR ensures that the report is created by including the
  default plan name 'ADB' in that statement in the batch job:
  %ADBRPGM ADB ADBDET DB2SYS(<ssid>) +
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When DB2 Administration Tool            *
  *                      is invoked without a plan name,         *
  *                      the batch job generated from a          *
  *                      BET primary or line command             *
  *                      does not produce a 'Details for         *
  *                      Objects' report.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The BET command or line command may be executed on
  one of the following panels:
  
   - ADB21T 'Tables, Views, and Aliases'
   - ADB21K 'Packages'
   - ADBPZAT 'Display Accelerated Tables'
  
  If the ADBL clist had been invoked without the PLAN parameter,
  the batch job generated by the BET command produces
  the following statement, which is missing the default plan
  name 'ADB':
  
  %ADBRPGM ADBDET DB2SYS(>ssid<) +
  
  As a result, if the batch job is run, it does not produce the
  expected 'Details for Objects' report.
  
  This APAR ensures that this report is produced by including the
  default plan name 'ADB' in that statement in the batch job:
  
  %ADBRPGM ADB ADBDET DB2SYS(>ssid<) +
  

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:

  UI55950 UI55951

Modules/Macros

•    ADBEBET
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI55950

     UP18/05/23 P F805

• RC10 PSY UI55951

     UP18/05/23 P F805

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.