Index

• --compress GZIP

• --create-temp-file

• --status wait

• #CHUNKS

• #COLUMNS

• #COMMENT

• #CONNECT

• #DISCONNECT

• #EXIT

• #GETCOUNT

• #GETDATA

• #GETUSER

• #INDEXES

• #SET BINARY_DISP_MODE

• #SET DISPLAY

• #SET DUMPMODE

• #SET EXECTIME REPORT

• #SET NULL

• #SET OPT REPORT

• #SET TRAN_ISOLV

• #TABLES

To Page Top

A

• abbreviations for products

• abnormal termination, handling of

  • adbarchivechunk command

  • adbchgchunkcomment command

  • adbchgchunkstatus command

  • adbexport command

  • adbgetcst command

  • adbidxrebuild command

  • adbimport command

  • adbmergechunk command

  • adbreorgsystemdata command

  • adbsyndict command

  • adbunarchivechunk command

• access path information, displaying (adbsql subcommand)

• acronyms

• adb_arcv_rthd_num

• adb_arcv_scan_buff_size

• adb_dbbuff_wrktbl_clt_blk_num

• adb_export_order_mode

• adb_export_rthd_num

• adb_export_scan_buff_size

• adb_export_wrktbl_blk_num

• adb_getcst_rthd_num

• adb_idxrebuild_buff_blk_num

• adb_idxrebuild_dvix_rdbuff_size

• adb_idxrebuild_dvix_wtbuff_size

• adb_idxrebuild_rthd_num

• adb_idxrebuild_scan_buff_size

• adb_idxrebuild_sort_buff_size

• adb_idxrebuild_txt_buff_size

• adb_import_buff_blk_num

• adb_import_decompress_buff_size

• adb_import_dividx_rd_buff_size

• adb_import_dividx_wt_buff_size

• adb_import_errdata_file_name

• adb_import_errdata_num

• adb_import_errmsg_lv

• adb_import_input_record_size

• adb_import_null_string

• adb_import_read_size

• adb_import_rthd_num

• adb_import_sort_buff_size

• adb_import_txt_buff_size

• adb_init_dbarea_initialize

• adb_init_dic_blk_path

• adb_init_mst_blk_path

• adb_init_multi_max

• adb_init_stbl_blk_path

• adb_init_wrk_blk_path

• adb_init_wrk_page_size

• adb_mergechunk_buff_blk_num

• adb_mergechunk_dvix_rdbuff_size

• adb_mergechunk_dvix_wtbuff_size

• adb_mergechunk_rthd_num

• adb_mergechunk_scan_buff_size

• adb_mergechunk_sort_buff_size

• adb_mergechunk_txt_buff_size

• adb_mod_area_file_rthd_num

• adb_unarcv_buff_blk_num

• adb_unarcv_decompress_buff_size

• adb_unarcv_dividx_rd_buff_size

• adb_unarcv_dividx_wt_buff_size

• adb_unarcv_read_size

• adb_unarcv_rthd_num

• adb_unarcv_sort_buff_size

• adb_unarcv_txt_buff_size

• adbaddarea operand

• adbarchivechunk command

  • example

  • handling abnormal termination of

  • specification format

• adbaudittrail command

  • example

  • specification format

• adbcancel command

  • example of use

  • specification format

• adbchgchunkcomment command

  • example of use

  • handling abnormal termination of

  • specification format

• adbchgchunkstatus command

  • example

  • handling abnormal termination of

  • specification format for

• adbchgnodetype command

  • specification format

• adbchgsqltrc command

  • example of use

  • specification format

• adbchgsrvmode command

  • example of use

  • specification format

• adbclientdefmang command

  • example of use

  • specification format

• adbcolumninfo operand

• adbcolumnize command

  • example

  • specification format

• adbconvertaudittrailfile command

  • example of adbconvertaudittrailfile

  • specification format

• adbdbstatus command

  • example of use

  • output rules for

  • specification format

• adbexpandarea operand

• adbexport command

  • example

  • handling abnormal termination of

  • specification format

• adbgetcst command

  • example

  • handling abnormal termination of

  • specification format

• adbidxrebuild command

  • example

  • handling abnormal termination of

  • specification format

• adbimport command

  • example

  • handling abnormal termination of

  • specification format

• adbinfoget command

  • example of use

  • specification format

• adbinfosweep command

  • specification format

• adbinit command

  • example of use

  • specification format

• adbinitdbarea operand

• adbinstall command

  • specification format

• adbls -d cltgrp

• adbls -d cltgrp command

  • example

  • specification format

• adbls -d cnct command

  • example

  • specification format

• adbls -d gbuf command

  • example

  • specification format

• adbls -d lbuf command

  • example

  • specification format

• adbls -d lock command

  • example

  • specification format

• adbls -d mem command

  • example of use

  • specification format

• adbls -d node command

  • example

  • specification format

• adbls -d shm command

  • example of use

  • specification format

• adbls -d srv command

  • example

  • specification format

• adbls -d thd command

  • example of use

  • specification format

• adbls -d ver command

  • example of use

  • specification format

• adbmergechunk command

  • example

  • handling abnormal termination of

  • specification format

• adbmodarea command

  • example of use

  • specification format

• adbmodbuff command

  • example of use

  • specification format

• adbmonitor command

  • specification format

• adbreorgsystemdata command

  • example of use

  • handling abnormal termination of

  • specification format

• adbrmarea operand

