This section explains the procedures for using the database condition analysis utility to collect tuning information.
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 RDAREA | Status of RDAREA | |
---|---|---|
|
| |
| RDAREA open attribute: INITIAL |
|
RDAREA open attribute: DEFER or SCHEDULE |
|
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)
* 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.