PM97361: PANEL ADB2USU INCONSISTSENCY SPECIFYING YES/NO

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Panel ADB2USU is inconsistent whether YES or Y or NO or N
  can be specified.  For example in these two instances:
    NOSUBS . . . . . . . . Y   (Yes/Blank)  - can only specify Y
    SKIP LOCKED DATA   . . YES  (Yes/No)    - can specify YES or Y
  

Local fix

• Specify Y or YES or N or NO
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use panel ADB2USU 'Specify Utility  *
  *                 Options - UNLOAD'.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Panel ADB2USU is inconsistent when      *
  *                      'YES' or 'Y' or 'NO' or 'N' is          *
  *                      specified.                              *
  *                                                              *
  *                      For example in these two instances:     *
  *                                                              *
  *                                                              *
  *                        NOSUBS . . . . . .Y   (Yes/Blank)     *
  *                                 - can only specify Y         *
  *                        SKIP LOCKED DATA   . YES  (Yes/No)    *
  *                                 - can specify YES or Y       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program misses logic to specify YES for the 'NOSUBS' option on
  panel ADB2USU.
  

Problem conclusion

• Program has been updated on the following panels:
  
  ADBPLI 'Review errors and warnings - Columns'
  ADBPPDCC 'Drop DB2 Pending Definition Changes Confirmation'
  ADBP6CFR 'SQL Table Function'
  ADB2MES 'DB2 Table Space Estimator'
  ADB2MEX 'DB2 Index Space Estimator'
  ADB2USC 'Specify Utility Options - COPY DATA'
  ADB2USE 'Specify Utility Options - MERGECOPY'
  ADB2USK 'Specify Utility Options - CHECK'
  ADB2USKL 'Specify Utility Options - CHECK LOB'
  ADB2USU 'Specify Utility Options - UNLOAD'
  ADB2UXO 'Specify Utility Options - REORG INDEX'
  ADB2ZLZ 'Change DB2 System Checkpoint Frequency'
  

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:

  UI13858 UI13859

Modules/Macros

• ADBPLI   ADBPPDCC ADBP6CFR ADB2MES  ADB2MEX  ADB2USC  ADB2USE
  ADB2USK  ADB2USKL ADB2USU  ADB2UXO  ADB2ZLZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI13858

     UP13/12/28 P F312

• RB10 PSY UI13859

     UP13/12/28 P F312

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.