PH50194: DB2 ADMIN TOOL FAILS TO ADD HISTORY TABLE TO ACCELERATOR V7.5.7

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When trying to add one history table (TYPE=H) to accelerator
  v7.5.7 with DB2 Administration Tool, the following message is
  received on the accelerator add panel:
  
  Table(s) can not be added because one or more of the tables are
  not of base type (TYPE=T).
  

Local fix

• The fix is a one line change in panel (ISPPLIB) ADBPZAT0 (that
  is a zero) - so around line 208 change this line
  
  
  {code:java}
  
  
  AND TYPE = ''T'''  {code}
  
  
  to this:
  
  
  {code:java}
  
  
  AND TYPE IN (''T'',''R'',''H'')' {code}
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use accelerators                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When trying to issue the ADDA line      *
  *                      command to add a history or archive     *
  *                      table to the accelerator, the user      *
  *                      encounters either an error message,     *
  *                      ADBZ008E or                             *
  *                      an infinite loop.  An infinite loop     *
  *                      might also occur if the user tries to   *
  *                      issue ADDA on a table that is not of    *
  *                      type 'T', 'H' or 'R'.                   *
  *                                                              *
  ****************************************************************
  On panel ADB21T, issuing the ADDA line command on tables with
  type 'H' (History) or 'R' (Archive) results in the message,
  ADBZ008E, "Table(s) can not be added because one or more of the
  tables are not of base type (TYPE=T)" or an infinite loop.  The
  ADDA line command on other table types, other than 'T', can also
  result in an infinite loop.
  

Problem conclusion

• The problems have 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:

  UI83658 UI83659

Modules/Macros

• ADBPZAT0 ADBPZATA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI83658

     UP22/12/13 P F212

• RD10 PSY UI83659

     UP22/12/13 P F212

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.