PK54399: VARIOUS DB2 AUTOMATION TOOL PANEL AND REPORTING CHANGES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. PF keys cover clone entry on panel HAA$OTL9.
  The option:"Process Cloned Tables N (Y or N)"
     on Panel HAA$OTL9 "Enter Tablespaces Like to Display"
     is covered by the PF keys when PFSHOW ON.
  
  2. No edits for "Process Dependent Indexes" on HAA$OTL8,
     HAA$OTL9, and HAA$OTLK.  Error message HAAM056E will
     now be issued if an invalid value is entered for
     "Process Dependent Indexes".
  
  3. Help panel HAAH0249 has been updated from the following:
  
     "Type N to not update catalog tables; this option is
      only valid when REPORT YES is specified."
  
     To the following:
  
     "Type N to not update catalog tables."
  
  4. When selecting REPORT N in conjunction with UPDATE N on
     HAA$URST using DB2 V7 and earlier, new message HAA386E
     will now be displayed with the following text:
  
     "When Update is set to "N"one, the Report option must
      be set to a "Y"es.  This is a DB2 restriction prior
      to version 8."
  
  5. The REPORT option has been removed from HAA$ERST.
     Dynamic RUNSTATs do not allow REPORT NO, making this
     field invalid.
  

Local fix

• Set PFSHOW to OFF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. PF keys cover clone entry on panel   *
  *                      HAA$OTL9. The option:"Process Cloned    *
  *                      Tables N (Y or N)" on Panel HAA$OTL9    *
  *                      "Enter Tablespaces Like to Display"     *
  *                      is covered by the PF keys when PFSHOW   *
  *                      ON.                                     *
  *                      2. No edits for "Process Dependent      *
  *                      Indexes" on HAA$OTL8, HAA$OTL9, and     *
  *                      HAA$OTLK.  Error message HAAM056E will  *
  *                      now be issued if an invalid value is    *
  *                      entered for "Process Dependent          *
  *                      Indexes".                               *
  *                      3. Help panel HAAH0249 has been         *
  *                      updated from the following:             *
  *                      "Type N to not update catalog tables;   *
  *                      this option is only valid when REPORT   *
  *                      YES is specified." To the following:    *
  *                      "Type N to not update catalog tables."  *
  *                      4. When selecting REPORT N in           *
  *                      conjunction with UPDATE N on HAA$URST   *
  *                      using DB2 V7 and earlier, new message   *
  *                      HAA386E will now be displayed with the  *
  *                      following text: "When Update is set to  *
  *                      "N"one, the Report option must be set   *
  *                      to a "Y"es.  This is a DB2 restriction  *
  *                      prior to version 8."                    *
  *                      5. The REPORT option has been removed   *
  *                      from HAA$ERST. Dynamic RUNSTATs do not  *
  *                      allow REPORT NO, making this field      *
  *                      invalid.                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK33424

Modules/Macros

• HAA$DELO HAA$ERST HAA$OPRU HAA$OTLK HAA$OTL8
  HAA$OTL9 HAA$URST HAA@PROF HAAHDELO HAAHM249 HAAH0249 HAAH0280
  HAAM40   HAAM404E HAA15    HAA151E  HAA38    HAA386E
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R220 PSY UK33424

     UP08/02/08 P F802

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.