Configuring DB2 for z/OS subsystems for tuning queries with IBM Data Studio (stand-alone package)
Before you use IBM Data Studio (stand-alone package) to tune single queries that run on a DB2 for z/OS subsystem, you must perform these steps on that subsystem:
- Install PTF PK58941(DSN5OFM). You can download the PTF from here: http://www-01.ibm.com/support/docview.wss?uid=swg1PK58941.
- Upload the DBRMs that are included in the dbrm_dsrcp.zip file to the z/OS subsystem. The dbrm_dsrcp.zip file is available on the download site for IBM Data Studio 220.127.116.11 (stand-alone package):https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-idssa&S_TACT=105AGX01&S_CMP=LP
- Modify DSNTESC and DSNTIJOS for your DB2 for z/OS system and run them. Ensure that the JCL files are edited to include the path to where the DBRMs were uploaded to. These JCL files are in the DB2 sample library.
In addition to the tables and packages that are required for tuning single queries that run on DB2 for z/OS, these JCL files create similar objects for tuning query workloads. Tuning workloads is not supported in Data Studio (stand-alone package). Therefore, you do not have to grant privileges on any of the objects for tuning workloads.