PH66845: CREATE NEW TABLES WASACT_REQAPPL_T & WASACT_ASYNCAPP_T AND UPDATE EXISTING SYNCHRONOUS AND ASYNCHRONOUS TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Create new tables WASACT_REQAPPL_T & WASACT_ASYNCAPP_T.
  
  2. Create new view WASACT_REQAPPL_TV.
  
  3. Add a new primary key column TRANSACTION_CLASS from field
     SM1209DS to synchronous tables and views WASACT_REQAPPL_* .
  
  4. Add a new primary column TRANSACTION_CLASS from field
     SM1209HC to asynchronous tables WASACT_ASYNCAPP_*.
  
  5. Change the column REQUEST_TYPE to default to "ASYNCH" for
     Asynchronous Requests tables WASACT_ASYNCAPP_*
     and WASACT_ASYNCONT_*.
  
  6. Change the units of measure in the comments of the
     views WASACT_REQAPPL_* and WASACT_REQCONT_*.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM Z Performance and Capacity  *
  *                 Analytics 3.1.0.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Timestamp tables WASACT_REQAPPL_T    *
  *                         and WASACT_ASYNCAPP_T do not exist.  *
  *                      2. The WASACT_REQAPPL_*                 *
  *                         and WASACT_ASYNCAPP_* tables do      *
  *                         not contain a column for             *
  *                         TRANSACTION_CLASS.                   *
  *                      3. The REQUEST_TYPE column in the       *
  *                         Asynchronous Request Activity        *
  *                         tables, WASACT_ASYNCAPP_* and        *
  *                         WASACT_ASYNCONT_*, show a value of   *
  *                         $UNKNOWN.                            *
  *                      4. The comments for WASACT_REQAPPL_*    *
  *                         and WASACT_REQCONT_* views display   *
  *                         incorrect units of measure.          *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF(s).                   *
  ****************************************************************
  1. Timestamp tables WASACT_REQAPPL_T and WASACT_ASYNCAPP_T do
     not exist.
  2. The WASACT_REQAPPL_* and WASACT_ASYNCAPP_* tables do not
     contain a column for TRANSACTION_CLASS.
  3. The REQUEST_TYPE column in the Asynchronous Request Activity
     tables, WASACT_ASYNCAPP_* and WASACT_ASYNCONT_*, show a
     value of $UNKNOWN.
  4. The comments for WASACT_REQAPPL_* and WASACT_REQCONT_* views
     display incorrect units of measure.
  

Problem conclusion

• 1. Created tables WASACT_REQAPPL_T and WASACT_ASYNCAPP_T and
     corresponding view WASACT_REQAPPL_TV.
  2. Added TRANSACTION_CLASS as a primary key column to the
     WASACT_REQAPPL_* and WASACT_ASYNCAPP_* tables and
     WASACT_REQAPPL_* views.
  3. Set REQUEST_TYPE in the Asynchronous tables WASACT_ASYNCAPP_*
     and WASACT_ASYNCONT_* to 'ASYNCH'.
  4. Comments for WASACT_REQAPPL_* and WASACT_REQCONT_* views
     modified to display correct units.
  

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:

  UO04758

Modules/Macros

• DRLIWAS  DRLSWASA DRLTWASA DRLTWASB DRLTWASC DRLTWASD
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• RCA0 PSY UO04758

     UP25/09/16 P F509

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.