13.3.2 List of items that are output as summary information for DB areas
The table below lists and describes the titles and contents of the items (columns) that are output as summary information for DB areas. The columns are output in the order listed in this table. For details about the output rules for summary information for DB areas, see 13.12 Output rules for the adbdbstatus command.
No. |
Column title |
Information that is output |
Enclosing character |
---|---|---|---|
1 |
Type |
|
N |
2 |
Timestamp |
|
Y |
3 |
DBarea_name |
DB area name |
Y |
4 |
DBarea_ID |
DB area ID |
N |
5 |
DBarea_type |
|
N |
6 |
DBarea_created_time |
|
Y |
7 |
DBarea_modified_time |
|
Y |
8 |
Rsv |
-- |
-- |
9 |
Page_size |
Page size (bytes) |
N |
10 |
Segment_size |
Segment size (pages) |
N |
11 |
Top_DBarea_filename |
|
Y |
12 |
Number_of_files |
|
N |
13 |
Creatable_chunks |
Number of chunks that can be created in the DB area |
N |
14 |
Created_chunks |
Number of chunks that have been created in the DB area |
N |
15 |
Rsv |
-- |
-- |
16 |
Used_ratio#2 |
|
N |
17 |
Used_segments#2, #3 |
|
N |
18 |
Total_segments#2, #3 |
|
N |
19 |
Rsv |
-- |
-- |
- Legend:
-
--: No value is output.
Y: The output value is enclosed in a pair of enclosing characters.
N: The output value is not enclosed in the enclosing character.
- #1
-
The year (YYYY) is output as four digits. The month (MM), day (DD), hour (hh), minute (mm), and second (ss) are each output as two digits. If there are not enough digits, leading zeros are added. Δ indicates a single-byte space.
- #2
-
If a transaction that updates the DB area that is being analyzed is executed concurrently with execution of the adbdbstatus command, the displayed value might differ from the actual value.
- #3
-
When the display units for usage amounts are changed by specifying the -S option, the column titles for the usage amount output items are also changed to match the selected display units. For details about the display units and column titles, see Table 13‒2: Display units and column titles for usage amount output items in (3) Explanation of options in 13.2.1 Explanation of the specification format and options (outputting summary information or usage information).
- #4
-
The -S option enables you to change the display units for usage amount output items to kilobytes, megabytes, or gigabytes.