PK51808: SIGNIFICANTLY REDUCE CHANCE OF TIMEOUT CONDITIONS DURING PERFORMANCE WAREHOUSE STARTUP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During PE Server startup locking conflicts might result from
  concurrent access to resources from the PE Server tasks and
  Performance Warehouse (PWH) resulting in timeout / deadlock
  conditions. In this case the PWH startup would fail with SQL
  -911 and cause table spaces to enter check pending state. The PE
  Server code is modified to significantly reduce the likelyhood
  of concurrent access to resources.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   PE Server                                *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the OMEGAMON Server subtask        *
  *                      PESERVER is started with Performance    *
  *                      Warehouse (PWH) activated, the startup  *
  *                      of PWH might fail because of            *
  *                      unavailable resources and terminate     *
  *                      with SQL code -911.                     *
  *                      --------------------------------------- *
  *                                                              *
  *                      for V310:                               *
  *                      The service level of the                *
  *                      OMEGAMON Server subtask PESERVER is:    *
  *                      FPEV0000I  DATA SERVER INITIALIZATION   *
  *                      FPEV0114I  PTF BUILD IS 07.337          *
  *                                                              *
  *                      for V410:                               *
  *                      The service level of the                *
  *                      OMEGAMON Server subtask PESERVER is:    *
  *                      FPEV0000I  DATA SERVER INITIALIZATION   *
  *                      FPEV0114I  PTF BUILD IS 07.337          *
  ****************************************************************
  * RECOMMENDATION: Install this PTF to reduce the likelyhood    *
  *                 for PWH to fail because of timeout or        *
  *                 deadlock conditions.                         *
  ****************************************************************
  PROBLEM SUMMARY:
  During PE Server startup locking conflicts could result from
  concurrent access from the PE Server tasks and Performance
  Warehouse (PWH) resulting in timeout/deadlock conditions.
  In this case the PWH startup will fail with SQL -911 and table
  spaces will enter check pending state. Consecutive start ups of
  PWH while a table space is in check pending state will fail with
  SQL -904. The PE Server / PWH will not be able to recover from
  this state automatically. The check pending state must be
  cleared manually before PWH is restarted.
  
  PROBLEM CONCLUSION:
  The PE Server code has been modified to reduce the chance to get
  timeout/deadlock conditions while resources are accessed during
  Performance Warehouse startup.
  

Problem conclusion

• The PE Server code has been modified to reduce the chance to get
  timeout/deadlock conditions while resources are accessed during
  Performance Warehouse startup.
  
  KEYWORDS :
  PERFORMANCE WAREHOUSE PWH SQL -911 -904 RESOURCE UNAVAILABLE
  

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:

  UK31872 UK31873

Modules/Macros

•    DGO@TBL  DGO@WRPA DGO@WRP2 DGOVMSTR DGOVWRPA
  DGOVWRP2 DGOZTBL
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK31872

     UP07/12/05 P F712

• R410 PSY UK31873

     UP07/12/05 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.