PI27360: ROLLUP APAR #1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses the following issues:
  1. When a rebind of the V4.2 plans / packages is performed,
     a BIND error "Contoken = '  'X is not unique" can occur.
  .
  2. The widget for the control file field does not allow the user
     to enter a control file name greater than 26 characters.
     Automation Tool allows 38 characters when customizing via
     TCz.
  .
  3. FREQVAL and/or HISTOGRAM rebuild index column statistics are
     not saved after being added from panel HAA$STI1.
  .
  4. Panel HAA$TSKA is not filled correctly after creating or
     updating a Runstats Maintenance Window.
  .
  5. A S0C1 abend can occur in ISPF when issuing an Update
     command on panel HAA$ADMX.
  .
  6. A -204 SQL error can occur on table SYSAUTO.ACTION from the
     Autonomic Actions panel (HAA$ALRT).
  .
  7. A -204 SQL error can occur on table SYSAUTO.AUTORUNS_HIST
     from the Autonomic Execution History panel (HAA$ADEH).
  .
  8. DB2 V7 validation and associated messages removed.
  .
  9.  If you specify the 'Default WLM environment' on the DB2
      parameters in TCz, the stored procedure ADMIN_UTL_MONITOR is
      created with the first two characters of the WLM name
      truncated.
  .
  10. When running DB2 V10 CM (compatibility mode) and building
      Automation Tool utilities with LISTDEFs and Group by
      Partition options, the following message 'HAAB366W Group
      Parts By for REORG TS turned off because DB2 V9  LISTDEF
      does not support more than one PARTLEVEL number' may occur.
      DB2 V10 CM does support more than one PARTLEVEL on LISTDEF
      and therefore the Group by Partition options should be
      honored.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses the following       *
  *                      issues:                                 *
  *                      1. When a rebind of the V4.2 plans /    *
  *                      packages is performed, a BIND error     *
  *                      "Contoken = '  'X is not unique" can    *
  *                      occur.                                  *
  *                      2. The widget for the control file      *
  *                      field does not allow the use to enter   *
  *                      a control file name greater than 26     *
  *                      characters. Automation Tool allows 38   *
  *                      characters when customizing via TCz.    *
  *                      3. FREQVAL and/or HISTOGRAM rebuild     *
  *                      index column statistics are not saved   *
  *                      after being added from panel HAA$STI1.  *
  *                      4. Panel HAA$TSKA is not filled         *
  *                      correctly after creating or updating a  *
  *                      Runstats Maintenance Window.            *
  *                      5. A S0C1 abend can occur in ISPF when  *
  *                      issuing an Update command on panel      *
  *                      HAA$ADMX.                               *
  *                      6. A -204 SQL error can occur on table  *
  *                      SYSAUTO.ACTION from the Autonomic       *
  *                      Actions panel (HAA$ALRT).               *
  *                      7. A -204 SQL error can occur on table  *
  *                      SYSAUTO.AUTORUNS_HIST from the          *
  *                      Autonomic Execution History panel       *
  *                      (HAA$ADEH).                             *
  *                      8. DB2 V7 validation and associated     *
  *                      messages removed.                       *
  *                      9.  If you specify the 'Default WLM     *
  *                      environment' on the DB2 parameters in   *
  *                      TCz, the stored procedure               *
  *                      ADMIN_UTL_MONITOR is created with the   *
  *                      first two characters of the WLM name    *
  *                      truncated.                              *
  *                      10. When running DB2 V10 CM             *
  *                      (compatibility mode) and building       *
  *                      Automation Tool utilities with          *
  *                      LISTDEFs and Group by Partition         *
  *                      options, the following message          *
  *                      'HAAB366W Group Parts By for REORG TS   *
  *                      turned off because DB2 V9  LISTDEF      *
  *                      does not support more than one          *
  *                      PARTLEVEL number' may occur. DB2 V10    *
  *                      CM does support more than one           *
  *                      PARTLEVEL on LISTDEF and therefore the  *
  *                      Group by Partition options should be    *
  *                      honored.                                *
  ****************************************************************
  * 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:

  UI24263

Modules/Macros

•    HAA$$PRM HAA$ADMW HAA$FCOL HAA$MPRX HAA$OPVL
  HAA$ORSD HAA$REP0 HAA$TASK HAA$TPRU HAA$UCHX HAA$VIE2 HAA#AOBP
  HAA#AOIM HAA#AUTO HAA#BCLR HAA#BCTC HAA#BPRI HAA#BSQL HAA#BSTS
  HAA#BST7 HAA#BST8 HAA#BTMP HAA#CL   HAA#CL7  HAA#CL8  HAA#DB2V
  HAA#DMAL HAA#DMSQ HAA#DXCI HAA#DXCL HAA#DXCT HAA#DXDB HAA#DXDI
  HAA#DXDN HAA#DXDS HAA#DXDT HAA#DXES HAA#DXEV HAA#DXIN HAA#DXIS
  HAA#DXI2 HAA#DXQD HAA#DXQN HAA#DXQS HAA#DXSG HAA#DXSI HAA#DXST
  HAA#DXSV HAA#DXTS HAA#DXT2 HAA#DXVD HAA#ECDS HAA#EDAY HAA#EMCS
  HAA#EMIC HAA#EMID HAA#EPRI HAA#ERSH HAA#ERSI HAA#ERSU HAA#ERTA
  HAA#ERTI HAA#ERT8 HAA#ERT9 HAA#ESCP HAA#ESTI HAA#ETGI HAA#EXCS
  HAA#EXUX HAA#HPSC HAA#ICPO HAA#ICP7 HAA#ICP8 HAA#ILOB HAA#IOPF
  HAA#IX   HAA#IXN8 HAA#IXPT HAA#IXP8 HAA#IXP9 HAA#IX10 HAA#IX7
  HAA#IX8  HAA#IX9  HAA#JPRI HAA#LDEP HAA#LOBC HAA#LOB7 HAA#LOB8
  HAA#LPIO HAA#MPRI HAA#NTFB HAA#NTFM HAA#NTFU HAA#OBEX HAA#OPCL
  HAA#OPRI HAA#OPVD HAA#PDEP HAA#PITC HAA#PITS HAA#PLOG HAA#RALR
  HAA#RCFS HAA#RH   HAA#RH10 HAA#RI   HAA#RIV7 HAA#RIV8 HAA#SCHD
  HAA#SCPY HAA#SETP HAA#SQLE HAA#TABL HAA#TB   HAA#TBPT HAA#TB7
  HAA#TB8  HAA#TP   HAA#TP10 HAA#TS   HAA#TSS  HAA#TSSA HAA#TS10
  HAA#TS7  HAA#TS8  HAA#TS9  HAA#UOPC HAA#UPRI HAA#UTOB HAA#VERT
  HAA#XMLC HAA#YARC HAA#YCAL HAA#YCTL HAA#YDEL HAA@HPTB HAA@HPTS
  HAA@HPUC HAA@IOSC HAA@IOTB HAA@PROF HAA@SYMR HAADDLX  HAADDLY
  HAAEXP1  HAAJO2A  HAAJSTAT HAAM256E HAANOT1A HAANOT2A HAAOE1A
  HAAOE2A  HAAPRF1A HAASQL1A HAA151E  HAA18
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R420 PSY UI24263

     UP15/01/22 P F501

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.