SQL Operations Guide

FairCom DB SQL Configuration

This chapter explains the keywords provided for configuring FairCom DB SQL.

These keywords can be added in ctsrvr.cfg.

FairCom DB SQL Configuration Keywords

FairCom DB SQL is generally configured with standard FairCom DB configuration options, (cache sizes, transaction logging, etc.). Specific configurations are available in FairCom DB SQL for additional SQL operational parameters and performance tuning. Only a few of these are considered for routine use. For example,

SQL_PORT

SETENV TPE_DFLT_DATE

SQL_LOGFILE (SQL_LOGFILE, SQL_LOGFILE)

SETENV JAVA_COMPILER

SETENV CLASSPATH

SETENV JVM_LIB

Your application may require other options based on how the product was developed. Consult your application vendor if you have questions about other options. The FairCom support team is always available to help guide the most applicable configurations and usage.

In This Chapter MAX_SQL_ISOLATION_LEVEL SQL_CONNECT_TIMEOUT_SEC SQL_DATABASE SQL_IDLE_WAKE SQL_KEEP_OPEN_TABLES SQL_LOGFILE SQL_MIN_CARD SQL_PARTOPEN_COST SQL_PORT SQL_TRACE_CTREE_ERROR SESSION_TIMEOUT SETENV CLASSPATH SETENV DEBUG_JVM SETENV DEBUG_JVM_PORT SETENV DH_CACHED_STATEMENTS SETENV DH_DO_AHEAD SETENV DH_DYN_CACHED_STATEMENTS SETENV DH_ENABLE_POOL SETENV DH_JVM_OPTION_STRINGS SETENV DH_ENABLE_POOL SETENV DH_OPT_OR_CARD SETENV DH_POOL_SIZE SETENV DH_REBUILD_SEL_CUTOFF SETENV DH_THREAD_STACK_SZ_KB SETENV DH_SVR_DA_BUFFER SETENV JAVA_COMPILER SETENV JVM_LIB SETENV TPESQLDBG SETENV TPE_DFLT_DATE SETENV TPE_LOG SETENV TPE_MM_CACHESIZE SETENV TPE_MM_COMPARE_OVHD SETENV TPE_MM_INSERT_OVHD SETENV TPE_MM_SWAPSIZE SETENV TPE_TMPDIR SQL_OPTION CHECK_HEAP SQL_OPTION BADDATES_ASNULL SQL_OPTION BADTIMES_ASNULL SQL_OPTION CTSTRING_VARCHAR SQL_OPTION CREATE_WITH_ROWID SQL_OPTION CREATE_WITH_RECBYT SQL_OPTION CTDB_ROWID SQL_OPTION DB_CASE_INSENSITIVE SQL_OPTION DROP_TABLE_DICTIONARY_ONLY SQL_OPTION FORCE_TEMPLATE_DB SQL_OPTION HOT_ALTER_TABLE SQL_OPTION HM_ACTIVE SQL_OPTION LOAD_CALLBACK_LIB SQL_OPTION NO_AUTO_ABORT SQL_OPTION NO_BINARY_PAD SQL_OPTION NO_CARDINALITY SQL_OPTION NO_COSTS SQL_OPTION NO_CRYPT_SYSTBL SQL_OPTION NO_DB_CONVERSION SQL_OPTION NO_DUP_IDXNAME SQL_OPTION NO_HUGEFILE SQL_OPTION NO_IPV6 SQL_OPTION NO_PUSHDOWN SQL_OPTION NO_REVERSE_INDEX SQL_OPTION NO_SELECTIVITY SQL_OPTION NO_SHARED_MEMORY SQL_OPTION NO_SYSSUPERFILE SQL_OPTION NO_TCPIP SQL_OPTION OLD_DELFLD_LEN SQL_OPTION OWNER_FILE_NAMES SQL_OPTION PAD_WITH_NULL SQL_OPTION PARTIAL_SEG SQL_OPTION PID_IN_NODEID SQL_OPTION PRESERVE_CURSOR_FREE_LOCK SQL_OPTION SUPPRESS_JVM_LOAD_ERR SQL_OPTION USE_MM SQL_DEBUG ABORT_ON_PANIC SQL_DEBUG ERROR_INFO SQL_DEBUG INDEX SQL_DEBUG INDEX_SEL SQL_DEBUG INDEX_DEF_SEL SQL_DEBUG INDEX_INFO SQL_DEBUG LOG_STUBS_HIGH SQL_DEBUG LOG_STUBS_MED SQL_DEBUG LOG_STUBS_LOW SQL_DEBUG LOG_STMT SQL_DEBUG LOG_STMT_TIMES SQL_DEBUG LOG_STMT_TIMES_FETCH SQL_DEBUG TRACE_ON_PANIC SQL_SERVER_LOG_SIZE SQL_SESSION_TIMEOUT SUBSYSTEM SQL LATTE SYSLOG