15.3.2 Collecting cost information for all tables

This example collects cost information for all tables in schema ADBUSER01. The absolute path name of the cost-information collection-options file is /home/adbmanager/getcst_file/env01.txt.

To collect cost information:

Create a cost-information collection-options file.
Execute the adbgetcst command.

Using an example, the following subsections explain each of these steps.

Organization of this subsection

(1) Creating a cost-information collection-options file
(2) Executing the adbgetcst command

(1) Creating a cost-information collection-options file

This example creates a cost-information collection-options file and specifies the number of processing real threads to be used for executing the adbgetcst command.

Specification example of cost-information collection-options file

set adb_getcst_rthd_num = 10

To Page Top

(2) Executing the adbgetcst command

adbgetcst -u ADBUSER01                                ...1
          -p '#HelloHADB_01'                          ...2
          -z /home/adbmanager/getcst_file/env01.txt   ...3

Explanation:

Specifies the authorization identifier of the HADB user who executes the adbgetcst command.
Specifies the password for the authorization identifier that was specified in the -u option.
Specifies the absolute path name of the cost-information collection-options file created in (1) Creating a cost-information collection-options file.

To Page Top