Code Place

Rexx to decode DB2 statistics (SMF100) 

Dec 31, 2015 06:37 AM

Steps to do :

- Submit IFASMFDMP to extract SMF100 (jcl not provided)

- Submit the provided JCL100 which will sort the SMF dataset and give it as input to the program REX100

Note :

Modify REX100 :

1- To change the input and output datasets according to your site

2-  Modify the SSID (DB2 subsystem name), the rexx process only one DB2 Subsys at a time

The program displays only some fields important for my needs, there are much more fields to display, but from the program provided i think that you can easily add the section needed.

Have fun !

Attachment(s)
txt file
JCL100.txt   2 KB   1 version
Uploaded - Jun 05, 2020
txt file
REX100.txt   44 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.