Skip to content
≡

Administrator

Developer

Tools

External Tools

Other Properties#

ACCESS_LIST#

Format#

ACCESS_LIST = operation, address, mask

Range#

  • operation ::= [PERMIT|DENY]

    Indicates whether to allow or deny access by an IP packet that matches a validation rule.

  • address

    Indicates the IP address of the packet to validate. It can be in IPv4 or IPv6 address notation.

  • mask

    If the specified address is in IPv4 address notation, mask specifies that only part of the IP address of a packet, the subnet mask, is to be validated.

    If the specified address is in IPv6 address notation, mask gives the length of prefix bits to be compared. An IPv6 address is matched if the specified mask bits of the specified address are equal to the specified mask bits of the originating address of an incoming IP packet.

  • limit

    limit is an optional item. Specifies the maximum number of sessions allowed to access the Altibase server from the accessible IP address range specified in ACCESS_LIST.

    If a value is entered in the limit item, limit condition checks are performed on all access requests. Therefore, access is not allowed if the number of access requests from allowed IPs exceeds the limit. If there is no value in the limit item, the limit condition is not checked.

    If ACCESS_LIST is added with the ALTER SYSTEM RELOAD ACCESS LIST statement while the Altibase server is running, existing connected sessions are not affected, and the ACCESS_LIST condition is applied only to new connection requests after the change. So when retrieving V$ACCESS_LIST, the CONNECTED value may be greater than the LIMIT value.

Validation Rule#

IF 
BITXOR(BITAND(IP_packet,mask), BITAND(address,mask)) = 0
THEN  valid
ELSE  invalid

Description#

This property can grant or deny an IP packet attempting to access to Altibase in accordance with an address. By inspecting the IP packet address based upon the specified inspection rules, it can be decided whether or not to allow access. If the IP packet address is corresponding as described in the operation, the access is permitted, but if not, the IP packet is neglected and the next list will be inspected.

If multiple IP packet addresses are specified, the inspection is executed in the order delineated. If there is no address to be matched, the access is allowed.

If the property value of ACCESS_LIST_FILE is described, an external file list defined in the ACCESS_LIST property can be used. The external file can use maximum 1024 lists, but 'ACCESS_LIST=' should be omitted and only the contents should be written out.

Example#

Block packets with the IP address 192.168.1.55 and allow all other packets.

ACCESS_LIST = deny, 192.168.1.55, 255.255.255.255

Allow access to packets from the addresses 192.168.3. and 219.211.253., and block all other packets.

ACCESS_LIST = permit, 192.168.3.0, 255.255.255.0
ACCESS_LIST = permit, 219.211.253.0, 255.255.255.0
ACCESS_LIST = deny ,0.0.0.0, 0.0.0.0

Block all Ipv4 and IPv6 address except for localhost.

ACCESS_LIST = deny, 0.0.0.0, 0.0.0.0
ACCESS_LIST = deny, ::1, 1
ACCESS_LIST = deny, fe80::, 1

Describe the IP address which will be inspected in the external file. Block all IP address except for IPv6 address starting with 192.168.3.* and fe80.

permit, 192.168.3.0, 255.255.255.0
permit, fe80::, 16
deny, 0.0.0.0, 0.0.0.0
deny, ::1, 1
deny, fe80::, 1

Limit the number of sessions accessible from the 192.168.3.17 address to 5.

ACCESS_LIST = permit, 192.168.3.17, 255.255.255.255, 5

ACCESS_LIST_FILE

Data Type#

String

Default Value#

None

Attributes#

Read-Only, Single Value

Range#

None

Description#

This property configures the file path when ACCESS_LIST references an external file path. If the file name and path is not precisely configured, the server will not drive. The absolute path should be specified for an external file path. Refer to the description section of the ACCESS_LIST property for the ACCESS_LIST format.

The list described in ACCESS_LIST property is used if this property is not used.

ADMIN_MODE#

Data Type#

Unsigned Integer

Default Value#

0

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

ADMIN_MODE limits the database connection to administrators only.

0: OFF

1: ON

