(a) Optimizing information collection level lvl2
The following shows the execution results of the optimizing information collection utility (optimizing information collection by retrieval with -c lvl2):
** pdgetcst 1995-03-31 12:00
[1]
** TABLE INFORMATION **
AUTHORIZATION : user-id [2]
TABLE NAME : TABLE01 [3]
ROW COUNT : 120 [4]
DATA PAGES : 5 [5]
CACHE SIZE : 0 [6]
** INDEX-COLUMN INFORMATION **
INDEX NAME : Idx001 [7]
INDEX PAGES : 5 [8]
INDEX LEVELS : 3 [9]
COLUMN NAME : Clm1 [10]
COLUMN TYPE : INTEGER [11]
SEQUENTIAL RATIO : 100 [12]
MAX VALUE : 2500 [13]
MIN VALUE : 0 [14]
UNIQUE KEYS : 23 [15]
NULL VALUE COUNT : 20 [16]
MAX DUPLICATE KEY : 10 [17]
MIN DUPLICATE KEY : 1 [18]
SECTION COUNT : 39 [19]
** SECTION INFORMATION **
SECTION NO :1 [20]
TOTAL COUNT :1 [21]
UNIQUE KEYS :1 [22]
MAX VALUE :0 [23]
** SECTION INFORMATION **
SECTION NO :2
TOTAL COUNT :2
UNIQUE KEYS :1
MAX VALUE :10
** SECTION INFORMATION **
SECTION NO :3
TOTAL COUNT :6
UNIQUE KEYS :1
MAX VALUE :10
:
** SECTION INFORMATION **
SECTION NO :39
TOTAL COUNT :100
UNIQUE KEYS :1
MAX VALUE :2500
** pdgetcst ENDED RETURN CODE = 0 [24] |
- Explanation
- ** SECTION INFORMATION ** is displayed as many times as there are sections. ** INDEX-COLUMN INFORMATION ** (including ** SECTION INFORMATION **) is displayed as many times as there are indexes.
- Date and time the optimizing information collection utility was executed (pdgetcst command entry time) in the format YYYY/MM/DD hh:mm.
YYYY: Year. MM: Month. DD: Date. hh: Hour. mm: Minute.
- Authorization identifier of the table subject to collection of optimization information.
- Identifier of the table subject to collection of optimization information.
- Number of rows in the table.
- Number of data pages used in the table.
- Work area used by HiRDB.
- Name of an index subject to collection of optimization information.
- Number of index pages used for the index.
- Number of index levels.
- Name of the first component column of the index.
- Data type of the first component column of the index.
- Sequentialness.
- Maximum column value in the first component column of the index.
- Minimum column value in the first component column of the index.
- Number of unique values in the first component column of the index.
- Number of NULL values in the first component column of the index.
- Maximum number of duplicate values in the first component column of the index.
- Minimum number of duplicate values in the first component column of the index.
- Number of sections for section distribution information.
- Section number.
- Cumulative number of data items for the section.
- Number of unique values in the section.
- Maximum value in the section.
- Return code.
- Note
- When the -d option is specified, 8, 9, and 12-19 are not displayed. If the number of rows is zero, 13 and 14 are left blank, and 0 is displayed for the other items.
(b) Optimizing information collection level lvl1
The following shows the execution results of the optimizing information collection utility (optimizing information collection by retrieval with -c lvl1):
** pdgetcst 2000-03-31 12:00
[1]
** TABLE INFORMATION **
AUTHORIZATION : user-id [2]
TABLE NAME : TABLE01 [3]
ROW COUNT : 120 [4] [6]
CACHE SIZE : 0 [5]
** pdgetcst ENDED RETURN CODE = 0 [7] |
- Explanation
- Date and time the optimizing information collection utility was executed (pdgetcst command entry time) in the format YYYY/MM/DD hh:mm.
YYYY: Year. MM: Month. DD: Date. hh: Hour. mm: Minute.
- Authorization identifier of the table for which optimization information is being collected.
- Identifier of the table for which optimization information is being collected.
- Number of rows in the table.
- Work area used by the HiRDB.
- Information about other tables (applicable when -t ALL is specified).
- Return code.