A fix is available
APAR status
Closed as program error.
Error description
During start up customer sees a slow down or performance issue with slow enqueues on MAJOR=DGOVZRAC MINOR=RACROUTE for approx. 10 minutes. Once the initialization is done (to find all the DB2 catalog tables), then slow down is no longer occurring. The enqueues are needed for OBID/DBID translation of all the tablespace and dataspace names. Another enques are also seen but not as often as racroute - MAJOR=DGOVWRPA MINOR=CHKDB2C.
Local fix
Please apply ptf when available.
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - OMEGAMON Server * * - PE Server * * - Classic Interface * * - CUA Interface * **************************************************************** * PROBLEM DESCRIPTION: Poor performance of the product * * accompanied by enqueue contentions * * at OMEGAMON/PE Server startup stage * * or during switching between DB2 * * subsystems in OMEGAMON classic * * interface or TEP * **************************************************************** * RECOMMENDATION: Apply this PTF * **************************************************************** PROBLEM SUMMARY: Poor performance of the product accompanied by gradually growing number of enqueue contentions which can be checked per MVS command "D GRS,C", e.g.: ISG343I 07.17.11 GRS STATUS 460 S=STEP DGOVZRAC RACROUTE SYSNAME JOBNAME ASID TCBADDR EXC/SHR STATUS VGID KO2CI 01AC 00ABDB00 EXCLUSIVE OWN VGID KO2CI 01AC 00AA9B58 EXCLUSIVE WAIT VGID KO2CI 01AC 00ADC9F0 EXCLUSIVE WAIT VGID KO2CI 01AC 00AC2A60 EXCLUSIVE WAIT Major and minor names of the resources are usually "DGOVZRAC RACROUTE" or "DGOVWRPA CHKDB2C" correspondingly. The slowness may last dozens of minutes, the time span depends on complexity of a given DB2 subsystem, exactly saying on sizes of the following tables in the DB2 catalog: -sysibm.sysdatabase -sysibm.systablespace -sysibm.sysindexes PROBLEM CONCLUSION: The code of PESERVER has been correspondingly corrected.
Problem conclusion
The code of PESERVER has been correspondingly corrected. KEYWORDS : BAD PERFORMANCE DGOVZRAC RACROUTE DGOVWRPA CHKDB2C EXCLUSIVE WAIT ENQUEUE CONTENTIONS
Temporary fix
Comments
APAR Information
APAR number
PK61653
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2008-02-25
Closed date
2008-04-25
Last modified date
2017-02-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DGO@SDOB DGOVALII DGOVMSTR DGOVSDOB DGOVSQLI DGOVTCPS DGOVWLII DGOZSQLI KO2ACAFA KO2ACAFS KO2ACAF2 KO2CCAFA KO2CCAFS KO2CCAF2 KO2HCAFB KO2ICAFA KO2ICAFS KO2ICAF2 KO2ICOLA KO2ICOLS KO2ICOL2
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R410 PSY UK35877
UP08/04/28 P F804
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 February 2017