When this property is set to 1, administrator mode is activated, and only the SYS and SYSTEM_ users can connect to the server using the SYSDBA option, and other users will be unable to establish a connection.

This property can be changed using the ALTER SYSTEM statement while Altibase is running.

ARITHMETIC_OPERATION_MODE#

Data Type#

Unsigned Integer

Default Value#

1

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

This property sets the Altibase server to arithmetic operation mode.

0: The server runs in arithmetic operation mode with precision as its priority. The server mainly uses FLOAT or NUMERIC data types to reduce errors from arithmetic operations. The processing speed can be slower than arithmetic operation mode with performance as its priority.

1: The server runs in arithmetic operation mode with performance as its priority. The server mainly uses DOUBLE data types for arithmetic operations to enhance performance; the occurrence of errors is relatively higher.

CHECK_MUTEX_DURATION_TIME_ENABLE#

Data Type#

Unsigned Integer

Default Value#

0

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

This property specifies whether to check MUTEX_DURATION_TIME.

This property can be changed using the ALTER SYSTEM statement while Altibase is running.

0: check disable

1: check enable

COERCE_HOST_VAR_IN_SELECT_LIST_TO_VARCHAR#

Data Type#

Unsigned Integer

Default Value#

0

Attributes#

Read-Only, Single Value

Range#

[0, 32000]

Description#

This property enables host variables to be used in the select target list without CAST operators.

If this property is 1 or greater, the server treats host variables without CAST operators as VARCHAR data types, and the specified value in this property is used as the size (precision) of the VARCHAR data type.

If this property is set to 0, using host variables without CAST operators will cause an error.

DEFAULT_DATE_FORMAT#

Data Type#

String

Default Value#

DD-MON-RRRR

Attributes#

Read-Only, Single Value

Range#

None

Description#

This property sets the default format of DATE type data table columns. If not specified otherwise when SQL statements are executed, DATE type data are input or output according to this setting. This type must specify the formats in which both dates and times are saved. It is also possible to use blanks within double quotation marks, such as "DD MON RRRR".

DEFAULT_DATE_FORMAT = YYYY/MM/DD
iSQL> select sysdate from dual;
SYSDATE
--------------
2008/06/16
1 row selected.

EXEC_DDL_DISABLE#

Data Type#

Unsigned Integer

Default Value#

0

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

Generally, after a database is initially created, DML statements are executed much more frequently than DDL statements. Because DDL statements change existing database schema, they must be executed with caution.

The administrator can thus use this property to prevent the execution of DDL statements. When this property is set to 1, DDL statements cannot be executed while Altibase is running, whereas if it is set to 0, DDL statements can be executed.

This property can be changed using the ALTER SYSTEM statement while Altibase is running.

GROUP_CONCAT_PRECISION#

Data Type#

Unsigned Integer

Default Value#

4000

Attributes#

Read-Write, Single Value

Range#

[0, 32000]

Description#

This property specifies the size of the VARCHAR type that the GROUP_CONCAT function returns.

This property can be modified using the ALTER SYSTEM statement while Altibase is running.

JOB_SCHEDULER_ENABLE#

Data Type#

Unsigned Integer

Default Value#

0

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

This controls the operation of the job scheduler. The job scheduler does not operate if the value of the JOB_THREAD_COUNT property is set to 0, even if the value of this property is set to 1.

0: The job scheduler terminates the job.

1: The job scheduler starts the job the run.

The value of this property can be changed using the ALTER SYSTEM statement while Altibase is running.

JOB_THREAD_COUNT#

Data Type#

Unsigned Integer

Default Value#

0

Attributes#

Read-Only, Single Value

Range#

[0, 128]

Description#

This property specifies the number of threads to be created at server startup for a JOB to run. If the value of this property is 0, threads are not created for the job scheduler.

JOB_THREAD_QUEUE_SIZE#

Data Type#

Unsigned Integer

Default Value#

64

Attributes#

Read-Only, Single Value

Range#

[64, 1024]

Description#

This property specifies the number of queues to be created at server startup for a JOB to run. If the value of this property is large, a larger number of jobs can run in a given amount of time.

MSG_QUEUE_PERMISSION#

Data Type#

