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.

Table 13‒16: Columns output as summary information for DB areas
No.	Column title	Information that is output	Enclosing character
1	`Type`	Type of information that is output: `DBarea`: Summary information for a DB area	N
2	`Timestamp`	Timestamp when the `adbdbstatus` command was executed The date and time the `adbdbstatus` was executed are output in the following format: `"YYYY-MM-DD`Δ`hh:mm:ss"`^#1	Y
3	`DBarea_name`	DB area name	Y
4	`DBarea_ID`	DB area ID	N
5	`DBarea_type`	Type of DB area: `data`: Data DB area `dictionary`: Dictionary DB area `system_table`: System-table DB area	N
6	`DBarea_created_time`	Timestamp when the DB area was created The date and time the DB area was created by the `adbinit` command or was added by the `adbmodarea` command are output in the following format: `"YYYY-MM-DD`Δ`hh:mm:ss"`^#1	Y
7	`DBarea_modified_time`	Timestamp when the DB area was expanded The date and time DB area files were added to the DB area by the `adbmodarea` command are output in the following format: `"YYYY-MM-DD`Δ`hh:mm:ss"`^#1 If no DB area file has been added, no value is output for this item.	Y
8	`Rsv`	--	--
9	`Page_size`	Page size (bytes)	N
10	`Segment_size`	Segment size (pages)	N
11	`Top_DBarea_filename`	File path of the first DB area file This is the file path of the first DB area file allocated in the DB area. For a regular file The absolute path of the DB area file is output. For a block special file The name of the block special file allocated to the DB area file is output. For a symbolic link, the target of the symbolic link is output.	Y
12	`Number_of_files`	Number of DB area files This is the number of DB area files that make up the DB area.	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	Segment usage rate of the DB area (%) This is the percentage of segments currently in use out of the total number of segments in the DB area. The formula is as follows:	N
17	`Used_segments`^{#2, #3}	Number of segments in use in the DB area^#4 The number of segments being used in the DB area^#4 is output.	N
18	`Total_segments`^{#2, #3}	Total number of segments in the DB area^#4 The total number of segments that can be managed, based on the size of the DB area file at the time the `adbdbstatus` command was executed^#4, is output.	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.

To Page Top