IBM Support

PH22937: IMPROVED PERFORMANCE FOR AUDITING REPORTS WHEN USING EXCLUDE OBJECT FILTERS.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Filter processing was improved to decrease CPU consumption when
    filtering large amount of objects.
    Also, the number of SQL queries was reduced to perform more
    efficient processing of object filters with wildcards.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Filter processing was improved to       *
    *                      decrease CPU consumption when filtering *
    *                      large amount of objects.                *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    .
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH22937

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    350

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-03-06

  • Closed date

    2020-04-02

  • Last modified date

    2020-05-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI68788

Modules/Macros

  • ALA#CMET ALA#DSA  ALA#ERRM ALA#HSA  ALA#LCLF ALA#LDSN ALA#LOAD
    ALA#MREP ALA#STOR ALA#TRS  ALA#WTO  ALA$ADM1 ALA$ADMN ALA@CAF
    ALA@CAFA ALA@FD28 ALA@FFN8 ALA@FSP  ALA@MNT  ALAAC    ALAAFER
    ALAAFPS  ALAAFVL  ALAAFWC  ALAAFWR  ALAALOG  ALAARC1  ALAARC2
    ALABDCT  ALABHDR  ALABLNKT ALABPC   ALABSCV  ALABSDM  ALABSDR
    ALABSDS  ALABSQL  ALABSSQL ALACAF   ALACATF  ALACATR  ALACC
    ALACDC   ALACDF   ALACDICT ALACFG   ALACFGRP ALACFREP ALACFRR
    ALACLDEL ALACMDR  ALACREP  ALACRRF  ALACSQL  ALACSSQL ALACTAU
    ALACUOW  ALACUOW6 ALACURR  ALADB2S  ALADB2SP ALADCNV  ALADCTP
    ALADECP  ALADELER ALADFLT  ALADSNM  ALADSPG  ALADSUM  ALADSUMR
    ALADTL1  ALADTL2  ALADTL3  ALADTL4  ALADTL6  ALADTLF  ALADTR
    ALADTS   ALADYN   ALAEBS   ALAEDIT  ALAERR   ALAERRIN ALAESQL
    ALAETV   ALAEXP   ALAEXPI  ALAEXTF  ALAEXTFD ALAFA    ALAFCP
    ALAFFV   ALAFLD   ALAFLDR  ALAFMAIN ALAFR1   ALAFR12  ALAFR1A
    ALAFR1AV ALAFR1C  ALAFR1CS ALAFR1CV ALAFR1D  ALAFR1F  ALAFR1G
    ALAFR1GV ALAFR1I  ALAFR1IV ALAFR1L  ALAFR1LS ALAFR1LT ALAFR1LV
    ALAFR1M  ALAFR1MA ALAFR1MP ALAFR1MV ALAFR1PV ALAFR1Q  ALAFR1QV
    ALAFR1V  ALAFR1X  ALAFR1XV ALAFR2   ALAFR2M  ALAFR2V  ALAFR3
    ALAFR6   ALAFR64  ALAFR6A  ALAFR6D  ALAFR6I  ALAFR6PR ALAFR6SN
    ALAFR6T  ALAFR6TC ALAFR6TV ALAFR6X  ALAFR7UT ALAFR8A  ALAFR8B
    ALAFR9   ALAFRA   ALAFRCL  ALAFRCT  ALAFRMTR ALAFRPAT ALAFRPER
    ALAFRPEX ALAFRPMD ALAFRPMN ALAFRPNW ALAFRPOP ALAFRQGL ALAFRQGR
    ALAFRQGS ALAFRQIV ALAFRQUS ALAFRTV  ALAFRTVV ALAFTC   ALAGAL
    ALAGEN1  ALAGEND  ALAGENR  ALAGFL2  ALAGFLA  ALAGFLT  ALAGIC
    ALAGL2   ALAGL3   ALAGLCS  ALAGLOAD ALAGLOAT ALAGLS   ALAGLSUM
    ALAGMR   ALAGMT   ALAGRWRT ALAHLI2  ALAHSM   ALAIDCM  ALAIDRP
    ALAIF    ALAIOEX  ALAIR2   ALAISPMN ALAIXP   ALALAUD  ALALB1
    ALALB2   ALALB3   ALALBC1  ALALBC2  ALALCC   ALALF1   ALALF1A
    ALALF1B  ALALF2   ALALF3   ALALF3W  ALALF4   ALALFP   ALALLB
    ALALOGP  ALALOGR  ALALPC   ALALPD   ALALVALT ALALXP   ALAM64PP
    ALAMAINT ALAMDTL  ALAMGR   ALAMLOB  ALAMLS   ALAMLSWR ALAMMIF
    ALAMPR2  ALAMPRT  ALAMSP   ALANBLKT ALANNUMT ALAOBD   ALAPEXP
    ALAPGR   ALAPGR2  ALAPH    ALAPRI   ALAPRI2  ALAPSB   ALAQT
    ALAQTL   ALAQTP   ALARDR   ALARE64  ALAREC   ALAREC2  ALAREC3
    ALAREC3W ALARM    ALARM64  ALARMW   ALARRFC  ALARTT   ALARXML
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R350 PSY UI68788

       UP20/04/09 P F004

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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z Systems"}],"Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 May 2020