Executor: HiRDB administrator

You can only use the database condition analysis utility to collect tuning information when the status of the different RDAREAs is as shown in the table below. 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 the RDAREAs are in the appropriate status for execution of the database condition analysis utility.

Table 22-7 RDAREA status for collection of tuning information by the database condition analysis utility

Type of RDAREA		Status 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

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). The following figure shows the procedure for collecting tuning information (collecting tuning information using the database condition analysis utility).

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

#: 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.