PK61399: PWH, PERFORMANCE WAREHOUSE PRODUCES TABLESPACE MTRVIEW IN DBASE DSNDB04 IN ERROR. TABLE MT_VIEW SHOULD BE IN DB2PM.CONTROL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• With the latest set of maintenance applied to the PWH function,
  this included many updates to the tables within the DB2PM
  database that is created for the PWH.  There was a new
  tablespace created that was attempting to use the default
  database(DSNDB04).  MTRVIEW.
  The table name created was DB2PM.MT_VIEW.  Index name created
  was DB2PM.IX_VIEW.  This was created in error the tablespace is
  not correctly specifying the DB2PM database to create the
  tablespace in.  It should have been created in DB2PM.CONTROL
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - PE Server                                  *
  *                 - Performance Warehouse user                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Table MT_VIEW of Performance Warehouse  *
  *                      is created in wrong tablespace          *
  *                      DSN*.MTRVIEW                            *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  Table MT_VIEW of Performance Warehouse is
  created in wrong tablespace DSN*.MTRVIEW
  
  PROBLEM CONCLUSION:
  Create table MT_VIEW in tablespace DB2PM.CONTROL
  
  KEYWORDS: PWH MT_VIEW
  

Problem conclusion

• Create table MT_VIEW in tablespace DB2PM.CONTROL
  
  KEYWORDS: PWH MT_VIEW
  

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:

  UK34626

Modules/Macros

•    DGO@BTCH DGO@CHKB DGO@CONV DGO@CRDP DGO@DTA1
  DGO@DTA2 DGO@DTA3 DGO@DTA4 DGO@DTA5 DGO@DTA6 DGO@DTA7 DGO@EXCP
  DGO@LOAD DGO@MT1  DGO@MT1I DGO@MT2  DGO@MT2I DGO@MT2J DGO@MT2K
  DGO@MT3  DGO@MT3I DGO@MT4  DGO@MT4I DGO@MT5  DGO@MT5I DGO@MT5J
  DGO@PC1  DGO@PC2  DGO@PC3  DGO@PC4  DGO@PRV1 DGO@PRV2 DGO@SAPI
  DGO@SCRD DGO@SDOB DGO@SP   DGO@SQPA DGO@TBL  DGO@TRG  DGO@VW1
  DGO@VW2  DGO@WRPA DGO@WRP2 DGO@WR2C DGO@WSTE DGOVEXCP DGOVSDOB
  DGOVWRPA DGOVWRP2 DGOVWR2C DGOZBTCH DGOZCHKB DGOZCONV DGOZCRDP
  DGOZDTA1 DGOZDTA2 DGOZDTA3 DGOZDTA4 DGOZDTA5 DGOZDTA6 DGOZDTA7
  DGOZLOAD DGOZMT1  DGOZMT1I DGOZMT2  DGOZMT2I DGOZMT2J DGOZMT2K
  DGOZMT3  DGOZMT3I DGOZMT4  DGOZMT4I DGOZMT5  DGOZMT5I DGOZMT5J
  DGOZPC1  DGOZPC2  DGOZPC3  DGOZPC4  DGOZPRV1 DGOZPRV2 DGOZSAPI
  DGOZSCRD DGOZSP   DGOZSQPA DGOZTBL  DGOZTRG  DGOZVW1  DGOZVW2
  DGOZWSTE
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK34626

     UP08/03/18 P F803 Ž

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.