A fix is available
APAR status
Closed as program error.
Error description
SQLCODE204 (-204) after apply of UK39168. Instead of trying to access DB2PM tables, PE Server should first test their availability upon start up by issuing a query against the system catalog. If the tables are not available all function requiring the tables will be disabled to avoid -204 (a warning message will be issued).
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - PE Server subtask * **************************************************************** * PROBLEM DESCRIPTION: The DB2PM database will be created * * when PWH is launched for the first * * time. This will then also create all * * DB2PM tables for instance the one for * * the processing of DB2 Connect. But * * if PWH has never been launched, the * * tables will not be created and a * * SQLCode -204 will be fired when * * accessing the tables. * * * **************************************************************** * RECOMMENDATION: Apply this PTF * **************************************************************** PROBLEM SUMMARY: When using history and DB2 Connect, the OMPE Server is accessing DB2PM tables, but if PWH has not been launched the tables are not created. So SQLCode -204 is fired when there are being accessed. PROBLEM CONCLUSION: Before accessing the DB2PM tables in DB2 Connect, we will check the presence of the DB2PM database.
Problem conclusion
Before accessing the DB2PM tables in DB2 Connect, we will check the presence of the DB2PM database. KEYWORDS : SQL -204 PWH DB2PM
Temporary fix
Comments
APAR Information
APAR number
PK72953
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-09-29
Closed date
2008-12-04
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:
UK42161
Modules/Macros
DGO@BTCH DGO@CONV DGO@DB DGO@DB2I DGO@DB2S DGO@DTA1 DGO@LOAD DGO@MIG1 DGO@MIG2 DGO@MT1 DGO@MT2 DGO@MT3 DGO@MT4 DGO@MT5 DGO@PC1 DGO@PC2 DGO@PC3 DGO@PC4 DGO@SCRD DGO@SDOB DGO@SQPA DGO@TBL DGO@WRPA DGO@WRP2 DGO@WR2C DGO@WSTE DGOVBMG DGOVCCP DGOVCINI DGOVDB2I DGOVDB2M DGOVDB2S DGOVDMSG DGOVDS DGOVDSIN DGOVDSRC DGOVDSS DGOVEEDI DGOVEEDR DGOVEEDS DGOVEE00 DGOVEE01 DGOVGIFC DGOVHMCD DGOVHMDR DGOVHMM0 DGOVHMM1 DGOVHMM2 DGOVHMSD DGOVHMS1 DGOVHMTC DGOVHM00 DGOVISIT DGOVMB DGOVMDI DGOVMDSP DGOVMIDI DGOVMMXM DGOVMRAP DGOVMSTR DGOVMUAE DGOVM001 DGOVM002 DGOVPCON DGOVPMOV DGOVPOPT DGOVPP1 DGOVPP2 DGOVPP3 DGOVPP4 DGOVPUPD DGOVRGM1 DGOVRG01 DGOVRG02 DGOVRG03 DGOVRG04 DGOVRG10 DGOVRG11 DGOVRG12 DGOVRG13 DGOVRG20 DGOVRG21 DGOVRG22 DGOVRG23 DGOVRG24 DGOVRG25 DGOVRG26 DGOVRG27 DGOVRG28 DGOVRG4B DGOVRG4C DGOVRG4X DGOVRPRM DGOVRSFI DGOVSCNI DGOVSCPI DGOVSCS2 DGOVSCS3 DGOVSDOB DGOVSDSC DGOVSERI DGOVSGFT DGOVSGSA DGOVSQRY DGOVSQSM DGOVSQTR DGOVSSEN DGOVSUBS DGOVTAC DGOVTBI DGOVTCL DGOVTCPD DGOVTCPL DGOVTCPS DGOVTCPT DGOVTGC DGOVTGS DGOVTIA DGOVTLI DGOVTSCL DGOVTSD DGOVTSEX DGOVTSIA DGOVTSO DGOVTSOI DGOVTSSD DGOVTSSO DGOVTSTA DGOVTSTS DGOVTSX DGOVTTA DGOVTWR DGOVUAS0 DGOVUM00 DGOVUM01 DGOVUM02 DGOVUSS0 DGOVWDOG DGOVWRPA DGOVWRP2 DGOVWR2C DGOVXMSG DGOVZRAC DGOVZTCC DGOVZTRC DGOZBIND DGOZBTCH DGOZBTC2 DGOZCONV DGOZCOPY DGOZDB DGOZDMDB DGOZDTA1 DGOZFL1 DGOZLOAD DGOZMIG1 DGOZMIG2 DGOZMT1 DGOZMT2 DGOZMT3 DGOZMT4 DGOZMT5 DGOZPC1 DGOZPC2 DGOZPC3 DGOZPC4 DGOZRSDS DGOZSCRD DGOZSQPA DGOZSUB1 DGOZSUB2 DGOZTBL DGOZWSTE FPE@DB2I FPE@DB2S FPE@WRPA FPE@WRP2 FPE@WR2C FPEVDB2I FPEVDB2S FPEVDB22 FPEVM000 FPEVSERV FPEVWRPA FPEVWRP2 FPEVWR2C FPEVZMAI FPEVZRAC FPEZPMS
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R410 PSY UK42161
UP08/12/06 P F812
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