Idea Details

Add total UNACC-DB2-TIME to R/HSTLSTAC

Last activity 10 days ago
DimitriVillegas's profile image
05-27-2020 09:35 AM

R/HSTLSTAC "Accounting by Connection History List" includes many wait buckets, but it is massing a column for Not Accounted time (IQL var UNACC-DB2-TIME) 

It includes a Wt Others which initially was though to be UNACC-DB2-TIME, but found that it means the following:

This field shows wait time statistics for class 3 not included in previous fields.

The field includes wait times such as wait time caused by suspension for

sending messages to data sharing group members, wait time for TCP/IP LOB and

XML materialization, wait time for asynchronous IXLCACHE/IXLFCOMP invocations,

wait time for force-at-commit, wait time for autonomous transactions to

complete, and others.



The value is aggregated for one or all connection types.



It includes the fields listed below.



IQL Name: DECL-WAIT-OTHERS

DB2 Name: N/A


The UNACC-DB2-TIME data is displayed on R/HSTCSAD, but it is missing from R/HSTLSTAC 

Screen prints attached


Comments

10 days ago

Hello, 


This request is completed and delivered. 

Reports HSTLSTAA and  HSTLSTAC are updated with  UNACC-DB2-TIME. 

PTF number is SO13515.

Regards 

06-01-2020 09:45 AM

Posted under the wrong Communities Project.