A fix is available
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