PH72451: VARIOUS FIXES FOR LOG ANALYSIS TOOL V3.6

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR fixes the following items:
  Possible SQL error -501 in STEPM or STEP2
  ALAA149 message correction
  Possible incorrect DTLIMP report when processing update
  variation 1 or 3 Improved validation of time values on ISPF
  panels Fixed possible U0077 Abend when requesting generation of
  SQL objects with LOB columns Possible ALAA073E when using
  HI-SPEED processing and requested object is compressed with a
  dictionary on the fly
  Possible incorrect U0036 Abend when processing objects with LOB
  columns Corrected the LOADCARD generation when using Fixed Table
  Owner/Name lengths in fixed format LOADFILE generation Corrected
  the DDL generation (removed possible duplicates) during
  LOADFILEs creation Corrected dynamic allocation of the Db2
  LOADLIBs in ISPF Possible excessive IC reads for objects with
  versioning Possible 0C4 Abend in ALASBDF
  Possible incorrect CATFILE lookup error when processing objects
  with LOBs and XMLs Corrected the example of SQL comment on the
  'SQL Parameters' panel
  Possible S0C4 when flash copy is processed for an object with
  LOB
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The APAR contains the following fixes:  *
  *                      1. Possible SQL error -501 in           *
  *                         STEPM or STEP2.                      *
  *                      2. Possible incorrect DTLIMP report     *
  *                         when processing update               *
  *                         variation 1 or 3.                    *
  *                      3. Possible U0077 Abend when            *
  *                         requesting generation of SQL objects *
  *                         with LOB columns.                    *
  *                      4. Possible ALAA073E when using         *
  *                         HI-SPEED processing and requested    *
  *                         object is compressed with            *
  *                         a dictionary on the fly.             *
  *                      5. Possible incorrect U0036 Abend when  *
  *                         processing objects with LOB columns. *
  *                      6. Possible excessive IC reads for      *
  *                         objects with versioning.             *
  *                      7. Possible 0C4 Abend in ALASBDF.       *
  *                      8. Possible incorrect CATFILE lookup    *
  *                         error when processing objects with   *
  *                         LOBs and XMLs.                       *
  *                      9. Corrected the LOADCARD generation    *
  *                         when using Fixed Table Owner/Name    *
  *                         lengths in fixed format LOADFILE     *
  *                         generation.                          *
  *                      10. Corrected the DDL generation        *
  *                         (removed possible duplicates)        *
  *                          during LOADFILEs creation.          *
  *                      11. Corrected dynamic allocation of     *
  *                          the Db2 LOADLIBs in ISPF.           *
  *                      12. Corrected the example of SQL        *
  *                          comment on the 'SQL Parameters'     *
  *                          panel.                              *
  *                      13. Possible S0C4 when flash copy is    *
  *                          processed for an object with LOB.   *
  *                      14. ALAA149 message correction.         *
  *                      15. Improved validation of time values  *
  *                         on ISPF panels.                      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Various fixes for Log Analysis Tool V3.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:

  UO08890

Modules/Macros

• ALA#ERRM ALA#LCLF ALA#LDSN ALA#STOR ALA@CALL ALAA14   ALAA84
  ALAAFWR  ALAAPICD ALAARC1  ALAARC2  ALAASQCM ALABSQL  ALACDC
  ALACLDEL ALACLOAT ALACMDR  ALACUOW6 ALACURR  ALADB2SP ALADELER
  ALADTL2  ALADTL3  ALAETV   ALAEXTF  ALAEXTFD ALAFMAIN ALAFRCA
  ALAFRDTL ALAFRMFC ALAFTC   ALAGEN1  ALAGEND  ALAGENR  ALAGFLA
  ALAGFLT  ALAGLOAD ALAGLSUM ALAGMT   ALAGNJCL ALAHRC   ALAJSON
  ALAJSONW ALALAUD  ALALB1   ALALDCOM ALALDST  ALALF1   ALALF1A
  ALALF1B  ALALF2   ALALF3   ALALF3W  ALALLB   ALAMDTL  ALAMGR
  ALAMLSWR ALAMNTRP ALAMSP   ALAOBD   ALAODPC  ALAPEXP  ALAQSRT
  ALARDR   ALARE64  ALAREC   ALAREC2  ALAREC3  ALAREC3W ALARFRMT
  ALARM64  ALARMW   ALARRE   ALARROWD ALASBDB  ALASBDF  ALASKLR
  ALASPLL  ALASQL2  ALASQL3  ALASQLF  ALASUBGC ALATSC   ALATV
  ALAUEX   ALAUTIL  ALAUTL64 ALAVRD
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R360 PSY UO08890

     UP26/08/06 I 1000

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.