OpenFrame/HiDB Configuration

This chapter describes configuration items required for OpenFrame/HiDB operation.

1. Overview

For operation of OpenFrame/HiDB (hereafter HiDB), set KEYs of each SECTION in the openframe_hidb.conf file, and then save the system settings by using the ofconfig tool.

Certain KEYs have no default value (NONE). Refer to the Remark for their behaviors when they are not set.

 

The following are descriptions of each subject’s sections. For further details about setting values of each section’s keys, refer to the corresponding section.

  • ims

    Configures common settings for OpenFrame/HiDB and OpenFrame/OSI.

    Section Description

    IMS_DEFAULT

    General information used by both HiDB and OSI.

  • hidb

    Configures general information for OpenFrame/HiDB.

    Section Description

    HIDB_DEFAULT

    Settings for basic behaviors of HiDB.

    DEBUG

    Settings related to debugging.

    DEFAULT_USER

    Information about the default user who executes HiDB.

1.1. ims

Configures common settings for OpenFrame/HiDB and OpenFrame/OS.

1.1.1. IMS_DEFAULT

Sets general information used by both HiDB and OSI.

DBDLIB_NAME

Default DBDLIB name. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

String

Default Value

IMS.DBDLIB

Range

Remark

Specifies a name according to the PDS naming convention.
PSBLIB_NAME

Default PSBLIB name. All nodes in a multi-node environment must use the same configuration.

Section Description

Parameter Type

String

Default Value

IMS.PSBLIB

Range

Remark

Specifies a name according to the PDS naming convention.
RESLIB_NAME

Default MDA RESLIB name. All nodes in a multi-node environment must use the same configuration.

Section Description

Parameter Type

String

Default Value

IMS.RESLIB

Range

Remark

Specifies a name according to the PDS naming convention.
ACBLIB_NAME

Default ACBLIB name. All nodes in a multi-node environment must use the same configuration.

Section Description

Parameter Type

String

Default Value

IMS.ACBLIB

Range

Remark

Specifies a name according to the PDS naming convention.

1.2. hidb

Configures settings for OpenFrame/HiDB behaviors.

1.2.1. HIDB_DEFAULT

Sets information related to basic behaviors of HiDB.

COPYBOOK_DIR

Copybook path referred by hdgensch.

Item Description

Parameter Type

String

Default Value

${OPENFRAME_HOME}/copybook

Range

Remark
TABLESPACE

Tablespace to create HiDB tables and indexes. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

String

Default Value

DEFVOL

Range

Remark
HIDB_OBJECT_DIR

Default path for an object file created by hidbmgr dligen.

Item Description

Parameter Type

String

Default Value

${OPENFRAME_HOME}/obj_dir

Range

Remark
FIX_DATA_ERRORS

Option to automatically change data into 0 when incorrect data is found in columns consisting of digits while executing DLI commands. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark
NO_INDEX_TABLE

Option to directly define an index in a segment table rather than create an index table when defining a secondary index. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark

If set to YES, the process is faster and the database is more simply organized, but the index segment cannot be directly managed. If the setting is changed, the database must be newly organized.
IGNORE_FILLER

Option to ignore FILLER when creating a segment table and processing DLI commands. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark
COMMIT_INTERVAL

Interval at which a commit is requested to DBMS when processing DLI commands. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Number

Default Value

0

Range

Remark

0 means that a commit is executed after the corresponding HiDB step is finished.
RESOLVE_HINT_DIR

Path that stores hint statements used in a SELECT query when processing a GET DLI request.

Item Description

Parameter Type

String

Default Value

Range

Remark
FIRST_FETCH_COUNT

Value to be used in FIRST_ROWS HINT statement for the number of fetches when processing the GET DLI command. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Number

Default Value

10

Range

Remark
HIDB_ALTER_KEYSEQ

Option to specify a custom sort including EBCDIC sequence. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark

If the setting is changed, the database must be newly organized.

If set to YES, HiDB 7.2 defines a key column with NVARCHAR2, a function of Tibero.
IGNORE_AUTH_CHECK

Option to perform TACF authority check when manipulating a segment. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark
FETCH_COL_DEFAULT_VALUE

Hexadecimal value to replace null byte data when executing the GET DLI command. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

String

Default Value

0x00

Range

Sets 1 byte value in hexadecimal.

Remark
RESET_APPBUF_IF_GET_FAIL

Option to empty the data buffer received when the GET DLI command fails. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

YES

Range

YES, NO

Remark
SKIP_POSITIONING_IF_GET_FAIL

Option to set the current location as either the nearest location or a temporary location when the GET DLI command fails. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

YES

Range

YES, NO

Remark

If set to YES, the process is faster.
HIDB_IMPORT_DIR

Path for the data file when executing hdload by using a loader module.

Item Description

Parameter Type

String

Default Value

${OPENFRAME_HOME}/import_dir

Range

Remark
USE_INDICATOR

Option to use indicator variables when a DLI library file created by hidbmgr dligen processes the FETCH command. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark
ARRAY_BUFFER_MAX_SIZE

Maximum size of an array buffer to be used at the GET NEXT request. 0 means that an array buffer is not used. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Number

Default Value

0

Range

Remark
USE_KEYFLD_SEQ_FOR_HDAM

Option to specify the root segment of HDAM DBD either in order of OCC_ID or key field. The default value is NO, but NO setting may cause restrictions on some behaviors including buffering of HiDB. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark

If the setting is changed, the database must be newly organized or the index of the root segment table must be newly defined.
USE_DBD_DBMS_LOCK

Option to not request DDL to DBD currently in use, by using DBMS_LOCK. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

YES

Range

YES, NO

Remark
HOLD_SELECT_FOR_UPDATE

Option to specify whether to request a SELECT query with FOR UPDATE when requesting the GET DLI command with HOLD. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

YES

Range

YES, NO

Remark

If set to NO, the process is faster. But if multiple jobs can be executed in a single DBD at the same time, YES setting is recommended.

1.2.2. DEBUG

Sets debug information related to HiDB operation.

GENERAL

Option to print general debug information during HiDB operation. The information includes requested DLI commands, SQL queries for DLI commands, execution time, status code resulting from executing DLI commands. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark
SHOW_BUFFER

Option to print buffer information used in SQL queries including INSERT and SELECT statements when executing DLI commands. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark
DISABLE_COMMIT

Option to disable a commit when processing metadata or DLI commands. If set to YES, behavior test can be conducted without changing the database. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark
PRINT_STATISTICS

Option to print statistics information when disconnecting HiDB. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

Y_N

Default Value

NO

Range

YES, NO

Remark

1.2.3. DEFAULT_USER

Sets information required to the database while executing HiDB.

USERNAME

User name required to access the database. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

String

Default Value

Range

Remark
ENPASSWD

Encrypted password required to access the database. All nodes in a multi-node environment must use the same configuration.

Item Description

Parameter Type

String

Default Value

Range

Remark