13.2.2 Explanation of the specification format and options (outputting information about the need for reorganization of column store tables)

Organization of this subsection

(1) Specification format
(2) Explanation of options
(3) Errors that can be caused by the -c option

(1) Specification format

The following indicates the specification format of the adbdbstatus command for outputting information about the need for reorganization of column store tables.

For details about the specification format to output summary information or usage information, see (1) Specification format in 13.2.1 Explanation of the specification format and options (outputting summary information or usage information).

adbdbstatus
    -d reorginfo
    -n table-name
  [-c chunk-ID-list-to-be-analyzed]
  [-t]
  [-k enclosing-character]
  [-s {delimiter|tab}]
  [-S {K|M|G}]

To Page Top

(2) Explanation of options

The following describes the options of the adbdbstatus command used to output information about the need for reorganization of column store tables. For details about the options used to output summary information or usage information, see (3) Explanation of options in 13.2.1 Explanation of the specification format and options (outputting summary information or usage information).

• -d reorginfo

This option must be specified.

Specify reorginfo as the type of output results to output information about the need for reorganization.

• -n table-name

~<character string>

This option must be specified.

Specifies the table name of a column store table for which information is to be collected, in the format schema-name.table-identifier. The schema name cannot be omitted. Specifying a viewed table or row store table results in an error.

For details about the specification rules that apply when a schema name or table identifier includes any lowercase letter or backslash (\), see 1.4.3 Table name specification rules.

• -c chunk-ID-list-to-be-analyzed

~<character string>((1 to 32,768 bytes))

Specify this option if you want to collect information about specific chunks in the target table specified by the -n option.

If this option is omitted, information about all chunks in the target table except for deletion-pending chunks is collected.

You can specify chunk-ID-list-to-be-analyzed by using the following methods. Note that you can combine multiple methods of specifying chunk IDs.

Figure 13‒4: Example of a chunk ID list to be analyzed

Specifying individual chunk IDs (individual specification)

If you want to specify individual chunk IDs for which information is to be collected, delimit the chunk IDs by using commas (,).

Important

There must be no spaces before or after a comma (,).
Specifying a range of chunk IDs (range specification)

If you specify a range of chunk IDs for which information is to be collected, use the format smallest-chunk-ID-in-the-range-largest-chunk-ID-in-the-range (connect the two chunk IDs with a hyphen (-)).

Important

There must be no spaces before or after the hyphen (-). The chunk ID specified to the right of the hyphen must be greater than the chunk ID specified to the left of the hyphen.

Among the chunks whose IDs are specified, information for the following chunks will not be collected:

Chunks that are not in the table to be processed
Deletion-pending chunks

The rules for specifying this option are as follows:

You can specify maximum of 30,000 chunk IDs. The following explains how chunk IDs are counted:

• For a range specification, all chunk IDs in the specified range are counted.

• If any duplicate chunk IDs are specified, the duplicate chunk IDs are counted.

Examples of chunk ID lists to be analyzed, and how to count chunk IDs

Example 1: -c 1,3,5: It is assumed that three chunk IDs (1, 3, and 5) are specified .

Example 2: -c 1,3,5-8,10: It is assumed that seven chunk IDs (1, 3, 5, 6, 7, 8, and 10) are specified.

Example 3: -c 1,3,5,5-8,10: It is assumed that eight chunk IDs (1, 3, 5, 5, 6, 7, 8, and 10) are specified.
The maximum permitted length of the entire value specified in the -c option is 32 kilobytes. If the specified length exceeds 32 kilobytes, use range specifications instead of individual specifications, or execute the adbdbstatus command more than once.
For details about specifications that result in an error and specification examples, see (3) Errors that can be caused by the -c option.

▪ Searching for chunk IDs of chunks that are in a table to be processed

Search system tables for STATUS_CHUNKS, and check the chunk IDs.

For details, see Checking the information about all chunks in a table based on a table name in Searching system tables in System Tables in the HADB Setup and Operation Guide.

• -t

Specifies that title lines (column headers) are not to be output.

• -k enclosing-character

~<character string>((1 byte))<<">>

