PH64287: VARIOUS FIXES FOR LOG ANALYSIS V3.6

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Fixed possible ISPP121E ISPF error when Model 2 (24x80) used.
  Fixed possible S0C4 in ALASUBGC.ALAALOG.
  Fixed possible skip of the full IC after processing incremental
   IC.
  Fixed output of the ALAA576E error message.
  Fixed possible incorrect FRMTFILE sorting in 1PH-64 mode with
   UOW commit scope.
  Fixed possible incorrect conversion of NULL value for
   BINARY/VARBINARY column.
  Fixed possible abend in ALAGEN1 (S0C4 in 2ph mode / S001 in
   1ph mode) on an attempt to report over LOAD REPLACE with filter
   by name on a specific partition.
  Added filtering over dropped objects in Archive output
   processing (ALAARC2) when 'PROCESS ALL=N'.
  Added PARTITION processing for dropped objects.
  Fixed possible SQL -206 error code for SQLIND=360.
  Fixed possible SA03 ABEND in ALAARC2.
  Fixed possible error in SQL generation from TCz
   (SALADENU(ALAUD001) - schema SYSTOOLS is hardcoded).
  TCz jobs descriptions were improved
  Fixed possible incorrect data in Details Report when 'Current
   row by key=Y'.
  Fixed possible S0C4 on an attempt to report over LOAD LOG
   (YES) with filter by name on a specific partition.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Log Analysis Tool for z/Os  *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Fixed possible allocation LOADFILE   *
  *                      DD with 65535 TRACKS in ALACLDEL.       *
  *                      2. Fixed possible S0C4 in ALADTL2.      *
  *                      3. Fixed possible ISPP121E ISPF error   *
  *                      when Model 2 (24x80) used.              *
  *                      4. Fixed possible S0C4 in               *
  *                      ALASUBC.ALAGLF2 on building index for   *
  *                      filters.                                *
  *                      5. Fixed possible S0C4 in               *
  *                      ALASUBGC.ALAALOG.                       *
  *                      6. Fixed possible skip of the full IC   *
  *                      after processing incremental IC.        *
  *                      7. Fixed output of the ALAA576E error   *
  *                      message.                                *
  *                      8. Fixed possible incorrect FRMTFILE    *
  *                      sorting in 1PH-64 mode with UOW commit  *
  *                      scope.                                  *
  *                      9. Fixed possible incorrect conversion  *
  *                      of NULL value for BINARY/VARBINARY      *
  *                      column.                                 *
  *                      10. Fixed possible abend in ALAGEN1     *
  *                      (S0C4 in 2ph mode / S001 in 1ph mode)   *
  *                      on an attempt to report over LOAD       *
  *                      REPLACE with filter by name on a        *
  *                      specific partition.                     *
  *                      11. Added filtering over dropped        *
  *                      objects in Archive output processing    *
  *                      (ALAARC2) when 'PROCESS ALL=N'.         *
  *                      12. Added PARTITION processing for      *
  *                      dropped objects.                        *
  *                      13. Fixed possible SQL -206 error code  *
  *                      for SQLIND=360.                         *
  *                      14. Fixed possible SA03 ABEND in        *
  *                      ALAARC2.                                *
  *                      15. Fixed possible error in SQL         *
  *                      generation from TCz (SALADENU(ALAUD001) *
  *                       - schema SYSTOOLS is hardcoded).       *
  *                      16. TCz jobs descriptions were          *
  *                      improved.                               *
  *                      17. Fixed possible incorrect data in    *
  *                      Details Report when                     *
  *                      'Current row by key=Y'.                 *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Various fixes for Db2 Log Analysis Tool V 3.6
  

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:

Modules/Macros

• ALA$$CCQ ALA$$SEQ ALAAA11  ALAAA18  ALAAA9   ALAARC2  ALAATVI
  ALABHDR  ALABSQL  ALACATF  ALACFREP ALACFRR  ALACUOW6 ALACURR
  ALADSNM  ALADTL6  ALAERR   ALAETV   ALAEXTFD ALAFMAIN ALAFRCA
  ALAGEN1  ALAGEND  ALAGENR  ALAGFL2  ALAGFLA  ALAGFLT  ALAGIC
  ALAHLP1  ALAIR2   ALAJSON  ALALAUD  ALALB3   ALALF1   ALALF1A
  ALALF1B  ALALF2   ALAMAIN  ALAMPR2  ALAMPRT  ALAMSP   ALAQGRPN
  ALAQMAIN ALAQT    ALAQTL   ALAQTP   ALAREC   ALAREC3  ALASBDB
  ALASBDF  ALASKLR  ALASLX   ALASQL2B ALASQL3B ALASUBGC ALAUD001
  ALAZHSWN
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R360 PSY UI99437

     UP25/01/02 P F412

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.