Reference Manual
   CHAPTER 5. Database Options     

General database options

This section lists all database options.

OPTION	VALUES	DEFAULT
AUDITING option	ON, OFF	OFF
BACKGROUND_PRIORITY option	ON, OFF	OFF
BLOCKING option	ON, OFF	ON
CHECKPOINT_TIME option	number of minutes	60
COOPERATIVE_COMMITS option	ON, OFF	ON
COOPERATIVE_COMMIT_TIMEOUT option	integer	250
DATE_FORMAT option	string	'YYYY-MM-DD'
DATE_ORDER option	'YMD', 'DMY', 'MDY'	'YMD'
DEFAULT_TIMESTAMP_INCREMENT option	integer	1
DELAYED_COMMITS option	ON, OFF	OFF
DELAYED_COMMIT_TIMEOUT option	integer	500
ISOLATION_LEVEL option	0, 1, 2, 3	0
JAVA_HEAP_SIZE option	number of bytes	2000000
JAVA_NAMESPACE_SIZE option	number of bytes	4000000
LOGIN_MODE option	STANDARD, MIXED, INTEGRATED	STANDARD
LOGIN_PROCEDURE option	string	sp_login_environment
MAX_CURSOR_COUNT option	Integer	50
MAX_STATEMENT_COUNT option	Integer	50
MIN_PASSWORD_LENGTH option	Integer	0
PRECISION option	number of digits	30
PREFETCH option	ON, OFF	ON
RECOVERY_TIME option	number of minutes	2
ROW_COUNTS option	ON, OFF	OFF
SCALE option	number of digits	6
THREAD_COUNT option	number of threads	0
TIME_FORMAT option	string	'HH:NN:ss.SSS'
TIMESTAMP_FORMAT option	string	'YYYY-MM-DD HH:NN:ss.SSS'
WAIT_FOR_COMMIT option	ON, OFF	OFF