PI42087: BAD RESPONSE TIME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Sometime very bad response time: 1s to >1 min! Response up to 30
  secs after hitting ?Enter-Key?! The timedout screen shot was
  for Dynamic SQL
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Enhanced 3270 UI                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Too many statements in dynamic SQL      *
  *                      cache causes query timeout from         *
  *                      Enhanced 3270 UI KDPDSQLS workspace.    *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Bad response time or query timeout from KDPDSQLS workspace when
  dynamic SQL cache has more than 5000 statements.
  
  PROBLEM CONCLUSION:
  Provide filtering from KDPDSQLS workspace to allow selective
  data retrieval for dynamic SQL statements.
  
  KEYWORDS:
  DSQL KDPDSQLS QUERY TIMED OUT
  

Problem conclusion

• Provide filtering from KDPDSQLS workspace to allow selective
  data retrieval for dynamic SQL statements.
  

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:

  UI30917

Modules/Macros

• FPEVCTM  FPEVDB2C FPEVDB2I FPEVFRM  FPEVRDS1 FPEVREQ0 FPEVZMAI
  KDPDSQLA KDPDSQLF KDPDSQLH KDPDSQLO KDPDSQLS KDPDSQLX KDPDYNST
  KDPEDMTB KDPEDT2A KDPLOGTB KDPLOGT9 KDPSTATB KD5AGENT KO2ABROW
  KO2AFSAM KO2AHLR  KO2APHLR KO2ATABL KO2CPUCL KO2PUVLS KO25ACCT
  KO25CHLD KO25DSQL KO25DSQ2 KO25DSTX KO25EDMP KO25FRTS KO25HACL
  KO25HACT KO25HBAC KO25HGLC KO25HLAC KO25HLKC KO25HTHD KO25HWT1
  KO25HWT2 KO25HXST KO25H8AC KO25KPI  KO25LOGS KO25QBST KO25QDBP
  KO25QISE KO25Q3ST KO25Q8AC KO25Q8ST KO25SQLT KO25SSQL KO25SSTX
  KO25SXST KO25TNAM KO25TXST KO25WAT1 KO25WAT2 KO25ZPRM KO25225
  KO252252 KO25230  KO25254  KO253162 KO25317  KO254012 TDKD2ODI
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R530 PSY UI30917

     UP15/10/02 P F509

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.