PI98190: DB2 ADMIN TOOL - USING ALT/TS FUNCTION ISSUES ERROR MESSAGE ADB330E WHEN DSSIZE IS NULL AT PART LEVEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using ALT/TS function issues error message ADB330E when DSSIZE
  is NULL at part level
  

Local fix

• Add the following four line to EXEC(ADB21SAR) in subroutine
  convertDSSIZE highlighted with '<=== insert this line' (do not
  add '<=== insert this line'):
  
     /* Exception: If LOB=YES, Part 0 #DSSIZE is used instead ...
     /*                                      <=== insert this line
     if XNLOB <> "YES" then
       if partitio+0 = 0 then Return 0
     */                                      <=== insert this line
  
     do while rc = 0
       if dssize  = "?" then dssize  = ""    <=== insert this line
       if #dssize = "?" then #dssize = ""    <=== insert this line
       if dssize <> 0 & dssize <> "" & dssize <> "?" &,
          WORDS(dssize) = 1 then do
         dssize  = dssize  / 1024 / 1024
         dssize  = FORMAT(dssize,,0) "G"
       end
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Entering line command ALT for a         *
  *                      partitioned table space on panel        *
  *                      ADB21S 'Table Spaces', results          *
  *                      in error message ADB330E.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following error message occurs when entering line
  command ALT on panel ADB21S 'Table Spaces' for a
  partitioned table space due to DSSIZE with NULL value
  at part level in DB2 Catalog:
  
  ADB330E DSSIZE is allowed if NUMPARTS > 0,
  MAXPARTITIONS > 0, or LOB = YES.
  

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:

  UI56616

Modules/Macros

•    ADB21S   ADB21SA  ADB21SP  ADB26CS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI56616

     UP18/06/19 P F806

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.