9.7 Collecting cost information
After you have imported data into the base table, execute the adbgetcst command to collect the cost information of the base table.
- Example:
-
This example collects the cost information of the shop table (SHOPSLIST).
Procedure:
-
Log on to the OS from the HADB administrator's OS account.
Log on to the OS from the HADB administrator's OS account so that the HADB administrator can execute the adbgetcst command.
This step is not necessary if the HADB administrator is already logged on.
-
Create a cost-information collection-options file.
set adb_getcst_rthd_num = 10
Create a cost-information collection-options file that specifies a value for the cost-information collection option. The cost-information collection-options file created here becomes the input information for the adbgetcst command.
In this example, the created cost-information collection-options file is saved in /home/adbmanager/cost_file/cost_opt_file.txt.
For details about the cost information collection option, see Format of the cost-information collection option in Specification format for the adbgetcst command under adbgetcst (Collect Cost Information) in the manual HADB Command Reference.
-
Execute the adbgetcst command to collect cost information.
adbgetcst -u ADBUSER02 -p '#HelloHADB_02' -t SHOPSLIST -z /home/adbmanager/cost_file/cost_opt_file.txt- -u
-
Specifies the authorization identifier of the HADB user who executes the adbgetcst command. Specify the authorization identifier of the HADB user who owns the base table from which cost information is to be collected.
- -p
-
Specifies the password of the HADB user who executes the adbgetcst command.
- -t
-
Specifies the name of the base table from which the cost information is to be collected.
- -z
-
Specifies the absolute path name of the cost-information collection-options file created in step 2.
- Note
-
For details about the timing with which cost information is collected, see 11.5 Collecting cost information.