• adbsql command

  • example of use

  • specification format

• adbsql subcommand

• adbstart command

  • example of use

  • specification format

• adbstat command

  • example of use

  • output rules for

  • specification format

• adbstop command

  • example of use

  • specification format

• adbsyndict command

  • example

  • handling abnormal termination of

  • specification format

• adbunarchivechunk command

  • example

  • handling abnormal termination of

  • specification format

• adding DB area

• adding DB area file

• addition mode

• allocated area size (HADB server statistical information)

• analyzing database status

  • checking status of specific index (output of summary information for index)

  • checking status of specific table (output of summary information for table)

  • checking usage of specific index (output of summary information for index)

  • checking usage rate and usage of DB area file in specific DB area (output of usage information for DB areas, tables, and indexes)

  • checking whether specific column store table must be reorganized (output of information about need for reorganization of column store table)

  • finding file size of each archive file corresponding to archived chunk created in specific table (outputting usage information of archived chunks)

  • finding total size of all archive files corresponding to archived chunk created in specific table (outputting summary information of archived chunks)

• application identifier (connection statistical information)

• application identifier (SQL statement statistical information)

• application identifier, displaying

• archive chunk options

• archive file name (usage information of archived chunks)

• archive file size (usage information of archived chunks)

• archiving chunks

  • archiving chunks that include specific date range data

  • checking chunks to be archived based on specified date range before execution

• audit trail

• audit trail facility

  • audit trail facility, enabling

  • information related to audit trail facility, displaying

• audit trail facility, enabling (adbaudittrail command)

• audit trail facility, disabling (adbaudittrail command)

• audit trail file conversion

• audit trail file, swapping (adbaudittrail command)

• authorization identifier, displaying (adbsql subcommand)

• automatic extension count (connection operation information)

To Page Top

B

• background importing

  • background importing CSV-format table data compressed in GZIP format

• background importing CSV-format table data compressed in GZIP format

• background-import

• binary data output format, specifying (adbsql subcommand)

• block special file (DB area file)

  • adding DB area

  • deleting DB area

  • expanding DB area

• BOM

• buffer-modifying option

• buffer-modifying option file name

• buffer, changing

• bytecode, by (export results)

To Page Top

C

• canceling (command)

• centrally managing (client definitions)

• centrally managing client definitions

• changing

  • HADB server's node type

  • node type

• changing chunk status

  • from normal to wait

• changing comments set for chunks

• changing to normal status (chunks)

• changing to wait status (chunks)

• chunk

  • chunk to which data is to be added (adbimport command)

  • setting, changing, and deleting comments for

• chunk archive processing

• chunk archived state (summary information of archived chunks)

• chunk ID

  • chunk ID of current chunk for table (table summary information)

• chunk ID (information about need for reorganization)

• chunk ID (summary information of archived chunks)

• chunk ID (usage information for DB areas, tables, and indexes)

• chunk ID (usage information of archived chunks)

• chunk ID of current chunk (table summary information)

• chunk ID specification (adbarchivechunk command)

• chunk ID specification (adbunarchivechunk command)

• chunk information, displaying (adbsql subcommand)

• chunk status

  • changing

• chunk status (summary information of archived chunks)

• chunk status (usage information for DB areas, tables, and indexes)

• chunk status (usage information of archived chunks)

• chunk unarchive processing

• chunk unarchive processing progress messages

• chunk-data storage format (usage information for DB areas, tables, and indexes)

• CHUNKS (adbsql subcommand)

• client group name, displaying

• client groups, displaying information on

• client management definition

• client type, displaying

• column information, displaying (adbsql subcommand)

• column structure information file

• COLUMNS (adbsql subcommand)

• command

  • common rule

• command argument

• command explanation, format of

• command groups, displaying information on

• command status file (adbidxrebuild command)

• command status file (adbimport command)

• command termination status (whether command needs to be re-executed) (table summary information)

• comment (adbsql command)

• COMMENT (adbsql subcommand)

• comment line, specifying (adbsql subcommand)

