Configuring DB2 for z/OS Subsystems for Tuning Queries with IBM Data Studio (stand-alone package)

Product documentation


Abstract

Configuring DB2 for z/OS subsystems for tuning queries with IBM Data Studio (stand-alone package)

Content

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:

  1. Install PTF PK58941(DSN5OFM). You can download the PTF from here: http://www-01.ibm.com/support/docview.wss?uid=swg1PK58941.
  2. 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 2.2.0.2 (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
  3. 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.

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Data Studio

Software version:

2.2.0.2

Operating system(s):

Windows

Reference #:

7018433

Modified date:

2011-02-04

Translate my page

Machine Translation

Content navigation