IBM Support

PM18749: WDICLIENT SLOW PERFORMANCE WHEN OPENING A TRANSACTION FROM THE LIST ON DOCUMENT STORE TRANSACTIONS TAB

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Environment:  WDI 3.3 Client with CFP10. WDI 3.3 for z/OS with
    current PTF's
    When customer opens the Document Store icon and then enters the
    parameters to query any specific types of transactions the query
    response quickly, but then customer selects a transaction from
    the list and it takes several minutes before the information for
    the transaction to appear. In this case, the customer has a base
    of 800k transactions in the store (rows in EDITSTH).
    Possible cause of this problem is how the view, EDIVTSTH, is
    defined on the EDITSTH table. There are no WHERE predicates or
    other tables in this view. It only selects certain columns from
    the EDITSTH table and it appears its main purpose is to convert
    the column THANDLE from a Timestamp datatype to a Character
    datatype. It uses the CHAR function which converts timestamp,
    numeric, and graphic data to character data.  When you select a
    piece of data and what you are comparing does not match data
    types or lengths, DB2 will not use any indexes that exist in the
    comparison.
    
    Keywords: transaction store performing performance degrade
    degraded
    

Local fix

Problem summary

  • When customer opens the Document Store icon and then enters the
    parameters to query any specific types of transactions the query
    response quickly, but then customer selects a transaction from
    the list and it takes several minutes before the information for
    the transaction to appear. In this case, the customer has a base
    of 800k transactions in the store (rows in EDITSTH).
    Possible cause of this problem is how the view, EDIVTSTH, is
    defined on the EDITSTH table. There are no WHERE predicates or
    other tables in this view. It only selects certain columns from
    the EDITSTH table and it appears its main purpose is to convert
    the column THANDLE from a Timestamp datatype to a Character
    datatype. It uses the CHAR function which converts timestamp,
    numeric, and graphic data to character data.  When you select a
    piece of data and what you are comparing does not match data
    types or lengths, DB2 will not use any indexes that exist in the
    comparison.
    

Problem conclusion

  • Remove the CHAR option on the THANDLE from the View
    

Temporary fix

  • Client was send a file with DDL to drop and restore VIEW.
    

Comments

  • Applies to all platforms, WDI 3.3, SFP5
    CMVC defect P8012148 will contain DDL for the MP product.
    

APAR Information

  • APAR number

    PM18749

  • Reported component name

    WEBS DI ZOS

  • Reported component ID

    5655I4003

  • Reported release

    330

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-07-19

  • Closed date

    2010-08-29

  • Last modified date

    2010-12-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK60104

Modules/Macros

  • DB2CTL   EDISDB2  EDISDDL3
    

Fix information

  • Fixed component name

    WEBS DI ZOS

  • Fixed component ID

    5655I4003

Applicable component levels

  • R330 PSY UK60104

       UP10/11/06 P F011

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":"BU048","label":"IBM Software"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.3","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.3","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
22 August 2022