PI85584: VARIOUS FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses the following issues:
  1) A S0C7 abend can occur in module HAA#BTMP (offset 00006E46)
  when parsing utility output for the collection run time
  statistics.
  2) Fix Typo ("...for for...") on help panel HAA542E.
  3) DSNDB01 objects appear twice on panel HAA$OPI8.
  4) Errors on panel HAA$STCG.  Runstats column group incorrectly
  created following a parameter error.
  5) Automation Tool allows Set profile to be specified along with
  Tablesample. This results in DSNU070I - KEYWORD OR OPERAND 'SET
  PROFILE' INVALID WITH 'TABLESAMPLE'.
  6) Create an option to generate the SET PROFILE parameter on
  Runstats for all tables in the object profile. Currently, a
  column level statistics definition is required for the SET
  PROFILE parameter to be generated for a table.
  
  7) Panel HAA$OP81 - Line command "I" on some DSNDB01
  tablespaces contain indexes - yet error HAAM005E is generated.
  
  8) Possible SQLCODE -302 when updating an object profile
  
  containing index with CREATOR > 8 bytes when attempting to
  create Object specific utility options.
  9) Implement code for compatibility with other tools.
  10) Help panel HAAHATRI missing "A" line command.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Automation Tool z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses the following       *
  *                      issues:                                 *
  *                      1. A S0C7 abend can occur in module     *
  *                      HAA#BTMP (offset 00006E46) when         *
  *                      parsing utility output for the          *
  *                      collection run time statistics.         *
  *                      2. Fix Typo ("...for for...") on help   *
  *                      panel HAA542E.                          *
  *                      3. DSNDB01 objects appear twice on      *
  *                      panel HAA$OPI8.                         *
  *                      4. Errors on panel HAA$STCG.  Runstats  *
  *                      column group incorrectly created        *
  *                      following a parameter error.            *
  *                      5. Automation Tool allows Set profile   *
  *                      to be specified along with Tablesample. *
  *                      This results in DSNU070I - KEYWORD OR   *
  *                      OPERAND 'SET PROFILE' INVALID WITH      *
  *                      'TABLESAMPLE'.                          *
  *                      6. Create an option to generate the     *
  *                      SET PROFILE parameter on Runstats for   *
  *                      all tables in the object profile.       *
  *                      Currently, a column level statistics    *
  *                      definition is required for the SET      *
  *                      PROFILE parameter to be generated for   *
  *                      a table.                                *
  *                      7. Panel HAA$OP81 - Line command "I"    *
  *                      on some DSNDB01 tablespaces contain     *
  *                      indexes - yet error HAAM005E is         *
  *                      generated.                              *
  *                      8. Possible SQLCODE -302 when updating  *
  *                      an object profile containing index      *
  *                      with CREATOR > 8 bytes when attempting  *
  *                      to create Object specific utility       *
  *                      options.                                *
  *                      9. Implement code for compatibility     *
  *                      with other tools.                       *
  *                      10. Help panel HAAHATRI missing "A"     *
  *                      line command.                           *
  ****************************************************************
  * 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:

  UI49838

Modules/Macros

•    HAA$ADM2 HAA$ASIM HAA$BMSG HAA$BUTE HAA$BUTH
  HAA$BUTT HAA$OPRT HAA$STCL HAA$STTB HAA$TSQJ HAA$URST HAA#BTMP
  HAA#IX   HAA#OBEX HAA#OPRI HAA#RI   HAA#TB   HAA#TB7  HAA#TB8
  HAA#TS   HAA#UPRI HAA#UTED HAA#UTOB HAAM133E HAA448E  HAA542E
  HAA81    HAA817E  H25H420J
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R420 PSY UI49838

     UP17/08/30 P F708

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.