IBM Support

PI32725: SLOW RESPONSE FROM SYSTEM SQL COUNTS SCREEN IN E3270 INTERFACE

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Entering System SQL Counts screen (KDPSQL1, option F from main
DB2 options menu) in e3270UI always takes more than 10 seconds.

Local fix

  • N/A

Problem summary

  • ****************************************************************
* USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
*                 users of component                           *
*                 - OMEGAMON collector                         *
*                 - PE Server subtask                          *
*                 - TEMA / TEMS                                *
*                 - TEP                                        *
*                 - Enhanced 3270 UI                           *
****************************************************************
* PROBLEM DESCRIPTION: Slow response time in some Enhanced     *
*                      3270 UI screens.                        *
****************************************************************
* RECOMMENDATION: Apply this PTF.                              *
****************************************************************
PROBLEM SUMMARY:
Processing involving absolute and delta values was inefficient.

PROBLEM CONCLUSION:
Improved delta value processing.

KEYWORDS:
SQL COUNTS LOG EDMP ENHANCED 3270 RESPONSE TIME

Problem conclusion

  • Improved delta value processing.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI32725
    • 

  • Reported component name
    OM XE DB2PE/PM
    • 

  • Reported component ID
    5655OPE00
    • 

  • Reported release
    520
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2015-01-15
    • 

  • Closed date
    2015-08-10
    • 

  • Last modified date
    2017-02-01
    • 





    

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

    • 

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

    
UI30071 UI30072
    

    • 



Modules/Macros


    

  • DGOMEXA0 DGOMEXA2 DGOVBMG  DGOVCINI DGOVCRDB DGOVDB2E DGOVDB2F
DGOVDB2I DGOVDMSG DGOVDS   DGOVDSRC DGOVDSS  DGOVHMCD DGOVHMM1
DGOVHMM2 DGOVHMM3 DGOVHM00 DGOVISI  DGOVISIT DGOVMRAS DGOVMSTR
DGOVM001 DGOVPIG0 DGOVPIG1 DGOVRGM1 DGOVRG00 DGOVRG01 DGOVRG02
DGOVRG03 DGOVRG04 DGOVRG10 DGOVRG11 DGOVRG12 DGOVRG13 DGOVRG20
DGOVRG21 DGOVRG22 DGOVRG23 DGOVRG24 DGOVRG25 DGOVRG26 DGOVRG27
DGOVRG28 DGOVRG4B DGOVRG4C DGOVRG4X DGOVSADJ DGOVSADK DGOVSCLO
DGOVSCLR DGOVSCNT DGOVSCON DGOVSCPI DGOVSDTS DGOVSDTT DGOVSGFT
DGOVSGSA DGOVSLOC DGOVSORT DGOVSQRY DGOVSQSM DGOVSQTR DGOVSSEN
DGOVSTAG DGOVTCPD DGOVTCPL DGOVTCPS DGOVTCPT DGOVTDI0 DGOVTSEX
DGOVTWR  DGOVUAS0 DGOVUELD DGOVUFTL DGOVUINI DGOVUM01 DGOVUSS0
FPE@DB2S FPEMEXA0 FPEVACI0 FPEVACM  FPEVCTM  FPEVDB2F FPEVDB2I
FPEVDB2S FPEVDB24 FPEVDB27 FPEVMMM  FPEVM000 FPEVRAC  FPEVRDS1
FPEVRDS2 FPEVREQ0 FPEVRTM  FPEVSAD3 FPEVSDCM FPEVSERV FPEVSPMM
FPEVXCMM FPEVZMAI HKDB520J KDB520J  KDPPLEX  KDPPSQLA KDPPSQLB
KDPPSQLD KDPPSQLE KDPPSQL1 KDPPSQL2 KDPPSQL3 KDPPSQL4 KDPPSQL5
KDPPSQL6 KDPPSQL7 KDPPSQL8 KDPSQLA  KDPSQLB  KDPSQLD  KDPSQLE
KDPSQL1  KDPSQL2  KDPSQL3  KDPSQL4  KDPSQL5  KDPSQL6  KDPSQL7
KDPSQL8  KD5AGENT KD5ATC00 KD5AUTO1 KO2ABROW KO2ACONB KO2AFLTF
KO2AGNTB KO2AHLR  KO2AINIB KO2AOMBB KO2APCAA KO2APCAK KO2APCAS
KO2APCBA KO2APCBK KO2APCBS KO2APCCA KO2APCCK KO2APCCS KO2APCEA
KO2APCEK KO2APCES KO2APCFA KO2APCFK KO2APCFS KO2APCGA KO2APCGK
KO2APCGS KO2APCHA KO2APCHK KO2APCHS KO2APCIA KO2APCIK KO2APCIS
KO2APCJA KO2APCJK KO2APCJS KO2APCKA KO2APCKK KO2APCKS KO2APCLA
KO2APCLK KO2APCLS KO2APCMA KO2APCMK KO2APCMS KO2APCNA KO2APCNK
KO2APCNS KO2APCOA KO2APCOK KO2APCOS KO2APCPA KO2APCPK KO2APCPS
KO2APCQA KO2APCQK KO2APCQS KO2APC1A KO2APC1K KO2APC1S KO2APC2A
KO2APC2K KO2APC2S KO2APC3A KO2APC3K KO2APC3S KO2APC4A KO2APC4K
KO2APC4S KO2APC9A KO2APC9K KO2APC9S KO2APHLR KO2ARECB KO2ATABL
KO2BDSPL KO2BHLR  KO2CCAFB KO2CIFAB KO2CIFBB KO2CIFCB KO2CIFDB
KO2CIFEB KO2CIF3A KO2CIF3K KO2CIF3S KO2CIF8A KO2CIF8K KO2CIF8S
KO2LACPM KO2LACRA KO2OCMCB KO2ODINB KO2ZOMI  KO2ZROU  KO25ACCT
KO25CHLD KO25EDMP KO25LOGS KO25QBST KO25QDBP KO25QISE KO25QWHC
KO25Q3ST KO25SXST KO25TNAM KO25TXST KO25WAT1 KO25WAT2 KO25ZPRM
KO25225  KO252252 KO25230  KO25254

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R520  PSY  UI30071
       UP15/08/12  P  F508
    • 

  • R530  PSY  UI30072
       UP15/08/12  P  F508
    • 



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.
    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.0"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            31 March 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback