We have recently setup the CA SYSVIEW® Performance Management Option for DB2 in our shop as a replacement for a similar tool. We however, were not able to get hold of the JCL to setup these reports (in our case the BTLKCONT report). Could you please direct us to the appropriate documentation page or provide a sample JCL that we could customize for our shop.
Datavail Infotech Pvt. Ltd.
If you review your Sysview for DB2 Datasets and fine the Source dataset.
In there is a sample batch job named IDB2RWJ.
Just update it with Datasets names and update the DBGIN DD to just reference the reports you want to run.
Make sure you add DD for the report Sysout and you should be fine.
Any further queries just let me know
Thanks a ton!
I have located the IDB2RWJ job and will customize according to the requirement and get back to you in case of any issues.
I tried setting up the job in our shop, however, I did not find any options to specify the time interval and the Db2 subsystem ID in the job.
Could you please suggest whether I could use any document for identifying these options or any sample JCL I could refer to.
Sure here is a link to the Sysview for DB2 R19 documentation on our Docops site.
Use your CA Support Online user id and password to log in
if you search on batch you will find all the info you need
This example shows a Date and Time filter for the report you can also add a DB2 SSID filter if you only want information on a selected DB2 Subsystem. keith
Here is a DocOps section describing how to use and customize batch processor: https://docops.ca.com/ca-sysview-db2/20/en/configuring/batch-report-writer. One of the sections includes filtering examples: https://docops.ca.com/ca-sysview-db2/20/en/configuring/batch-report-writer/batch-report-filtering-examples
I would recommend using the GLOBALS WHERE example as by this you don't need to change the BTLKCONT report. More details on its syntax can be found here: https://docops.ca.com/ca-sysview-db2/20/en/reference/iql-reference/iql-syntax/globals-statement
The beauty is that you can use any common IFCID field for filtering (https://docops.ca.com/ca-sysview-db2/20/en/reference/ifcid-records/common-fields), for example here is filter for Db2 subsytem DDDD and trace records produced on March 16, 2018:
GLOBALS WHERE SUBSYS='DDDD' AND EVENT-TIME >= '180316000000' AND
Hope this helps.