Monitoring and changing online utilities

You can monitor the status of online utilities, change parameter values of some utilities, and terminate a utility job prior to completion.

About this task

If a utility is not running, you need to determine whether the type of utility access is allowed on an object of a specific status. The following table shows the compatibility of utility types and object status.

Table 1. Compatibility of utility types and object status
Utility type Object access
Read-only RO
All RW (default access type for an object)
Db2 UT

Procedure

Begin general-use programming interface information.To monitor and change an online utility:

  1. Issue the appropriate command for the action that you want to take.
    ALTER UTILITY
    Alters parameter values of an active REORG or REBUILD utility.
    DISPLAY UTILITY
    Displays the status of utility jobs.
    TERM UTILITY
    Terminates a utility job before its normal completion.
  2. To change the status of an object, use the START DATABASE command with the ACCESS option to start the object with a new status.
    For example:
    -START DATABASE (DSN8D61A) ACCESS(RO)

    End general-use programming interface information.