Unsigned Integer

Default Value#

0

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

This property sets the permission type of a message queue. The value of this property can be modified by the ALTER SYSTEM statement during ALTIBASE HDB operation

0: (rw-rw-rw 0666) - All users are allowed to read and write, but cannot perform an execution.

1: (rw-r-r 0644) - Only the system owner can read and write, but other users are only allowed to read.

PSM_CASE_SENSITIVE_MODE#

Data Type#

Unsigned Integer

Default Value#

1

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

This property sets whether to use case sensitivity when referring to column names of RECORD and ROWTYPE types or LABEL names in PSM. If set to 0, the behavior is case insensitive, and if set to 1, the behavior is case sensitive. This property can be changed using the ALTER SYSTEM statement while Altibase is running.

PSM_CHAR_DEFAULT_PRECISION#

Data Type#

Unsigned Integer

Default Value#

32000

Attributes#

Read-Only, Single Value

Range#

[1, 65534]

Description#

In case that the size of CHAR type is unspecified in the stored procedures or functions, Altibase determines the specified values in the PSM_CHAR_DEFAULT_PRECISION property as the size of CHAR.

PSM_IGNORE_NO_DATA_FOUND_ERROR#

Data Type#

Unsigned Integer

Default Value#

0

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

The NO_DATA_FOUND exception is one of the system defined exceptions provided by Altibase's PSM. This exception is raised when the "SELECT ~ INTO" statement contained in PSM(stored procedures, functions, triggers) returns no result sets. With the PSM_IGNORE_NO_DATA_FOUND_ERROR property, the user can guard against this exception.

  • 0: When no result set is returned, the NO_DATA_FOUND exception is raised.

  • 1: When no result set is returned, the NO_DATA_FOUND exception is not raised.

This property can be changed using the ALTER SYSTEM statement while Altibase is running.

PSM_NCHAR_UTF16_DEFAULT_PRECISION#

Data Type#

Unsigned Integer

Default Value#

16000

Attributes#

Read-Only, Single Value

Range#

[1, 32766]

Description#

Altibase determines the values specified in the PSM_NCHAR_UTF16_DEFAULT_PRECISION property as the size of NCHAR in the case Altibase character set is UTF16, and the size of NCHAR type is unspecified in parameters or return values when creating stored procedures and functions.

PSM_NCHAR_UTF8_DEFAULT_PRECISION#

Data Type#

Unsigned Integer

Default Value#

10666

Attributes#

Read-Only, Single Value

Range#

[1, 21843]

Description#

In the case the Altibase character set is UTF8, and the NCHAR type size is unspecified in parameters or return values when creating the stored procedures or functions, Altibase determines the specified values in the PSM_CHAR_DEFAULT_PRECISION property as the size of NCHAR.

PSM_NVARCHAR_UTF16_DEFAULT_PRECISION#

Data Type#

Unsigned Integer

Default#

16000

Attributes#

Read-Only, Single Value

Range#

[1, 32766]

Description#

Altibase determines the specified values in the PSM_NCHAR_UTF16_DEFAULT_PRECISION property as the size of NVARCHAR in the case that Altibase character set is UTF16, and the size of NVARCHAR type is not specified in parameters or return values when creating the stored procedures and stored functions.

PSM_NVARCHAR_UTF8_DEFAULT_PRECISION#

Data Type#

Unsigned Integer

Default Value#

10666

Attributes#

Read-Only, Single Value

Range#

[1, 21843]

Description#

In the case the Altibase character set is UTF8 and the NCHAR type size is unspecified in parameters or return values when creating the stored procedures or functions, Altibase determines the specified values in the PSM_NVARCHAR_UTF8_DEFAULT_PRECISION property as the size of NVARCHAR.

PSM_PARAM_AND_RETURN_WITHOUT_PRECISION_ENABLE#

Data Type#

Unsigned Integer

Default Value#

1

Attributes#

Read-Only, Single Value

Range#

[0,1]

Description#

The size of usable data varies depending on the value of this property if the scale of parameter is unspecified when creating the stored procedures or if the data size of parameters and return values is not specified in case of creating stored functions.

