PH31275: SLOW PERFORMANCE IN DETAIL REPORT WHEN RUNNING IN 1 PHASE MODE CERTAIN TYPE OF LOG ACTIVITY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running in 1 Phase mode, there is a performance issue in
  the Detail report.
  
  The issue was introduced in the UI72234 PTF.
  

Local fix

• Regenerate the JOB to be in 2 Phase QSAM for ROWDATA mode, this
  way the product will eliminate long running process that occurs
  in 1 Phase mode.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Performance degradation that            *
  *                      significantly increase the processing   *
  *                      volumes and reduce 31 bit memory usage. *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  LAT Performance.
  

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:

  UI72498

Modules/Macros

• ALAAFPS  ALAAFVL  ALABSQL  ALACDICT ALACFREP ALACMDR  ALADSNM
  ALADSUM  ALADTL1  ALAFCP   ALAFRMTR ALAFTC   ALAGEN1  ALAGEND
  ALAGENR  ALAGFL2  ALAGFLT  ALAGLOAD ALAGLSUM ALAHSM   ALAJSON
  ALALB1   ALALB2   ALALB3   ALALF1   ALALF1A  ALALF1B  ALALF2
  ALALF3   ALALF3W  ALALOGR  ALALPD   ALAM64PP ALAMLS   ALAMSP
  ALARE64  ALAREC   ALAREC2  ALAREC3  ALAREC3W ALARXML  ALASA
  ALASBDB  ALASBDF  ALASLX   ALASTOR  ALASTYPE ALASUBG  ALAUEX
  ALAURC   ALAURID  ALAURRE
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI72498

     UP20/11/12 P F011 ­

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.