Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

FairCom DB SQL Configuration

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

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 my require other options based on how the product was developed. Consult your application vendor should you have questions about the use of 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 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

TOCIndex