If the type of parameter or return values is CHAR, NCHAR, NVARCHAR or VARCHAR, and the property value is 1, the size of data type is determined by the values specified in the following properties; however, if the value is set to 0, the size of data type would be 1.

  • PSM_CHAR_DEFAULT_PRECISION
  • PSM_NCHAR_UTF8_DEFAULT_PRECISION
  • PSM_NCHAR_UTF16_DEFAULT_PRECISION
  • PSM_NVARCHAR_UTF8_DEFAULT_PRECISION
  • PSM_NVARCHAR_UTF16_DEFAULT_PRECISION
  • PSM_PARAM_AND_RETURN_WITHOUT_PRECISION_ENABLE
  • PSM_VARCHAR_DEFAULT_PRECISION

PSM_VARCHAR_DEFAULT_PRECISION#

Data Type#

Unsigned Integer

Default Value#

32000

Attributes#

Read-Only, Single Value

Range#

[1, 65534]

Description#

In case that the size of VARCHAR type is unspecified in the stored procedures or functions, Altibase determines the specified values in the PSM_VARCHAR_DEFAULT_PRECISION property as the size of VARCHAR.

QUERY_STACK_SIZE (Unit: count)#

Data Type#

Unsigned Integer

Default Value#

1024

Range#

Read-Write, Single Value

Range#

[8, 65536]

Description#

This property specifies the size of the stack internally used in the system to process query operations such as comparisons and other operations.

When complicated calculations or stored procedures are used, a stack overflow error may occur. In such cases, the property must be changed to a bigger value.

This parameter must be set according to the application environment. If it is set to a value higher than necessary, memory space will be wasted, so this parameter must be set carefully.

This property can be set in the altibase.properties file, and can be changed using the ALTER SYSTEM or ALTER SESSION statements.

This property can be changed using the ALTER SESSION statement as follows: 

ALTER SESSION SET STACK SIZE = n;

RECURSION_LEVEL_MAXIMUM#

Data Type#

Unsigned Integer

Default Value#

1000

Attributes#

Read-Write, Single Value

Range#

[5, 232-1]

Description#

This property repeatedly executes recursive queries for specified number of times(level).

The value of this property can be modified through ALTER SESSION statement during the Altibase operation.

REGEXP_MODE#

Data Type#

Unsigned Integer

Default Value#

0

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

This is a property that sets the regular expression mode. Each value indicates the following.

  • 0: Altibase regular expression mode.

    POSIX Basic Regular Expression (BRE) and Extended Regular Expression (ERE) are partially supported.

  • 1: PCRE2 compatibility mode.

    Supports the regular expression syntax of the Perl Compatible Regular Expressions (PCRE2) library. This mode can be used when the Altibase server character set is US7ASCII or UTF-8, and there is a difference in syntax from Altibase regular expression mode. For more information, please refer to SQL Reference > Appendix A. Regular Expressions.

REMOTE_SYSDBA_ENABLE#

Data Type#

Unsigned Integer

Default Value#

1

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

This property specifies whether the SYS user can access the database with SYSDBA privileges from a remote location. Its value can be changed using the ALTER SYSTEM statement.

0: Deny remote database access with SYSDBA privileges.

1: Allow remote database access with SYSDBA privileges (default).

SELECT_HEADER_DISPLAY#

Data Type#

Unsigned Integer

Default Value#

1

Attributes#

Read-Write, Single Value

Range#

[0, 1]

Description#

When the results of a SELECT query are output over iSQL, this system property determines whether only the column names are output, or whether the table names are output along with the column names.

This property can be set in the altibase.properties file, and can be changed using the ALTER SYSTEM or ALTER SESSION statements.

If this parameter is set to 0, the table names are displayed along with the column names when the results of SQL statements are output using iSQL

SYS_CONNECT_BY_PATH_PRECISION#

Data Type#

Unsigned Integer

Default Value#

4000

Attributes#

Read-Write, Single Value

Range#

[0, 32000]

Description#

This property specifies the size of the VARCHAR type that the SYS_CONNECT_BY_PATH function returns.

This property can be modified using the ALTER SYSTEM statement while Altibase is running.