PH37344: VARIOUS FIXES FOR LOG ANALYSIS TOOL V3.5.0

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Possible ALAA440E error when running in non HI-SPEED mode
  caused by incorrectly merged spanned records in the Detail
  report step.
  2. Possible long running SQL generation when requesting the
  SQL for tables with implicitly hidden columns.
  3. Possible U0033 ABEND when processing the table with field
  procedure instead of ALAA075E indicating that the issue
  occurred within the fieldproc itself.
  4. Possible incorrect allocation of ARCHOUT DD, that can lead to
  B37 and other abends due to inaccurate allocation parameters.
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION: 1) Possible ALAA440E error when         *
  *                         running in non HI-SPEED mode caused  *
  *                         by incorrectly merged spanned        *
  *                         records in the Detail report step.   *
  *                      2) Possible long running SQL            *
  *                         generation when requesting the SQL   *
  *                         for tables with implicitly hidden    *
  *                         columns.                             *
  *                      3) Possible U0033 ABEND when            *
  *                         processing the table with field      *
  *                         procedure instead of ALAA075E        *
  *                         indicating that the issue            *
  *                         occurred within the fieldproc        *
  *                         itself.                              *
  *                      4) Possible incorrect allocation of     *
  *                         ARCHOUT DD, that can lead to B37     *
  *                         and other abends due to              *
  *                         accurate allocation parameters.      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1.  Possible ALAA440E error caused by incorrect merge in ALADTL1
  2.  Possible long running SQL generation
  3.  Possible U0033 ABEND when ALAA075E occurs
  4.  Improve ARCHOUT DD allocation
  

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:

  UI75769

Modules/Macros

• ALA#LCLF ALA#LDSN ALAARC1  ALAARC2  ALABSCV  ALABSQL  ALABSSQL
  ALACDF   ALACLDEL ALACREP  ALACTAU  ALACUOW  ALACUOW6 ALAFRMTR
  ALAGFLA  ALAIOEX  ALALAUD  ALALF3   ALALF3W  ALALF4   ALALXP
  ALAMLOB  ALAPRI2  ALAREC3  ALAREC3W ALASBDB  ALASBDF  ALASETUP
  ALASI    ALASPLL  ALATSC   ALAXDRP
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI75769

     UP21/06/11 P F106

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.