Message Logging Properties#
ALL_MSGLOG_FLUSH#
Data Type#
Unsigned Integer
Default Value#
1
Attributes#
Read-Write, Single Value
Range#
[0, 1]
Description#
If this property is set to 1, all database messages are written immediately to disk, whereas if it is set to 0, Altibase writes the messages all at once at regularly scheduled intervals In order to prevent reduced performance attributable to excessive logging, it is recommended that this value be set to 0 for normal operations, and that it be set to 1 when troubleshooting.
COLLECT_DUMP_INFO#
Data Type#
Unsigned Integer
Default Value#
1
Attributes#
Read-Write, Single Value
Range#
[0, 1]
Description#
This property specifies whether or not information about message files and log files are to be collected when the server terminates abnormally.
0: Information about message files and log files are not collected.
1: Information about message files and log files are collected.
DK_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum number of message files that in the connection process when linking a database.
DK_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_lk.log
Attributes#
Read-Only, Single Value
Range#
None
Description#
This is property specifies a database link file that records message that occur during the connection process.
DK_MSGLOG_FLAG#
Data Type#
Unsigned Integer
Default Value#
6
Attributes#
Read-Write, Single Value
Range#
[0, 232-1]
Description#
Flag value indicating whether warning messages or trace messages generated by the connection process module of the database link are logged to LK_MSGLOG_FILE.
If it is 0, it is not written. If it is greater than 0, it is written.
DK_MSGLOG_SIZE#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum size of the message file of the connect process in the database link.
DUMP_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum number of message files to which debugging information for server errors are written.
DUMP_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_dump.log
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property specifies the name of the message file to which debugging information for server errors is written.
DUMP_MSGLOG_SIZE (Unit: byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the name of the message file to which debugging information for server errors is written.
DUMP_MSGLOG_RESERVE_SIZE (Unit : byte)#
Data type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-only, Single value
Range#
[0, 232-1]
Description#
This property specifies the amount of space to secure in advance on the disk to store the message file in which debugging information is recorded.
ERROR_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum number of message files for server errors.
ERROR_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_error.log
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property specifies the name of the file to which errors raised on the server are written. Also, the process call stack is recorded in this file when Altibase shuts down abnormally.
ERROR_MSGLOG_SIZE (Unit: byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum size, in bytes, of the file to which server error messages are stored.
ERROR_MSGLOG_RESERVE_SIZE (Unit : byte)#
Data type#
Unsigned Integer
Default value#
10 * 1024 * 1024
Attributes#
Read-Only, Single value
Range#
[0, 232-1]
Description#
This property specifies the amount of space to be reserved in advance for the file where the server error message is stored.
LB_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum number of message files about service thread.
LB_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_lb.log
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property is the file to which service thread-related message are written.
LB_MSGLOG_FLAG#
Data Type#
Unsigned Integer
Default Value#
1
Attributes#
Read-Write, Single Value
Range#
[0, 232-1]
Description#
This property specifies the message of service thread to be written to LB_MSGLOG_FILE as follows.
0: not record
1: Creation and release of the service thread
2: Log for the service thread moved to task
3: (1+2) Creation and release of the service thread, log for the service thread moved to task
LB_MSGLOG_SIZE#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum size of the file to which service thread are written.
MM_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This sets the maximum number of message files for the Main module.
MM_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_mm.log
Attributes#
Read Only, Single Value
Range#
None
Description#
This property specifies the file in which to write messages that arise during Main module processing.
MM_MSGLOG_RESERVE_SIZE (Unit : byte)#
Data type#
Unsigned Integer
Default value#
10 * 1024 * 1024
Attributes#
Read-Only, Single value
Range#
[0, 232-1]
Description#
This property specifies the amount of space to reserve on the disk in advance to store the message file for the main module.
MM_MSGLOG_SIZE (Unit: byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property sets the maximum size of the Main module message files.
MM_SESSION_LOGGING#
Data Type#
Unsigned Integer
Default#
0
Attributes#
Read-Write, Single Value
Range#
[0, 1]
Description#
This is a flag value that indicates whether to write session information regarding all database logon and logoff events to MM_MSGLOG_FILE. Session information includes session ID, user name, IP address, client program PID and other details about the client program.
If this property is set to 0, no messages are written, whereas if it is set to 1, the messages are written.
NETWORK_ERROR_LOG#
Data Type#
Unsigned Integer
Default Value#
1
Attributes#
Read-Write, Single Value
Range#
[0, 1]
Description#
This property specifies whether to write network-related error messages in the server message file.
In an unstable network environment, in which error messages are frequently output, setting this value to 0 prevents network-related error messages from being output.
QP_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property sets the maximum number of message log files for the Query Processor.
QP_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_qp.log
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property specifies the name of the file in which to write messages when processing queries.
QP_MSGLOG_FLAG#
Data Type#
Unsigned Integer
Default Value#
2
Attributes#
Read-Write, Single Value
Range#
[0, 232-1]
Description#
This is a flag value that indicates whether to write trace messages generated by the Query Processor in QP_MSGLOG_FILE.
If this property is set to 0, the messages are not written, whereas if it is set to a value greater than 0, the messages are written.
QP_MSGLOG_RESERVE_SIZE (Unit : byte)#
Data type#
Unsigned Integer
Default value#
10 * 1024 * 1024
Attributes#
Read-Only, Single value
Range#
[0, 232-1]
Description#
This property specifies the amount of space to be reserved on disk to store the message file of the query processor.
QP_MSGLOG_SIZE (Unit: byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum size, in bytes, of the Query Processor message log files.
QUERY_PROF_FLAG#
Data Type#
Integer
Default Value#
0
Attributes#
Read-Write, Single Value
Range#
[0, 26-1]
Description#
This property enables information about the work being conducted by a server and the overall state of the server to be written to a file for later analysis. The user can specify that information is written as desired by suitably combining the following values:
- 0 : Write nothing
- 1: Every time a SQL statement is executed, write the executed SQL statement, execution time, execution information, and information about index and disk access. The value for the TIMED_STATISTICS property must be set to 1 to print the proper execution time.
- 2: Every time a SQL statement is executed, write the BIND parameter(s).
- 4: Every time a SQL statement is executed, write the execution plan.
- 8: Write session information (i.e. the data in V$SESSTAT) every 3 seconds.
- 16: Write system information (i.e. the data in V$SYSSTAT) every 3 seconds.
- 32: Write information about memory (i.e. the data in V$SYSSTAT) every 3 seconds.
For example, if this property is set to 1+4+32=37, then whenever a SQL statement is executed, the execution information and execution plan for the SQL statement is written, and additionally, information about memory is written every 3 seconds.
This file can be converted to a form suitable for analysis using the altiprofile utility. For more information, please refer to the Utilities Manual > Chapter 5. Other Utilities > altiProfile.
This property can be changed using the ALTER SYSTEM statement while Altibase is running.
QUERY_PROF_LOG_DIR#
Data Type#
String
Default Value#
$ALTIBASE_HOME/trc
Attributes#
Read-Write, Single Value
Range#
[1, 1024 ]
Description#
This property specifies the directory path in which files to which status information of the Altibase server and operations executed on it are written are to be saved.
The value of this property can be changed using the ALTER SYSTEM statement while Altibase is running.
RP_CONFLICT_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default#
10
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum number of files to which the trace log is written in the event of a replication conflict.
RP_CONFLICT_MSGLOG_DIR#
Data Type#
String
Default#
$ALTIBASE_HOME/trc
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property specifies the directory for the file to which the trace log is written in the event of a replication conflict.
RP_CONFLICT_MSGLOG_ENABLE#
Data Type#
Unsigned Integer
Default Value#
1
Attributes#
Read-Only, Single Value
Range#
[0, 1]
Description#
This property specifies whether or not the trace log of a replication conflict is to be written.
RP_CONFLICT_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_rp_conflict.log
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property specifies the file to which the trace log of a replication conflict is written.
RP_CONFLICT_MSGLOG_FLAG#
Data Type#
Unsigned Integer
Default Value#
6
Attributes#
Read-Write, Single Value
Range#
[0, 232 -1]
Description#
This property specifies the logging level of the trace log of a replication conflict.
The following values are available for specification:
2: Writes conflict messages
4: Writes SQL statements that cause conflict
6: Write both conflict messages and SQL statements that cause conflict
RP_CONFLICT_MSGLOG_RESERVE_SIZE (Unit : byte)#
Data type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single value
Range#
[0, 232-1]
Description#
This property specifies the amount of space to be reserved on disk for storing the trace log file for a replication collision.
RP_CONFLICT_MSGLOG_SIZE (Unit: bytes)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum size, in bytes, of replication conflict trace logs.
RP_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum number of replication message log files.
RP_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_rp.log
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property specifies the name of the file in which to write messages output from the Replication Manager.
RP_MSGLOG_FLAG#
Data Type#
Unsigned Integer
Default Value#
0
Attributes#
Read-Write, Single Value
Range#
[0, 232-1]
Description#
This is a flag value that indicates whether to write trace messages generated by the Replication Manager module in RP_MSGLOG_FILE.
If this property is set to 0, no messages are written, whereas if it is set to a value greater than 0, the messages are written.
RP_MSGLOG_RESERVER_SIZE (Unit: byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Write, Single Value
Range#
[0, 232-1]
Description#
This property specifies the amount of space to be reserved on the disk for storage of the replication message file.
RP_MSGLOG_SIZE (Unit: byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum size, in bytes, of the replication message log file.
SERVER_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum number of server message log files.
SERVER_MSGLOG_DIR#
Data Type#
String
Default Value#
$ALTIBASE_HOME/trc
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property specifies the path in which altibase.lock, which is an internally used server maintenance file, and SERVER_MSGLOG_FILE, which is the server module message file in which information about the server startup, shutdown etc. is written, are located.
This directory can also serve as the default directory for individual server modules' message files, such as SM_MSGLOG_FILE, QP_MSGLOG_FILE, RP_MSGLOG_FILE and the like.
SERVER_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_boot.log
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property specifies the file name for messages left by the server module.
Messages pertaining to Altibase startup, warnings, and abnormal termination are written to the server message log file.
SERVER_MSGLOG_FLAG#
Data Type#
Unsigned Integer
Default Value#
7
Attributes#
Read-Write, Single Value
Range#
[0, 232-1]
Description#
This is a flag value that indicates whether to write trace messages generated by the server module in SERVER_MSGLOG_FILE.
If this property is set to 0, no messages are written, whereas if it is set to a value greater than 0, the messages are written.
SERVER_MSGLOG_RESERVE_SIZE (Unit : byte)#
Data type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the amount of space to be reserved on the disk for storage of the server message file.
SERVER_MSGLOG_SIZE (Unit: byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum size, in bytes, of server message log files.
SM_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum number of Storage Manager message log files.
SM_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_sm.log
Attributes#
Read Only, Single Value
Range#
None
Description#
This property specifies the prefix of the name of the message file(s) in which the Storage Manager writes messages.
SM_MSGLOG_FLAG#
Data Type#
Unsigned Integer
Default Value#
2147483647
Attributes#
Read-Write, Single Value
Range#
[0, 232-1]
Description#
This is a flag value that indicates whether to write trace messages generated by the Storage Manager module in the file(s) specified in SM_MSGLOG_FILE.
If this property is set to 0, no messages are written, whereas if it is set to a value greater than 0, the messages are written.
SM_MSGLOG_RESERVE_SIZE (Unit : byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single value
Range#
[0, 232-1]
Description#
This property specifies the amount of space to be reserved on the disk to store the message file of the storage manager.
SM_MSGLOG_SIZE (Unit: byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum size, in bytes, of the Storage Manager message log files.
TRC_MSGLOG_RESERVE_SIZE (Unit : byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the size in advance to secure the space of the trace log file on the disk where warning messages, etc., generated when starting the server can be recorded.
TRCLOG_DETAIL_PREDICATE#
Data Type#
Unsigned Integer
Default Value#
0
Attributes#
Read-Write, Single Value
Range#
[0, 1]
Description#
When Explain Plan mode is being used in iSQL, this property specifies whether to display the status of a predicate portion of a WHERE clause. To use this trace log, set this parameter to 1.
This property can be changed using the ALTER SYSTEM statement while Altibase is running.
XA_MSGLOG_COUNT#
Data Type#
Unsigned Integer
Default Value#
10
Attributes#
Read Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum number of XA message files used by the server.
XA_MSGLOG_FILE#
Data Type#
String
Default Value#
altibase_xa.log
Attributes#
Read-Only, Single Value
Range#
None
Description#
This property specifies the prefix of the name of the file(s) in which XA message logs from the server are written.
XA_MSGLOG_FLAG#
Data Type#
Unsigned Integer
Default Value#
0
Attributes#
Read-Write, Single Value
Range#
[0, 3]
Description#
This property determines which of the server XA messages to write to disk. The possible values are as follows:
0: Write only critical XA-related messages
1: Write messages pertaining to XA calls
2: Write messages when XIDs are allocated, freed, etc.
3: Write all message logs related to XA
XA_MSGLOG_RESERVE_SIZE (Unit : byte)#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read-Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the amount to space to be reserved in advance for storage of the XA message file for the server.
XA_MSGLOG_SIZE#
Data Type#
Unsigned Integer
Default Value#
10 * 1024 * 1024
Attributes#
Read Only, Single Value
Range#
[0, 232-1]
Description#
This property specifies the maximum size of XA message files used by the server.