This is about CA SYSVIEW for DB2 previously packaged in the name of CA Insight
I'm interested in generating an distributed thread activity report using CA Sysview for db2 batch report writer
In THstSel1 – Thread History Selection screen, I specify the date and plan then PF5 gets to R/HTLIST – Thread History List, displaying thread history, for db2 distributed threads the workstation name, product id, et al are shown
What I'm trying to do is find an Sysview for db2 Batch report that is similar to R/HTLIST – Thread History List
I've looked through Sysview for db2 batch report writer, the closest one appears to be BTSTATR3 – Distributed Activity by Remote Location Report, this is based on statistics trace data not accounting and hence not really usable
Accounting trace data provides the desired output displayed in R/HTLIST – Thread History List
With IBM Db2 performance monitor tool, such reports are inbuilt and out of the box customization is not required; same with third party vendor like BMC
Generally, batch reports to review system activity and distributed thread activity is an must have report in data analytics world
I'm not seeking any out of the box product enhancement
Original Message:
Sent: 05-05-2020 11:42 AM
From: Robert Brandl Jr.
Subject: Sysview batch report
If you are referring to the data contained in the SYSVIEW display:
DBTHACT, DB2 Active Threads
There is no out of the box report for this and it would need to be an enhancement request.
------------------------------
Robert Brandl
Software Support Engineer, Team SYSVIEW
Broadcom
Original Message:
Sent: 04-29-2020 07:12 AM
From: abc xyz
Subject: Sysview batch report
Is there an batch report writer option similar to R/HTLIST Thread History List i.e. online thread history panel in CA Sysview?
The HTLIST panel shows threads with location name and prod id
None of the sysview batch report has the ability to produce such report
Is Sysview not designed for handling such batch reports?