Summary of MSQL resources and environment variables

There are four types of resources and environment variables that can be used with the LN MSQL database driver:

The tables provide a summary of each of these types of resources and environment variables. Detailed descriptions of each entry in the tables can be found in Detailed description of driver resources and environment variables.


Client and server resources used by all LN database drivers
Resource name	Environment variable	Description
baan_sql_cache_rows	BAAN_SQL_CACHEROWS	Only applicable to LN Defines the size of internal buffers in the query processor.
baan_sql_trace	BAAN_SQL_TRACE	Only applicable to LN. To view SQL query information.
rds_full	RDS_FULL	Sets maximum number of rows transferred in one block.
tt_sql_trace	TT_SQL_TRACE	Only applicable to Baan IV and Baan 5.0. To view SQL query information.
use_shm_info	USE_SHM_INFO	Not applicable to Baan IV Enables or disables shared memory use.


Client resources used by all LN database drivers
Resource name	Environment variable	Description
baan_sql_stmt_cache_size	BAAN_SQL_STMT_CACHE_SIZE	Only applicable to LN Defines the size of the query cache
bdb_debug	BDB_DEBUG	Sets debugging link between client and server.
bdb_driver	BDB_DRIVER	Sets database specifications.
bdb_use_row_version		Use a row version column to optimize delayed row locking.
bdb_max_server_schedule	BDB_MAX_SERVER_SCHEDULE	Not applicable to Baan IV Defines mechanism for terminating idle database drivers.
ssts_set_rows	SSTS_SET_ROWS	Sets number of rows read ahead.
	USR_DBC_RES	Specifies alternative resource file for client.


Server resources used by all LN database drivers
Resource name	Environment variable	Description
bdb_max_sessions	BDB_MAX_SESSIONS	Defines number of sessions per driver.
bdb_max_session_schedule	BDB_MAX_SESSION_SCHEDULE	Defines mechanism for closing idle driver sessions.
dbslog	DBSLOG	Allows driver profiling.
	DBSLOG_LOCK_PROF	Specifies lock time above which locks are logged.
dbslog_name	DBSLOG_NAME	Allows file name to be specified for logging.
dbsinit		Deprecated.
enable_refmsg	ENABL TABLE_LOAD_ARRAY_SIZE E_REFMSG	Causes logging of denied updates of delete actions.
table_load_array_size	TABLE_LOAD_ARRAY_SIZE	Defines the maximum number of rows inserted during data load.
	USR_DBS_RES	Specifies alternative resource file for server.
max_sql_input_binds	MAX_SQL_INPUT_BINDS	With this variable you can adjust the size of internal ‘where bind’ buffers
mle_join_type	MLE_JOIN_TYPE	Specifies join type between data table and shadow table, with translations, in a Multi Language Enabled (MLE) environment.
query_comments	QUERY_COMMENTS	For tracing of used connections in the database server.


Resources used only by the LN MSQL database driver
Resource name	Environment variable	Description
msql_array_fetch	MSQL_ARRAY_FETCH	Enables array fetching.
msql_array_insert	MSQL_ARRAY_INSERT	Enables array inserts
msql_dsn	MSQL_DSN	Specifies data source to communicate with MSQL. This resource has priority over `msql_obdc_driver`.
	MSQL_DUMP_MESG	Overrides the default log location by specifying the filename where error messages will be written.
msql_join_hint	MSQL_JOIN_HINT	Configures driver to send join hint to SQL Server.
msql_lock_timeout	MSQL_LOCK_TIMEOUT	Specifies a timeout value for SQL statements blocked by locks.
msql_log_warnings	MSQL_LOG_WARNINGS	Configures driver to log warning messages.
msql_max_arrsz	MSQL_MAX_ARRSZ	Adjusts buffer size for array fetch and insert.
msql_network_packetsize	MSQL_NETWORK_PACKETSIZE	Sets the network packet size.
msql_odbc_driver	MSQL_ODBC_DRIVER	Sets a name for the used ODBC driver.
msql_odbc_perf_stat	MSQL_ODBC_PERF_STAT	Starts or stops ODBC’s performance data logging. Windows only, not available on Linux.
	MSQLPROF	Configures profiling.
msql_serverhost	MSQL_SERVERHOST	Specifies host name for MSQL instance.
	MSQLSTAT	Allows statistics to be gathered.
msql_opt_rows	MSQL_OPT_ROWS	Adjusts number of rows retrieved.
msql_retained_cursors	MSQL_RETAINED_CURSORS	Sets number of breaked cursors per driver connection.
msql_odbc_custom_parameters	MSQL_ODBC_CUSTOM_PARAMETERS	Customizable connection String Keywords with Microsoft ODBC driver for Microfoft. ODBC driver SQL Server.