Specifies an enclosing character to be used for the character strings in CSV format. If this option is omitted, the double quotation mark (") is assumed to be the enclosing character.

The enclosing character must be a single-byte character. A character string of 2 or more bytes cannot be specified. None of the following characters are permitted to be the enclosing character:

Space, tab, asterisk (*)
The character that is used as the delimiter (the value of or default value for the -s option)

Important

If you specify a single quotation mark (') as the enclosing character, enclose each in double quotation marks (").

Example: If you specify a single quotation mark (') as the enclosing character:

adbdbstatus ... -k "'" ...
If you specify as the enclosing character a special character used by the shell, such as the vertical bar (|), enclose each in either double quotation marks (") or single quotation marks (').

Example: If you specify the vertical bar (|) as the enclosing character:

adbdbstatus ... -k "|" ...
For the enclosing character, do not use one that is already in any column titles or contents output in information about the need for reorganization. For details about the columns that are output in the information about the need for reorganization, see 13.9.2 List of items that are output as information about the need for reorganization.

• -s {delimiter|tab}

~<character string>((1 byte))<<,>>

Specifies the delimiter used in CSV format. To specify the tab character as the delimiter, specify tab. If this option is omitted, the comma (,) is assumed to be the delimiter.

Only the tab character or a single-byte character can be specified as a delimiter. Except for the tab character, a character string consisting of two or more bytes cannot be specified. None of the following characters can be specified as the delimiter:

Uppercase letters (A to Z), lowercase letters (a to z), numeric characters (0 to 9), underscore (_), double quotation mark ("), or asterisk (*)
The character that is used as the enclosing character (the value of or default value for the -k option)

Important

If you specify a single quotation mark (') as the delimiter, enclose it in double quotation marks (").

Example: If you specify a single quotation mark (') as the delimiter:

adbdbstatus ... -s "'" ...
If you specify as the delimiter a special character used by the shell, such as the vertical bar (|), enclose it in either double quotation marks (") or single quotation marks (').

Example: If you specify the vertical bar (|) as the delimiter:

adbdbstatus ... -s "|" ...
For the delimiter, do not use one that is already in any column titles or contents output in information about the need for reorganization. For details about the columns that are output in the information about the need for reorganization, see 13.9.2 List of items that are output as information about the need for reorganization.

• -S {K|M|G}

Specifies that output items for necessity of reorganization are to be displayed in kilobytes, megabytes, or gigabytes, rather than in pages.

When this option is omitted, output items are displayed in pages.

K: Kilobytes: Specifies that the output items are to be displayed in kilobytes.
M: Megabytes: Specifies that the output items are to be displayed in megabytes.
G: Gigabytes: Specifies that the output items are to be displayed in gigabytes.

When this option is specified, the column titles for the corresponding output items are also changed to match the units specified for the display information. The following table shows the relationships among the value of this option, the display units for output items, and the column titles.

Table 13‒14: Display units and column titles for the output items for the necessity of reorganization
No.	Output item	Value of this option	Display units for output items	Column title
1	Number of basic row pages contained in the row-data segment	--	Pages	`Base_row_pages`
2		`K`	Kilobytes	`KB_Base_row_pages`
3		`M`	Megabytes	`MB_Base_row_pages`
4		`G`	Gigabytes	`GB_Base_row_pages`
5	Number of branch row pages contained in the row-data segment	--	Pages	`Branch_row_pages`
6		`K`	Kilobytes	`KB_Branch_row_pages`
7		`M`	Megabytes	`MB_Branch_row_pages`
8		`G`	Gigabytes	`GB_Branch_row_pages`
9	Number of invalid row information pages contained in the row-data segment	--	Pages	`Invalid_row_information_pages`
10		`K`	Kilobytes	`KB_Invalid_row_information_pages`
11		`M`	Megabytes	`MB_Invalid_row_information_pages`
12		`G`	Gigabytes	`GB_Invalid_row_information_pages`

Legend:: --: This option is omitted.

To Page Top

(3) Errors that can be caused by the -c option

The following table shows cases where the adbdbstatus command fails due to the specification of the -c option.

In any of these error cases, correct the specification of the -c option, and then re-execute the adbdbstatus command. For details about the -c option, see -c in (2) Explanation of options.

Table 13‒15: Message ID displayed when the specification of the -c option is invalid, and possible errors
No.	Message ID that is displayed	Possible error	Example of invalid specification	Example of corrected specification
1	`KFAA50205-E`	The number of specified chunk IDs exceeds 30,000.	`-c 1-30001`	`-c 1-30000`
2		The same chunk ID is specified on both sides of a hyphen (`-`) in the range specification.	`-c 3-3,7`	`-c 3-5,7`
3		In the range specification, the chunk ID specified to the right of the hyphen (`-`) is smaller than the chunk ID specified to the left of the hyphen.	`-c 10-3`	`-c 3-10`
4		Any one of the following invalid values is specified for the chunk ID: Values other than integers Values outside the range from 1 to 9,223,372,036,854,775,807	`-c A` `-c 0` `-c A-B` `-c 0-3`	Specify a correct chunk ID.
5	`KFAA90002-E` `KFAA96720-I`	There is a space between a chunk ID and a comma.	`-c 1,3,`∆`10`	`-c 1,3,10`
6	`KFAA90002-E` `KFAA96720-I`	There is a space between a chunk ID and the hyphen (`-`) in the range specification.	`-c 1,3`∆`-`∆`10`	`-c 1,3-10`
7	`KFAA90003-E`	The length of the specified value exceeds 32 kilobytes.		If individual specification is used, change it to range specification (use a hyphen (`-`), not a comma (`,`)) `-c 1-xxxxx` Divide the specification of the `adbdbstatus` command, and then execute the command more than once.

Legend:: ∆: Space

To Page Top