Administrative tasks - DB2®

A set of scripts and SQL files is provided to perform actions such as granting rights or reorganizing the database. These files are located in inst_dir/dbtools/db2/script. To use these files, copy the relevant folder to the database server. The DB2® tools must be run by a user who has the following permissions:

• DB2 administrator permissions – the user must be defined to DB2 as a DB2 Administrator
• Full access (777) to the IBM® Workload Scheduler installation directory

The available files are as follows:

dbrunstats

This script runs the DB2 statistics program, to maximize the performance of DB2.

dbreorg

This script reorganizes the database. See Reorganizing the DB2 database for a full description of how to use the tool.

dbgrant

This script adds grants to new users on IBM® Workload Scheduler DB schema for the views that can be used to generate reports

To find out how to perform specific administrative tasks on DB2®, see:

• Changing DB2 passwords
• Locating the DB2 tools
• User permissions for running the DB2 tools
• Running DB2 maintenance manually
• Reorganizing the DB2 database
• Monitoring the lock list memory