• comment specified in chunk (archived chunks' summary information)

• commit count (connection operation information)

• common format audit trail file

• communication time between nodes (connection operation information)

• communication time between nodes (SQL statement statistical information)

• compress GZIP

• compression

  • background importing CSV-format table data compressed in GZIP format

  • compression format of input data files (adbimport command)

  • compression format of output data files (adbexport command)

  • exporting data for specific chunk IDs to files compressed in GZIP format

• compression format of input data files

• compression format of output data files

• compression rate of archived chunks (archived chunks' summary information)

• CONNECT (adbsql subcommand)

• connecting to HADB server (adbsql subcommand)

• connection ID, displaying

• connection information (SQL statement statistical information)

• connection information, displaying

• connection operation information

  • checking operational status of specific application program

  • list of output items

• connection sequence number (connection operation information)

• connection sequence number, displaying

• connection status, displaying, [2]

• conventions

  • abbreviations for products

  • acronyms

  • fonts and symbols

  • KB, MB, GB, TB, PB, and EB

  • version numbers

• converting (audit trail files)

• cost information

  • collecting

  • cost information, collecting for all tables

  • cost information, collecting for specific table

  • cost information, deleting for all tables

  • cost information, deleting for specific table

  • deleting

• cost information collection progress message

• cost-information collection option

• cost-information collection processing

• cost-information collection-options file

• create-temp-file

• creation mode

• CSV format

  • background importing CSV-format table data compressed in GZIP format

• CSV format (output data file)

• CSV format specifications (input data file)

To Page Top

D

• data export processing

• data export progressing message

• data import processing

• data import progress message

• data size written to audit trail file (HADB server statistical information)

• data stored in chunk, getting (adbsql subcommand)

• database

  • analyzing status of

  • initializing

• database status, analysis

  • checking usage of entire database (output of summary information for DB areas)

  • checking usage of specific DB area (output of summary information for DB areas)

• database status, analyzing

  • usage of specific table, checking (output of summary information for table)

• date and time connection was established (connection operation information)

• date and time connection was established (SQL statement statistical information)

• DB area

  • deleting

• DB area addition and modification option

• DB area addition and modification option file name

• DB area automatic extension count (connection operation information)

• DB area automatic extension count (SQL statement statistical information)

• DB area file name (usage information for DB areas, tables, and indexes)

• DB area ID (index summary information)

• DB area ID (information about need for reorganization)

• DB area ID (table summary information)

• DB area ID (usage information for DB areas, tables, and indexes)

• DB area ID (usage information of archived chunks)

• DB area information output number (SQL statement statistical information)

• DB area name (DB area summary information)

• DB area name (index summary information)

• DB area name (information about need for reorganization)

• DB area name (SQL statement statistical information)

• DB area name (table summary information)

• DB area name (usage information for DB areas, tables, and indexes)

• DB area name (usage information of archived chunks)

• DB area segment usage rate (DB area summary information)

• DB area, adding and changing

  • adding DB area (creating DB area file using block special file)

  • adding DB area (creating DB area file using regular file)

  • deleting DB area (deleting DB area files that are block special file)

  • deleting DB area (deleting DB area files that are regular files)

  • expanding DB area (adding DB area files using block special files)

  • expanding DB area (adding DB area files using regular files)

• DB directory name

• DB directory, creating (multi-node function)

• DELETE statement execution time (connection operation information)

• deleting comments set for chunks

• deleting synonym dictionaries

• deleting synonym dictionary

• delimiter (adbdbstatus command (information about need for reorganization))

• delimiter (adbdbstatus command (summary information or usage information))

• delimiter (adbexport command)

• delimiter (adbimport command)

• delimiter (adbstat command)

• details about specifying ranges (adbdbstatus command)

• details about specifying ranges (adbunarchivechunk command)

• direct I/O

• directory path file

• disabling updated-row columnizing facility (adbcolumnize command)

• DISCONNECT (adbsql subcommand)

• disconnecting from HADB server (adbsql subcommand)

• displaying status of updated-row columnizing facility (adbcolumnize command)

• dynamic parameter

  • operating method when dynamic parameters are used in adbsql

To Page Top

E

• EB meaning

• elapsed time of SQL statement, displaying

• empty string

• empty-string input data, value stored for (adbimport command)

• enabling updated-row columnizing facility (adbcolumnize command)

• enclosing character (adbdbstatus command (information about need for reorganization))

• enclosing character (adbdbstatus command (summary information or usage information))

• enclosing character (adbexport command)

• enclosing character (adbimport command)

• enclosing character (adbstat command)

• example of input data path file

• example of output data path file

  • --compress GZIP option is not specified

  • --compress GZIP option is specified

• example of SQL statement file

• executing SQL statement from standard input

• executing SQL statement specified in file

• EXIT (adbsql subcommand)

• expanding DB area

• explanation of range specification (adbarchivechunk command)

• export

  • compression format of output data files (adbexport command)

  • outputting column name

• export option

• export option file

• exporting

  • all data from table

  • data with specific chunk ID

  • exporting data for specific chunk IDs to files compressed in GZIP format

  • retrieval result of SQL statement

To Page Top

F

• field data

• field data number

• field data specification format (fixed-length format)

• first DB area file path (DB area summary information)

• fixed-length format specifications (input data file)

• flush count due to full user log buffer (connection operation information)

• flush count due to full user log buffer (SQL statement statistical information)

• font conventions

• forced termination (command), [2]

• forced termination (transaction)

• forcibly terminating command

• forcibly terminating transaction

• format of input data file

  • CSV format specifications

• format of input data file (adbimport command)

  • fixed-length format specifications

• format of output data file (adbexport command)

• function for centrally managing client definitions

  • applying content of function for centrally managing client definitions

  • checking name of client definition file applied to specific HADB client

• functionality for deleting pre-reorganization data (reorganizing system tables)

To Page Top

G

• GB meaning

• GETCOUNT (adbsql subcommand)

• GETDATA (adbsql subcommand)

• GETUSER (adbsql subcommand)

• global buffer information output number (SQL statement statistical information)

• global buffer information, displaying

• global buffer name (global buffer statistical information)

• global buffer name (SQL statement statistical information)

• global buffer page hit count (global buffer statistical information)

• global buffer page hit count (SQL statement statistical information)

• global buffer page hit rate (global buffer statistical information)

• global buffer page hit rate (SQL statement statistical information)

• global buffer page-in count (global buffer statistical information)

• global buffer page-out count (global buffer statistical information)

• global buffer sectors, number of

  • number of global buffer sectors that have been allocated

  • total number of global buffer sectors (global buffer statistical information)

• global buffer statistical information

  • checking operational status of specific global buffer

  • list of output items

To Page Top

H

• HADB client (Linux), installing

• HADB client IP address, displaying

• HADB client process ID, displaying

• HADB server

  • changing operation mode of

  • displaying status of

  • displaying version information of

  • installing

  • monitoring

  • starting

  • terminating

• HADB server statistical information

  • checking operational status of entire system

  • list of output items

• HADB server status, displaying (each node)

• Hashflt_area_size

• Hashtbl_area_size

• hexadecimal format, displaying in (adbsql subcommand)

• how to display command help

• how to display command usage message

To Page Top

I

• import

  • compression format of input data files (adbimport command)

  • format of input data file (CSV format specifications)

  • format of input data file (fixed-length format specifications)

• import option

• import option file

• importing

  • background importing CSV-format table data compressed in GZIP format

  • importing table data in CSV format

  • importing table data in CSV format (when column structure information file is specified)

  • importing table data in fixed-length format

• importing table data

  • CSV format

  • CSV format (when column structure information file is specified)

  • fixed-length format

• importing table data in CSV format

• importing table data in CSV format (when column structure information file is specified)

• importing table data in fixed-length format

• index ID (index summary information)

• index identifier (index summary information)

• index identifier file

• index information

• index information, displaying (adbsql subcommand)

  • #INDEXES

  • #SET OPT REPORT

• index rebuild option

• index rebuild option file

• index rebuild processing

• index rebuild processing progress message

• index type (index summary information)

• INDEXES (adbsql subcommand)

• information about need for reorganization

  • checking whether specific column store table must be reorganized (example)

  • list of output items

  • number of rows output

  • output example of

  • output order

• information about need for reorganization of column store table

  • checking whether specific column store table must be reorganized (example)

• information related to audit trail facility, displaying (adbaudittrail command)

• initial allocation size (adbaddarea operand)

• initial allocation size (adbexpandarea operand)

• initial allocation size (adbinitdbarea operand)

• initialization option

• initialization option file

• initializing DB area

  • creating DB area file using block special file

  • DB directory, creating (multi-node function)

• input data

  • coding rules for (CSV format)

  • coding rules for (fixed-length format)

• input data file

• input data path file

• input data specification rule (adbsql command)

• INSERT statement execution time (connection operation information)

• installing

To Page Top

K

• KB meaning

To Page Top

L

• list of commands

• local work table buffer hit count (SQL statement statistical information)

• local work table buffer hit rate (SQL statement statistical information)

• local work table buffer information, displaying

• local work table buffer pages, changing

• locked resource status, displaying

• logical error data file

• logical error data file, content of (when only data destined for storage is extracted)

• logical error data file, content of (when row data is output without any processing)

• logical error data, output of

• logical error handling procedure

To Page Top

M

• machine (machine that can execute command)

• machine that can execute (machine that can execute command)

• maintenance mode

  • changing to maintenance mode (adbchgsrvmode command)

• managing audit trail facility

• managing synonym dictionary

• managing updated-row columnizing facility

• Max_sql_rthd_num

• maximum number of allocated work table pages (HADB server statistical information)

• maximum number of pages used in local work table buffer (SQL statement statistical information)

• maximum number of processing real threads used during segment release (SQL statement statistical information)

• maximum number of sorting stages for local work table (SQL statement statistical information)

• maximum number of SQL processing real threads (SQL statement statistical information)

• maximum number of work table pages used for sorting local work table (SQL statement statistical information)

• maximum usage

  • maximum usage of all memory (HADB server statistical information)

  • maximum usage of hash grouping area (connection operation information)

  • maximum usage of hash table area (connection operation information)

  • maximum usage of process common memory (HADB server statistical information)

  • maximum usage of user log file (HADB server statistical information)

  • maximum usage of user log file (SQL statement statistical information)

  • maximum usage of user log files (connection operation information)

  • total value of maximum usage of each real thread's private memory (HADB server statistical information)

• maximum usage of all memory (HADB server statistical information)

• maximum usage of hash grouping area (connection operation information)

• maximum usage of hash grouping area (SQL statement statistical information)

• maximum usage of hash table area (connection operation information)

• maximum usage of hash table area (SQL statement statistical information)

• maximum usage of process common memory (HADB server statistical information)

• maximum usage of user log file (HADB server statistical information)

• maximum usage of user log file (SQL statement statistical information)

• maximum usage of user log files (connection operation information)

• maximum value (hexadecimal) of archive range column (summary information of archived chunks)

• maximum value (hexadecimal) of archive range column (usage information of archived chunks)

• maximum value of archive range column (summary information of archived chunks)

• maximum value of archive range column (usage information of archived chunks)

• maximum value of memory in table scan buffer used by each real thread (SQL statement statistical information)

• MB meaning

• memory usage status, displaying

• merge chunk option

• merge chunk processing

• merge chunk processing progress message

• merging chunks

  • any chunk (including current chunk)

  • any chunk (other than current chunk)

  • merging all chunks in table

• minimum value (hexadecimal) of archive range column (summary information of archived chunks)

• minimum value (hexadecimal) of archive range column (usage information of archived chunks)

• minimum value of archive range column (summary information of archived chunks)

• minimum value of archive range column (usage information of archived chunks)

• minimum value of memory in table scan buffer used by each real thread (SQL statement statistical information)

• model DB area addition and modification option

• model initialization option

• monitoring (HADB server)

• multi-node function, node on which commands can be executed when using

To Page Top

N

• name of command to be re-executed (table summary information)

• necessity of reorganizing column store table (information about need for reorganization)

• node number, displaying

• non-updatable status (table summary information)

• normal mode

  • changing to normal mode (adbchgsrvmode command)

  • starting in normal mode (adbstart command)

• null value display format, specifying (adbsql subcommand)

• number of archived chunks (table summary information)

• number of automatic extensions (HADB server statistical information)

• number of automatic extensions for DB area (HADB server statistical information)

• number of chunks

  • number of chunks created for table (table summary information)

  • number of chunks created in DB area (DB area summary information)

  • number of chunks that can be created for table (table summary information)

  • number of chunks that can be created in DB area (table summary information)

• number of chunks created (table summary information)

• number of chunks created in DB area (table summary information)

• number of chunks in wait status (table summary information)

• number of chunks that can be created (table summary information)

• number of chunks that can be created in DB area (DB area summary information)

• number of commits (HADB server statistical information)

• number of data items stored in chunk, getting (adbsql subcommand)

• number of DB area files (DB area summary information)

• number of delete-pending chunks (table summary information)

• number of fetched rows (connection operation information)

• number of fetched rows (SQL statement statistical information)

• number of file read requests for global buffer (global buffer statistical information)

• number of files opened by ADB_AUDITREAD function (SQL statement statistical information)

• number of files opened by ADB_CSVREAD function (SQL statement statistical information)

• number of files to be created (adbaddarea operand)

• number of files to be created (adbexpandarea operand)

• number of files to be created (adbinitdbarea operand)

• number of flushes caused by full user log buffer (HADB server statistical information)

• number of global buffer sectors that have been allocated (global buffer statistical information)

• number of initialized pages in DB area file (usage information for DB areas, tables, and indexes)

• number of local work table buffer page requests (SQL statement statistical information)

• number of page requests for global buffer (global buffer statistical information)

• number of page requests for global buffer (SQL statement statistical information)

• number of page requests for range index buffers (global buffer statistical information)

• number of page requests for table scan buffers (global buffer statistical information)

• number of page requests for table scan buffers (SQL statement statistical information)

• number of pages (information about need for reorganization)

  • number of basic row pages contained in row-data segment

  • number of branch row pages contained in row-data segment

  • number of invalid row information pages contained in row-data segment

• number of pages in use (index summary information)

• number of pages in use (table summary information)

• number of pages in use (usage information for DB areas, tables, and indexes)

• number of pages in use by index (index summary information)

• number of pages in use by table (table summary information)

• number of range index buffer sectors

  • number of range index buffer sectors that have been allocated (global buffer statistical information)

  • total number of range index buffer sectors (global buffer statistical information)

• number of range index buffer sectors that have been allocated (global buffer statistical information)

• number of range index page requests for global buffer (SQL statement statistical information)

• number of requests to read files into range index buffer (global buffer statistical information)

• number of requests to write data from global buffer to files (global buffer statistical information)

• number of requests to write data from range index buffer to files (global buffer statistical information)

• number of rollbacks (HADB server statistical information)

• number of rows in column store format (information about need for reorganization)

  • number of rows converted in column store format by updated-row columnizing facility

  • number of rows imported into column-data segment by adbimport command

• number of rows stored in archived chunk (archived chunks' summary information)

• number of rows updated (connection operation information)

• number of rows updated (SQL statement statistical information)

• number of segments in use (DB area summary information)

• number of segments in use (index summary information)

• number of segments in use (table summary information)

• number of segments in use (usage information for DB areas, tables, and indexes)

• number of segments in use by index (index summary information)

• number of segments in use by table (table summary information)

• number of segments in use in DB area (DB area summary information)

• number of swap operations of audit trail file (HADB server statistical information)

• number of table scan buffer sectors in which shortage occurred (SQL statement statistical information)

• number of table scan buffer sectors reused (global buffer statistical information)

• number of times acquisition of table-definition information was requested (HADB server statistical information)

• number of times acquisition of table-definition information was requested (SQL statement statistical information)

• number of times allocation of locked resources (DB areas) was placed in wait status (SQL statement statistical information)

• number of times allocation of locked resources (tables) was placed in wait status (SQL statement statistical information)

• number of times background import can be performed (table summary information)

• number of times buffer shortage occurred in table scan buffer (global buffer statistical information)

• number of times buffer shortage occurred in table scan buffer (SQL statement statistical information)

• number of times communication took place between nodes (connection operation information)

• number of times communication took place between nodes (SQL statement statistical information)

• number of times data was written from global buffer to files (global buffer statistical information)

• number of times data was written from global buffer to files (SQL statement statistical information)

• number of times data was written from local work table buffer to files (connection operation information)

• number of times data was written from local work table buffer to files (SQL statement statistical information)

• number of times data was written from range index buffers to files (global buffer statistical information)

• number of times data was written from range index pages in global buffer to files (SQL statement statistical information)

• number of times data was written into local work table buffer (SQL statement statistical information)

• number of times data was written to global buffer (SQL statement statistical information)

• number of times data was written to range index pages in global buffer (SQL statement statistical information)

• number of times DELETE statement was executed (connection operation information)

• number of times directory information was sent (connection operation information)

• number of times files were read into global buffer (global buffer statistical information)

• number of times files were read into global buffer (SQL statement statistical information)

• number of times files were read into local work table buffer (connection operation information)

• number of times files were read into local work table buffer (SQL statement statistical information)

• number of times files were read into range index buffers (global buffer statistical information)

• number of times files were read into range index pages in global buffer (SQL statement statistical information)

• number of times files were read into table scan buffers (global buffer statistical information)

• number of times files were read into table scan buffers (SQL statement statistical information)

• number of times hash grouping area was allocated (connection operation information)

• number of times hash grouping area was allocated (SQL statement statistical information)

• number of times index page split occurred in B-tree indexes (SQL statement statistical information)

• number of times index page split occurred in text indexes (SQL statement statistical information)

• number of times INSERT statement was executed (connection operation information)

• number of times local work table buffer was created (SQL statement statistical information)

• number of times locked resources (DB areas) were allocated (SQL statement statistical information)

• number of times locked resources (tables) were allocated (SQL statement statistical information)

• number of times PURGE CHUNK statement was executed (connection operation information)

• number of times SELECT statement was executed (connection operation information)

• number of times shortage of processing threads occurred when multiple statement handles were executed concurrently (connection operation information)

• number of times SQL statement execution-pending status occurs (HADB server statistical information)

• number of times storage of data values by table chunks in range satisfying search condition was checked in retrievals using range indexes (SQL statement statistical information)

• number of times storage of data values by table segments in range satisfying search condition was checked in retrievals using range indexes (SQL statement statistical information)

• number of times table chunks were not skipped in retrievals using range indexes (SQL statement statistical information)

• number of times table chunks were skipped in retrievals using range indexes (SQL statement statistical information)

• number of times table scan buffers were reset (SQL statement statistical information)

• number of times table segments were not skipped in retrievals using range indexes (SQL statement statistical information)

• number of times table segments were skipped in retrievals using range indexes (SQL statement statistical information)

• number of times table-definition information was acquired from dictionary table (HADB server statistical information)

• number of times table-definition information was acquired from dictionary table (SQL statement statistical information)

• number of times table-definition information was acquired from table-definition pool (HADB server statistical information)

• number of times table-definition information was acquired from table-definition pool (SQL statement statistical information)

• number of times table-definition information was purged from table-definition pool (HADB server statistical information)

• number of times table-definition information was purged from table-definition pool (SQL statement statistical information)

• number of times table-definition information was registered to table-definition pool (HADB server statistical information)

• number of times table-definition information was registered to table-definition pool (SQL statement statistical information)

• number of times transaction started (HADB server statistical information)

• number of times TRUNCATE TABLE statement was executed (connection operation information)

• number of times UPDATE statement was executed (connection operation information)

• number of times user log files have been written (connection operation information)

• number of times user log files were reduced to initialization size (connection operation information)

• number of times user log files were reduced to initialization size (HADB server statistical information)

• number of times user log files were written (SQL statement statistical information)

• number of times validity of row data was checked in retrievals using B-tree indexes (SQL statement statistical information)

• number of write operations to audit trail file (HADB server statistical information)

• number of write operations to user log file (HADB server statistical information)

To Page Top

O

• occurrence of hash grouping area shortage (SQL statement statistical information)

• occurrence of hash table area shortage (SQL statement statistical information)

• offline mode

  • changing to offline mode (adbchgsrvmode command)

  • starting in offline mode (adbstart command)

• option

• option argument

• OS users (OS users who can execute command)

• OS users who can execute (OS users who can execute command)

• output data file

• output data path file

• output rules

  • adbdbstatus command

  • adbstat command

• output-directory for common format audit trails

• outputting list of synonyms, [2]

To Page Top

P

• page group size (index summary information)

• page hit count in range index buffer (global buffer statistical information)

• page hit rate in range index buffer (global buffer statistical information)

• page size (adbaddarea operand)

• page size (adbinitdbarea operand)

• page size (DB area summary information)

• page size (index summary information)

• page size (table summary information)

• page size (usage information for DB areas, tables, and indexes)

• PB meaning

• progress message for chunk archive processing

• pseudo-threads, displaying number of

• PURGE CHUNK statement execution time (connection operation information)

To Page Top

Q

• quiescence mode

  • changing to quiescence mode (adbchgsrvmode command)

  • starting in quiescence mode (adbstart command)

To Page Top

R

• range index buffer page-in count (global buffer statistical information)

• range index buffer page-out count (global buffer statistical information)

• range index page group size (index summary information)

• range index page hit count in global buffer (SQL statement statistical information)

• range index page hit rate in global buffer (SQL statement statistical information)

• range specification (adbarchivechunk command)

  • archiving chunks that include specific date range data

  • checking chunks to be archived based on specified date range before execution

• range specification (adbdbstatus command)

• range specification (adbunarchivechunk command)

  • unarchiving chunks that include specific date range data

  • when you want to check which chunks are to be unarchived based on specified date range before actually executing chunk unarchive processing

• re-creating synonym list definition file

• re-execute facility (adbidxrebuild command)

• re-execute facility that starts from processing to create B-tree indexes and text indexes

• real thread number, displaying

• real thread type, displaying

• rebuilding indexes

  • rebuilding specified indexes

  • rebuilding unfinished indexes

• rebuilding indexes in unfinished status

• rebuilding unfinished indexes

• record length

• registering synonym dictionaries

• registering synonym dictionary

• regular file (DB area file)

  • adding DB area

  • deleting DB area

  • expanding DB area

• reload processing

• removing unfinished status of indexes

• reorganization processing progress message

• reorganizing

  • reorganizing system tables

  • system tables

• reorganizing system tables, [2]

• retrieval results, outputting (adbsql subcommand)

• return code

  • adbarchivechunk command

  • adbaudittrail command

  • adbcancel command

  • adbchgchunkcomment command

  • adbchgchunkstatus command

  • adbchgnodetype command

  • adbchgsqltrc command

  • adbchgsrvmode command

  • adbclientdefmang command

  • adbcolumnize command

  • adbconvertaudittrailfile command

  • adbdbstatus command

  • adbexport command

  • adbgetcst command

  • adbidxrebuild command

  • adbimport command

  • adbinfoget command

  • adbinfosweep command

  • adbinit command

  • adbinstall command

  • adbls -d cnct command

  • adbls -d gbuf command

  • adbls -d lbuf command

  • adbls -d lock command

  • adbls -d mem command

  • adbls -d node command

  • adbls -d shm command

  • adbls -d srv command

  • adbls -d thd command

  • adbls -d ver command

  • adbls command

  • adbmergechunk command

  • adbmodarea command

  • adbmodbuff command

  • adbmonitor command

  • adbreorgsystemdata command

  • adbsql command

  • adbstart command

  • adbstat command

  • adbstop command

  • adbsyndict command

  • adbunarchivechunk command

• return codes

  • adbls -d cltgrp command

  • adbls command

• rollback count (connection operation information)

• ROW specification

• rules for specifying authorization identifiers

• rules for specifying passwords

To Page Top

S

• schema name (index summary information)

• schema name (information about need for reorganization)

• schema name (table summary information)

• schema name (usage information for DB areas, tables, and indexes)

• schema name of table where index is defined (index summary information)

• schema object ID (usage information for DB areas, tables, and indexes)

• schema object identifier (usage information for DB areas, tables, and indexes)

• schema object type (usage information for DB areas, tables, and indexes)

• schema object type (usage information of archived chunks)

• segment size (DB area summary information)

• segment size (index summary information)

• segment size (table summary information)

• segment size (usage information for DB areas, tables, and indexes)

• segment size used to store indexes of chunks before they are archived (archived chunks' summary information)

• segment size used to store tables of chunks before they are archived (archived chunks' summary information)

• segment type (usage information for DB areas, tables, and indexes)

• segment usage rate (DB area summary information)

• SELECT statement execution time (connection operation information)

• SET BINARY_DISP_MODE (adbsql subcommand)

• SET DISPLAY (adbsql subcommand)

• SET DUMPMODE (adbsql subcommand)

• SET EXECTIME REPORT (adbsql subcommand)

• SET NULL (adbsql subcommand)

• SET OPT REPORT (adbsql subcommand)

• SET TRAN_ISOLV (adbsql subcommand)

• setting, changing, and deleting comments for chunks

• shared memory information, displaying

• size needed to avoid hash grouping area shortage (SQL statement statistical information)

• size of files read into table scan buffer (global buffer statistical information)

• size of files read into table scan buffer (SQL statement statistical information)

• size of hash filter area (SQL statement statistical information)

• size of hash table area (SQL statement statistical information)

• sort code, by (ISO/IEC 14651:2011 compliance) (export results)

• specification format of field data (CSV format)

• specification of merge-source chunk ID

• SQL statement execution time (SQL statement statistical information)

• SQL statement execution time, outputting (adbsql subcommand)

• SQL statement execution wait count (connection operation information)

• SQL statement file

• SQL statement sequence number since connection was established (SQL statement statistical information)

• SQL statement statistical information

  • checking SQL statement statistical information in specific date and time range

  • list of items that are output

• SQL statement type (SQL statement statistical information)

• SQL statement's execution result, outputting to file

• SQL trace function

  • SQL trace information, checking status of

  • SQL trace information, start or stop output of

  • SQL trace information, stop output of

• SQL tracing

  • examples of changing output content of SQL trace information

  • examples of starting output of SQL trace information

• starting in maintenance mode (adbstat command)

• statistical analysis

  • checking operational status of entire system

  • checking operational status of specific application program

  • checking operational status of specific global buffer

  • HADB server

• statistical information in specific date and time range

• status wait

• storage directory for synonym dictionary files

  • deleting unnecessary files

• summary information

  • checking status of specific index (example)

  • checking status of specific table (example)

  • checking usage of entire database (example)

  • checking usage of specific DB area (example)

  • checking usage of specific index (example)

  • finding total size of all archive files corresponding to archived chunk created in specific table (example)

  • summary information for DB areas

  • summary information for indexes

  • summary information for tables

  • summary information of archived chunks

  • usage of specific table, checking (example)

• summary information for DB areas

  • checking usage of entire database (example)

  • checking usage of specific DB area (example)

  • list of output items

  • number of rows output

  • output example of

  • output order

• summary information for indexes

  • checking status of specific index (example)

  • checking usage of specific index (example)

  • list of output items

  • number of rows output

  • output example of

  • output order

• summary information for tables

  • checking status of specific table (example)

  • list of output items

  • number of rows output

  • output example of

  • output order

  • usage of specific table, checking (example)

• summary information of archived chunks

  • finding total size of all archive files corresponding to archived chunk created in specific table (example)

  • list of output items

  • number of rows output

  • output example of

  • output order

• suspending (command)

• suspending command

• swapping common format audit trail file

• symbol conventions

• synchronizing synonym dictionary files, [2]

• synonym search

  • deleting unnecessary files

• system table reorganization processing

To Page Top

T

• table data to be background imported

  • CSV-format files compressed in GZIP format

• table ID (information about need for reorganization)

• table ID (summary information of archived chunks)

• table ID (table summary information)

• table ID (usage information of archived chunks)

• table ID of table where index is defined (index summary information)

• table identifier (information about need for reorganization)

• table identifier (summary information of archived chunks)

• table identifier (table summary information)

• table identifier (usage information of archived chunks)

• table identifier of table where index is defined (index summary information)

• table information, displaying (adbsql subcommand)

• table name specification rules

• table scan buffer page hit count (global buffer statistical information)

• table scan buffer page hit count (SQL statement statistical information)

• table scan buffer page hit rate (global buffer statistical information)

• table scan buffer page hit rate (SQL statement statistical information)

• table scan buffer page-in count (global buffer statistical information)

• table schema name (summary information of archived chunks)

• table schema name (usage information of archived chunks)

• table type (table summary information)

• table-data storage format (table summary information)

• TABLES (adbsql subcommand)

• TB meaning

• temporary work file (adbimport command)

• temporary work file storage location (adbidxrebuild command)

• temporary work file storage location (adbimport command)

• temporary work file storage location (adbmergechunk command)

• temporary work file storage location (adbreorgsystemdata command)

• temporary work file storage location (adbunarchivechunk command)

• temporary work files (adbidxrebuild command)

• temporary work files (adbreorgsystemdata command)

• terminating adbsql command (adbsql subcommand)

• termination standby processing

• thread status, displaying

• thread used by adbarchivechunk command

• thread used by adbexport command

• thread used by adbgetcst command

• thread used by adbidxrebuild command

• thread used by adbimport command

• thread used by adbmergechunk command

• thread used by adbunarchivechunk command

• timestamp when chunk was created (usage information for DB areas, tables, and indexes)

• timestamp when chunks were last swapped (usage information for DB areas, tables, and indexes)

• total access time to synonym dictionary file (SQL statement statistical information)

• total amount of memory requested when there was not enough free space in table scan buffer during execution of SQL statement (SQL statement statistical information)

• total memory usage of table scan buffer during execution of SQL statement (SQL statement statistical information)

• total number of archive files corresponding to archived chunk (archived chunks' summary information)

• total number of global buffer sectors (global buffer statistical information)

• total number of range index buffer sectors (global buffer statistical information)

• total number of segments

  • total number of segments in DB area file (usage information for DB areas, tables, and indexes)

• total number of segments (DB area summary information)

• total number of segments in DB area (DB area summary information)

• total number of segments in DB area file (usage information for DB areas, tables, and indexes)

• total size of all archive files corresponding to archived chunk (archived chunks' summary information)

• total size of data that was read by ADB_AUDITREAD function (SQL statement statistical information)

• total size of data that was read by ADB_CSVREAD function (SQL statement statistical information)

• total time of SQL statement execution-pending status (HADB server statistical information)

• total value of maximum usage of real thread private memory (HADB server statistical information)

• total wait time for SQL statement execution (connection operation information)

• transaction access mode, displaying

• transaction isolation level

  • specifying (adbsql subcommand)

• transaction isolation level, displaying

• transaction start count (connection operation information)

• troubleshooting information

  • collecting

  • deleting

• troubleshooting information (information about need for reorganization)

• troubleshooting-information

  • outputting troubleshooting information while HABD server is running

• troubleshooting-information file

  • estimating output size of

  • troubleshooting-information file (detailed version)

  • troubleshooting-information file (light version)

  • troubleshooting-information file (mail version)

  • troubleshooting-information file (root version)

• troubleshooting-information file (detailed version)

• troubleshooting-information file (light version)

• troubleshooting-information file (mail version)

• troubleshooting-information file (root version)

• TRUNCATE TABLE statement execution time (connection operation information)

• type of DB area (usage information for DB areas, tables, and indexes)

To Page Top

U

• unarchive chunk options

• unarchiving chunks

  • unarchiving chunks that include specific date range data

  • when you want to check which chunks are to be unarchived based on specified date range before actually executing chunk unarchive processing

• unfinished status (index summary information)

• uniqueness constraint violation

  • releasing (adbidxrebuild command)

• uniqueness constraint violation (index summary information)

• unload file storage location

• unload files

• unload processing

• UPDATE statement execution time (connection operation information)

• updated-row columnizing facility

  • displaying status of updated-row columnizing facility

  • enabling updated-row columnizing facility

• updating synonym dictionary, [2]

• usage information

  • checking usage rate and usage of DB area files of specific DB area (example)

  • finding file size of each archive file corresponding to archived chunk created in specific table (example)

  • usage information for DB areas, tables, and indexes

  • usage information of archived chunks

• usage information for DB areas, tables, and indexes

  • checking usage rate and usage of DB area files of specific DB area (example)

  • guidelines for numbers of rows that are output

  • list of output items

  • output example of

  • output order of

• usage information of archived chunks

  • finding file size of each archive file corresponding to archived chunk created in specific table (example)

  • list of output items

  • number of rows output

  • output example of

  • output order of

• usage message

• usage rate (DB area summary information)

To Page Top

V

• VALUES specification

• version number conventions

To Page Top

W

• wait time for allocation of locked resources (DB areas) (SQL statement statistical information)

• wait time for allocation of locked resources (tables) (SQL statement statistical information)

• warnings about messages

• warnings about messages output when command is executed

• whether hash filter is invalidated (SQL statement statistical information)

• work table information

• work table information, displaying (adbsql subcommand)

To Page Top