20.3 Using the database condition analysis utility to collect tuning information

This section explains the procedures for using the database condition analysis utility to collect tuning information.

Organization of this section
(1) Preparing for collecting the tuning information
(2) Collecting the tuning information

(1) Preparing for collecting the tuning information

Executor: HiRDB administrator

To use the database condition analysis utility to collect tuning information, the status of RDAREAs must be as shown in Table 20-6. For this reason, the status of RDAREAs should be checked with the pddbls command before the database condition analysis utility is executed.

A user with the DBA privilege only cannot check the status of RDAREAs. In such a case, the HiRDB administrator must be asked whether or not the RDAREAs are in the appropriate status for execution of the database condition analysis utility.

Table 20-6 RDAREA status for collection of tuning information by the database condition analysis utility

Type of RDAREAStatus of RDAREA
  • Data dictionary RDAREA
  • Data dictionary LOB RDAREA
  • Registry RDAREA
  • Registry LOB RDAREA
  • List RDAREA
  • Non-shutdown open status
  • Reference-enabled shutdown open status
  • User RDAREA
  • User LOB RDAREA
RDAREA open attribute: INITIAL
  • Non-shutdown open status
  • Reference-enabled shutdown open status
RDAREA open attribute: DEFER or SCHEDULE
  • Non-shutdown open status
  • Non-shutdown close status
  • Reference-enabled shutdown open status
  • Reference-enabled shutdown close status

(2) Collecting the tuning information

Executor: User with the DBA privilege

This section explains the procedure for collection of tuning information (from entry of operation command to execution of the database condition analysis utility). Figure 20-5 shows the procedure for collecting tuning information (collecting tuning information using the database condition analysis utility).

Figure 20-5 Procedure for collecting tuning information (collecting tuning information using the database condition analysis utility)

[Figure]

* If the RDAREA open attribute is DEFER or SCHEDULE, and the RDAREA is not in reference-possible hold status or shutdown, then it is not necessary to place it in open status.

Explanation
  1. Use the pddbls command to check the status of the RDAREA.
  2. In the case of an error shutdown, use the pdrels command after error recovery to release the shutdown status, then reexecute.
  3. In the case of a command shutdown, use the pdrels command to release the RDAREA from shutdown status.
  4. If in closed status, use the pdopen command to place in open status.
  5. Execute the database condition analysis utility. Perform tuning on the basis of the results of this execution.
  6. If the RDAREA was placed in open status in step 4, use the pdclose command to return to closed status. If command shutdown was used in step 3, use the pdrels command to release the command shutdown.