PK53487: ISPT034 TABLE IS NOT OPEN TBQUERY ISSUED FOR TABLE OO THAT IS NOT OPEN WHEN USING SM 'STANDARD MAINTENANCE' PANEL ADB25LU

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool panel ADB25LU 'LISTDEF Utilities''s
  SM Standard Maintenance option fails with a message ISPT034
  Table is not open TBQUERY issued for table OO that is not open.
  when the SM option shows:
  SM - Standard Maintenance  OO x x x x ( where x is any option )
  and
  Generate work statement list  : YES
  Generate template statements  : YES
  are set.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 Admin Tool users who use listdefs.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When Primary command SM was used in     *
  *                      screen ADB25LU an ISPF error resulted.  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The SM command for Listdefs got diverted to screen ADB2USOO,
  which duplicates screen ADB25LUO, and from there abended.
  

Problem conclusion

• Code was changed to correct the screen path for Standard
  Maintenance on Listdefs and prevent the ISPF error.
  

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:

Modules/Macros

•    ADB2USO1 ADB25LU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK35281

     UP08/04/16 P F804

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.