Resources

Rexx to decode DB2 statistics (SMF100)

Topic: Code Place

Subtopic: DB2 for z/OS



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 !



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.