PI19436: ISPF DIALOG ERROR ON ADB21SAR WHEN ALTER LOB TABLESPACE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ISPF dialog error on ADB21SAR when alter LOB tablespace.
  The message "Table is not open" appears, and the alter
  process is blocked.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR has resolves the following    *
  *                      issues:                                 *
  *                                                              *
  *                      1.  When attempting to alter a LOB      *
  *                      tablespace, the following dialog        *
  *                      error occurs:                           *
  *                                                              *
  *                      Function : TBQUERY &$TABLE              *
  *                      KEYNUM($KEYNUM)                         *
  *                      NAMENUM($NAMENUM)                       *
  *                      ROWNUM($ROWNUM)                         *
  *                      Retcode  : 12                           *
  *                      Zerrmsg  : ISPT034                      *
  *                      Zerrsm   : Table is not open            *
  *                      Zerrlm   : TBQUERY issued for table     *
  *                      ON that is not open.                    *
  *                                                              *
  *                      2.  LOG input field on panel ADB21SAR   *
  *                      'Table Space' shows a value of 'YES'    *
  *                      instead of 'NO' for a LOB tablespace    *
  *                      that has a DB2 Catalog attribute value  *
  *                      of LOG=X.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR has resolves the following issues:
  
  1.  When attempting to alter a LOB tablespace, the following
  dialog error occurs:
  
  Function : TBQUERY &$TABLE
  KEYNUM($KEYNUM)
  NAMENUM($NAMENUM)
  ROWNUM($ROWNUM)
  Retcode  : 12
  Zerrmsg  : ISPT034
  Zerrsm   : Table is not open
  Zerrlm   : TBQUERY issued for table
  ON that is not open.
  
  2.  LOG input field on panel ADB21SAR 'Table Space' shows
  'a value of 'YES' instead of 'NO' for a LOB tablespace
  that has a DB2 Catalog attribute value of LOG=X.
  

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:

  UI19187 UI19188

Modules/Macros

•    ADB21S   ADB21SA  ADB21SAR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19187

     UP14/06/28 P F406

• RB10 PSY UI19188

     UP14/06/28 P F406

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.