A fix is available
APAR status
Closed as program error.
Error description
Customer gets the following error when OMPE server tried to recreate PWH tables : SQLCODE604 DSNT408I SQLCODE = -604, ERROR: A DATA TYPE DEFINITION SPECIFIES AN INVALID LENGTH, PRECISION, OR SCALE ATTRIBUTE DSNT418I SQLSTATE = 42611 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXICB3 SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 85 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000055' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION It occurs when PWH is enabled for more than one DB2 susbsystem configured for OMPE server.
Local fix
Start PE instances one-by-one to create tables successfully. It might be necessary to first delete any of PHW Databases that were created incorrectly before starting the PE instance. If in datasharing we recommend you have a unique name of the PWH started job (PWHADDRESSSPACENAME) for each subsystem also.
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - PE Server * * - Performance Warehouse users * **************************************************************** * PROBLEM DESCRIPTION: When starting PWH for more than one * * DB2 subsystem at the same time, the * * creation of the PWH tables could fail * * with SQLCODE -604. * **************************************************************** * RECOMMENDATION: Apply this PTF to solve this problem. * **************************************************************** PROBLEM SUMMARY: If an OMPE Server has configured and activated PWH for more than one DB2 subsystem, the creation of the PWH tables could fail with a SQLCODE -604. The response file was read once for each parameter for the same DB2 subsystem. PROBLEM CONCLUSION: The response is now only read once pro DB2 subsystem. The PWH tables will now be created successfully.
Problem conclusion
The response is now only read once pro DB2 subsystem. he PWH tables will now be created successfully. KEYWORDS : PWH TABLE FAIL SQLCODE -604
Temporary fix
Comments
APAR Information
APAR number
PK56322
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
2007-11-12
Closed date
2007-12-05
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:
UK31931
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 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 DGOVM000 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 DGOVSCNI DGOVSCPI DGOVSCS2 DGOVSCS3 DGOVSDOB DGOVSDSC DGOVSERI DGOVSERV 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 DGOVZMAI DGOVZRAC DGOVZTCC DGOVZTRC DGOZBIND DGOZBTCH DGOZBTC2 DGOZCONV DGOZCOPY DGOZDB DGOZDMDB DGOZDTA1 DGOZFL1 DGOZLOAD DGOZMIG1 DGOZMIG2 DGOZMT1 DGOZMT2 DGOZMT3 DGOZMT4 DGOZMT5 DGOZPC1 DGOZPC2 DGOZPC3 DGOZPC4 DGOZPMS DGOZRSDS DGOZSCRD DGOZSQPA DGOZSUB1 DGOZSUB2 DGOZTBL DGOZWSTE FPEMDSUB
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R410 PSY UK31931
UP07/12/11 P F712
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