PM32662: PWH RECEIVES SQLCODE -311 DURING INITIAL CREATION DUE TO ONE ROT(RULE-OF-THUMB) NOT BEING CREATED AT RUN TIME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During PWH initialization an SQLCODE -311 is received due to one
  integrated rule-of-thumb (ROT) that is not created at run time.
  .
  If customer had a previous version of PWH, existing run time
  environments must be upgraded via ICAT before they can be used
  in the new version.
  .
  PWH requires special manual migration steps outline in the
  Customization and Configuration guide.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   PE Server subtask                        *
  *                 -   Performance Database users               *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Occurence of SQLCODE -311 during        *
  *                      Performance Warehouse database          *
  *                      creation or migration process.          *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Occurrence of SQLCODE -311 on an insert into DB2PM.ROT_ROT
  table during Performance Warehouse database creation or
  migration process. Neither joblog nor SYPRINT datasets of
  OMEGAMON collector started task show this SQL error code.
  It can be detected in SQL Activity traces and reports or
  by means of use of alternative monitoring tools like DB2
  Query Monitor or Platinum Detector.
  
  PROBLEM CONCLUSION:
  Code of Performance Warehouse subtask has been
  correspondingly corrected to prevent the failures.
  

Problem conclusion

• Code of Performance Warehouse subtask has been
  correspondingly corrected to prevent the failures.
  KEYWORDS :
  SQLCODE -311
  

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:

Modules/Macros

•    DGO@DTA6 DGO@SP   DGOVMSTR DGOZDTA6 DGOZSP
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK66061

     UP11/03/25 P F103

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.