Installation roadmap
This topic provides a comprehensive list of the installation and configuration tasks that are presented in the prescribed sequence and identifies the various roles that are associated with each task.
Installing and configuring SQL Tuning Services requires z/OS® system programmer and UNIX System Service (USS) administrator skills. The skills of a database administrator, security administrator, network administrator, or UNIX shell programmer might also be needed to complete specific installation or configuration tasks.
Use the following list of tasks as a roadmap to install and configure SQL Tuning Services:
| Task | Steps | Role |
|---|---|---|
| Prepare your system for installation. | Make sure that your system meets the minimum hardware and software requirements for installing SQL Tuning Services. Also, familiarize yourself with the installation directories and data sets, the user IDs, and the sample JCL that you will use in the installation process. |
z/OS System programmer |
| Set up the SQL Tuning Services repository database. | Step 1: Create a functional Db2 for z/OS ID for creating the repository database. This ID is referred to as the sqlts_repodb_id. |
Security administrator |
Step 2: Grant privileges for creating the repository database to the sqlts_repodb_id. |
Database administrator | |
| Step 3: Create the repository database. | Database administrator | |
| Step 4: Bind required packages on the Db2 for z/OS subsystem where you created the repository database and on the tuning target subsystem. | Database administrator | |
Step 5: Grant package privileges to the sqlts_repodb_id. |
Database administrator | |
Create user-defined functions (UDFs) and grant privileges to the dba_id and one or more user_ids. |
Step 1: Create two UDFs that are required to use and administer SQL Tuning Services and grant EXECUTE privileges to the SQL Tuning Services administrator ID (dba_id) and at least one SQL Tuning Services user id (user_id). |
System programmer |
Step 2: Grant package privileges to the dba_id and at least one user_id. |
Security administrator | |
| Set up the started task ID and create a key ring for it. | Step 1: Create the SQL Tuning Services started task ID. | Security administrator |
| Step 2: Create a key ring for network communications | Network administrator | |
| Enable PassTicket support. | If you use RACF PassTickets in your environment, enable PassTicket support for SQL Tuning Services. | Security administrator |
| Install the SQL Tuning Services server. | Step 1: Identify the SQL Tuning Services installation ID (sqlts_install_id). |
System programmer |
| Step 2: Assign a netwok port for the SQL Tuning Services server. | System programmer | |
| Step 3: Customize the SQL Tuning Services configuration file (tmsservice.config). | System programmer | |
| Step 4: Run the installation script (tmsservice.sh) | System programmer | |
| Step 5: Start the SQL Tuning Services server. | System programmer | |
| If necessary, complete environment-specific installation tasks. | If you use AT-TLS in your environment, complete the steps in Configuring AT-TLS for SQL Tuning Services. | Network administrator |
| To use the extended set of tuning features that are available with Db2 Query Workload Tuner for z/OS 6.1, enable the Db2 Query Workload Tuner license. | System programmer | |
| Set up an SQL Tuning Services environment. | Create EXPLAIN tables tables on the tuning target database and create a tuning profile. When these steps are complete, you can verify your environment by invoking an SQL Tuning Services API from the Swagger interface. | System programmer |