dm.ini参考
#DaMeng Database Server Configuration file#this is comments
#file location of dm.ctl
CTL_PATH = /app/dm/data/zhyu/DAMENG/dm.ctl #ctl file path
CTL_BAK_PATH = /app/dm/data/zhyu/DAMENG/ctl_bak #dm.ctl backup path
CTL_BAK_NUM = 10 #backup number of dm.ctl, allowed to keep one more backup file besides specified number.
SYSTEM_PATH = /app/dm/data/zhyu/DAMENG #system path
CONFIG_PATH = /app/dm/data/zhyu/DAMENG #config path
TEMP_PATH = /app/dm/data/zhyu/DAMENG #temporary file path
BAK_PATH = /app/dm/data/zhyu/DAMENG/bak #backup file path
BAK_POLICY = 0 #Which backup policy can be selected? 0:both old and new,1:only old,2:only new.default is 0.
#instance name
INSTANCE_NAME = ZHYU #Instance name
#memory pool and buffer
MAX_OS_MEMORY =95 #Maximum Percent Of OS Memory
MEMORY_POOL =159 #Memory Pool Size In Megabyte
MEMORY_TARGET =0 #Memory Share Pool Target Size In Megabyte
MEMORY_EXTENT_SIZE =1 #Memory Extent Size In Megabyte
MEMORY_LEAK_CHECK =0 #Memory Pool Leak Checking Flag
MEMORY_MAGIC_CHECK =2 #Memory Pool Magic Checking Flag
MEMORY_BAK_POOL =4 #Memory Backup Pool Size In Megabyte
HUGE_MEMORY_THRESHOLD =0 #Threshold Value in Kilobytes for memory that can be allocated from HUGE pool
HUGE_MEMORY_PERCENTAGE =50 #Maximum percent of HUGE buffer that can be allocated to work as common memory pool
HUGE_BUFFER =8 #Initial Huge Buffer Size In Megabytes
BUFFER =1330 #Initial System Buffer Size In Megabytes
BUFFER_POOLS =19 #number of buffer pools
FAST_POOL_PAGES =3000 #number of pages for fast pool
FAST_ROLL_PAGES =1000 #number of pages for fast roll pages
KEEP =8 #system KEEP buffer size in Megabytes
RECYCLE =319 #system RECYCLE buffer size in Megabytes
RECYCLE_POOLS =19 #Number of recycle buffer pools
ROLLSEG =64 #system ROLLSEG buffer size in Megabytes
ROLLSEG_POOLS =19 #Number of rollseg buffer pools
MULTI_PAGE_GET_NUM =1 #Maximum number of pages for each read of buffer
SORT_BUF_SIZE =50 #maximum sort buffer size in Megabytes
SORT_BLK_SIZE =1 #maximum sort blk size in Megabytes
SORT_BUF_GLOBAL_SIZE =1000 #maximum global sort buffer size in Megabytes
SORT_FLAG =0 #choose method of sort
HAGR_HASH_SIZE =100000 #hash table size for hagr
HJ_BUF_GLOBAL_SIZE =500 #maximum hash buffer size for all hash join in Megabytes
HJ_BUF_SIZE =50 #maximum hash buffer size for single hash join in Megabytes
HJ_BLK_SIZE =1 #hash buffer size allocated each time for hash join in Megabytes
HAGR_BUF_GLOBAL_SIZE =500 #maximum buffer size for all hagr in Megabytes
HAGR_BUF_SIZE =50 #maximum buffer size for single hagr in Megabytes
HAGR_BLK_SIZE =1 #buffer size allocated each time for hagr in Megabytes
MTAB_MEM_SIZE =8 #memory table size in Kilobytes
FTAB_MEM_SIZE =0 #file table package size in Kilobytes
MMT_GLOBAL_SIZE =4000 #memory map table global size in megabytes
MMT_SIZE =0 #memory map table size in megabytes
MMT_FLAG =1 #ways of storing bdta data in memory map table
DICT_BUF_SIZE =5 #dictionary buffer size in Megabytes
HFS_CACHE_SIZE =160 #hfs cache size in Megabytes, used in huge horizon table for insert, update,delete
VM_STACK_SIZE =256 #VM stack size in Kilobytes
VM_POOL_SIZE =64 #VM pool size in Kilobytes
VM_POOL_TARGET =32768 #VM pool target size in Kilobytes
SESS_POOL_SIZE =64 #session pool size in Kilobytes
SESS_POOL_TARGET =32768 #session pool target size in Kilobytes
RT_HEAP_TARGET =8192 #runtime heap target size in Kilobytes
VM_MEM_HEAP =0 #Whether to allocate memory to VM from HEAP
RFIL_RECV_BUF_SIZE =16 #redo file recover buffer size in Megabytes
N_MEM_POOLS =1 #number of memory pools
COLDATA_POOL_SIZE =0 #coldata pool size for each worker group
HAGR_DISTINCT_HASH_TABLE_SIZE =10000 #Size of hagr distinct hash table
CNNTB_HASH_TABLE_SIZE =100 #Size of hash table in connect-by operation
GLOBAL_RTREE_BUF_SIZE =100 #The total size of buffer for rtree
SINGLE_RTREE_BUF_SIZE =10 #The size of buffer for single rtree
SORT_OPT_SIZE =0 #once max memory size of radix sort assist count array
#thread
WORKER_THREADS =16 #Number Of Worker Threads
TASK_THREADS =16 #Number Of Task Threads
UTHR_FLAG =0 #User Thread Flag
FAST_RW_LOCK =1 #Fast Read Write Lock flag
SPIN_TIME =4000 #Spin Time For Threads In Microseconds
WORK_THRD_STACK_SIZE =1024 #Worker Thread Stack Size In Kilobytes
WORKER_CPU_PERCENT =0 #Percent of CPU number special for worker thread
NESTED_C_STYLE_COMMENT =0 #flag for C stype nested comment
#query
USE_PLN_POOL =1 #Query Plan Reuse Mode, 0: Forbidden; 1:strictly reuse, 2:parsing reuse, 3:mixed parsing reuse
DYN_SQL_CAN_CACHE =1 #Dynamic SQL cache mode. 0: Forbidden; 1: Allowed if the USE_PLN_POOL is non-zero;
RS_CAN_CACHE =0 #Resultset cache mode. 0: Forbidden; 1: Allowed only if the USE_PLN_POOL is non-zero;
RS_CACHE_TABLES = #Tables allowed to enable result set cache
RS_CACHE_MIN_TIME =0 #Least time for resultset to be cached
RS_BDTA_FLAG =0 #Resultset mode. 0: row; 2: bdta;
RS_BDTA_BUF_SIZE =32 #Maximum size of message in Kilobytes for BDTA cursor, it's valid only if RS_BDTA_FLAG is set to 2
RESULT_SET_LIMIT =10000 #Maximum Number Ofcached Resultsets
RESULT_SET_FOR_QUERY =0 #Whether to generate result set for non-query statement
SESSION_RESULT_SET_LIMIT =10000 #Maximum number of cached result sets for each session, 0 means unlimited
BUILD_FORWARD_RS =0 #Whether to generate result set for forward only cursor
MAX_OPT_N_TABLES =6 #Maximum Number Of Tables For Query Optimization
CNNTB_MAX_LEVEL =20000 #Maximum Level Of Hierarchical Query
CTE_MAXRECURSION =100 #Maximum recursive Level Of Common Expression Table
CTE_OPT_FLAG =1 #Optimize recursive with, 0: false, 1: convert refed subquery to invocation
BATCH_PARAM_OPT =0 #optimize flag for DML with batch binded params
CLT_CONST_TO_PARAM =0 #Whether to convert constant to parameter
LIKE_OPT_FLAG =7 #the optimized flag of LIKE expression
FILTER_PUSH_DOWN =0 #whether push down filter to base table
USE_MCLCT =2 #mclct use flag for replace mgat
PHF_NTTS_OPT =1 #phf ntts opt flag
MPP_MOTION_SYNC =200 #mpp motion sync check number
UPD_DEL_OPT =2 #update&delete opt flag, 0: false, 1: opt, 2: opt & ntts opt
ENABLE_INJECT_HINT =0 #enable inject hint
FETCH_PACKAGE_SIZE =512 #command fetch package size
ENABLE_DIST_IN_SUBQUERY_OPT =0 #Whether to enable in-subquery optimization
MAX_OPT_N_OR_BEXPS =7 #maximum number of OR bool expressions for query optimization
USE_HAGR_FLAG =0 #Whether to use HAGR operator when can't use SAGR operator
DTABLE_PULLUP_FLAG =1 #the flag of pulling up derived table
VIEW_PULLUP_FLAG =0 #the flag of pulling up view
GROUP_OPT_FLAG =0 #the flag of opt group
HAGR_PARALLEL_OPT_FLAG =0 #the flag of opt hagr in mpp or parallel
HAGR_DISTINCT_OPT_FLAG =0 #the flag of opt hagr distinct in mpp
REFED_EXISTS_OPT_FLAG =1 #Whether to optimize correlated exists-subquery into non-correlated in-subquery
REFED_OPS_SUBQUERY_OPT_FLAG =0 #Whether to optimize correlated op all/some/all-subquery into exists-subquery
HASH_PLL_OPT_FLAG =0 #the flag of cutting partitioned table when used hash join
PARTIAL_JOIN_EVALUATION_FLAG =1 #Whether to convert join type when upper operator is DISTINCT
MOTION_OPT_FLAG =0 #optimizer ways under new motion
USE_FK_REMOVE_TABLES_FLAG =1 #Whether to remove redundant join by taking advantage of foreign key constraint
USE_FJ_REMOVE_TABLE_FLAG =0 #Whether to remove redundant join by taking advantage of filter joining
SLCT_ERR_PROCESS_FLAG =0 #How to handle error when processing single row
MPP_HASH_LR_RATE =10 #The ratio of left child's cost to right child's cost of hash join in MPP environment that can influence the execution plan
LPQ_HASH_LR_RATE =30 #The ratio of left child's cost to right child's cost of hash join in LPQ environment that can influence the execution plan
SEL_ITEM_HTAB_FLAG =0 #Whether to use HTAB operator for correlated subquery in select items
OR_CVT_HTAB_FLAG =1 #Whether to use HTAB operator to optimizer or-expression
ENHANCED_SUBQ_MERGING =0 #Whether to use merging subquery opt
CASE_WHEN_CVT_IFUN =1 #Flag of converting subquery in case-when expression to IF operator
OR_NBEXP_CVT_CASE_WHEN_FLAG =0 #Whether to convert or-expression to case-when expression
NONCONST_OR_CVT_IN_LST_FLAG =0 #Whether to convert nonconst or-expression to in lst expression
OUTER_CVT_INNER_PULL_UP_COND_FLAG=1 #Whether to pull up join condition when outer join converts to inner join
OPT_OR_FOR_HUGE_TABLE_FLAG =0 #Whether to use HFSEK to optimize or-expression for HUGE table
ORDER_BY_NULLS_FLAG =0 #Whether to place NULL values to the end of the result set when in ascending order
SUBQ_CVT_SPL_FLAG =1 #Flag of indicating how to convert correlated subquery
ENABLE_RQ_TO_SPL =1 #Whether to convert correlated subquery to SPOOL
MULTI_IN_CVT_EXISTS =0 #Whether to convert multi-column-in subquery to exists subquery
PRJT_REPLACE_NPAR =1 #Whether to replace NPAR tree in NSEL after projection
ENABLE_RQ_TO_INV =0 #Whether to convert correlated subquery to temporary function
SUBQ_EXP_CVT_FLAG =0 #whether convert refered subquery exp to non-refered subquery exp
USE_REFER_TAB_ONLY =0 #Whether to pull down correlated table only when dealing with correlated subquery
REFED_SUBQ_CROSS_FLAG =1 #Whether to replace hash join with cross join for correlated subquery
IN_LIST_AS_JOIN_KEY =0 #Whether to use in-list expression as join key
OUTER_JOIN_FLATING_FLAG =0 #Flag of indicating whether outer join will be flattened
TOP_ORDER_OPT_FLAG =0 #The flag of optimizing the query with the top cluase and the order by clause
PLACE_GROUP_BY_FLAG =0 #The flag of optimizing the query with group_by and sfun by clause
TOP_DIS_HASH_FLAG =1 #Flag of disable hash join in TOP-N query
ENABLE_RQ_TO_NONREF_SPL =0 #Whether to convert correlated query to non-correlated query
OPTIMIZER_MODE =1 #Optimizer_mode
NEW_MOTION =0 #New Motion
LDIS_NEW_FOLD_FUN =0 #ldis use different fold fun with mdis
DYNAMIC_CALC_NODES =0 #different nodes of npln use different nubmer of calc sizes/threads
OPTIMIZER_MAX_PERM =7200 #Optimizer_max permutations
ENABLE_INDEX_FILTER =0 #enable index filter
OPTIMIZER_DYNAMIC_SAMPLING =0 #Dynamic sampling level
NONREFED_SUBQUERY_AS_CONST =0 #Whether to convert non-correlated subquery to const
HASH_CMP_OPT_FLAG =0 #Flag of operators that enable optimization with static hash table
OUTER_OPT_NLO_FLAG =0 #Flag of enable index join for those whose right child is not base table
DISTINCT_USE_INDEX_SKIP =2 #Distinct whether to use index skip scan
USE_INDEX_SKIP_SCAN =0 #Whether to use index skip scan
INDEX_SKIP_SCAN_RATE =0.003 #Rate in index skip scan
SPEED_SEMI_JOIN_PLAN =1 #Flag of speeding up the generating process of semi join plan
COMPLEX_VIEW_MERGING =0 #Flag of merging complex view into query without complex view
HLSM_FLAG =1 #Choose one method to realize hlsm operator
DEL_HP_OPT_FLAG =0 #Optimize delete for horization partition table
OPTIMIZER_OR_NBEXP =0 #Flag of or-expression optimization method
CNNTB_OPT_FLAG =0 #Optimize hierarchical query
ADAPTIVE_NPLN_FLAG =3 #Adaptive npln
MULTI_UPD_OPT_FLAG =0 #Optimize multi column update
MULTI_UPD_MAX_COL_NUM =128 #Max value of column counts when optimize multi column update
ENHANCE_BIND_PEEKING =0 #Enhanced bind peeking
NBEXP_OPT_FLAG =3 #Whether to enable optimization for bool expressions
HAGR_HASH_ALGORITHM_FLAG =0 #HAGR hash algorithm choice
DIST_HASH_ALGORITHM_FLAG =0 #Distinct hash algorithm choice
UNPIVOT_ORDER_FLAG =0 #Whether to sort the result of UNPIVOT operator by columns that don't appear in the UNPIVOT sub-sentence
VIEW_FILTER_MERGING =2 #Flag of merging view filter
ENABLE_PARTITION_WISE_OPT =0 #whether enable partition-wise optimization
OPT_MEM_CHECK =0 #reduce search space when out of memory
ENABLE_JOIN_FACTORIZATION =0 #Whether to enable join factorization
EXPLAIN_SHOW_FACTOR =1 #factor of explain
ERROR_COMPATIBLE_FLAG =0 #enable/disable specified errors to be compatible with previous version
ENABLE_NEST_LOOP_JOIN_CACHE =0 #whether enable cache temporary result of nest loop join child
#checkpoint
CKPT_RLOG_SIZE = 100 #Checkpoint Rlog Size, 0: Ingore; else: Generate With Redo Log Size
CKPT_DIRTY_PAGES = 10000 #Checkpoint Dirty Pages, 0: Ingore; else: Generate With Dirty Pages
CKPT_INTERVAL = 300 #Checkpoint Interval In Seconds
CKPT_FLUSH_RATE =5.00 #Checkpoint Flush Rate(0.0-100.0)
CKPT_FLUSH_PAGES =1000 #Minimum number of flushed pages for checkpoints
CKPT_WAIT_PAGES =128 #Maximum number of pages flushed for checkpoints
FORCE_FLUSH_PAGES =8 #number of periodic flushed pages
#IO
DIRECT_IO =0 #Flag For Io Mode(Non-Windows Only), 0: Using File System Cache; 1: Without Using File System Cache
IO_THR_GROUPS =2 #The Number Of Io Thread Groups(Non-Windows Only)
HIO_THR_GROUPS =2 #The Number Of Huge Io Thread Groups(Non-Windows Only)
FAST_EXTEND_WITH_DS =1 #How To Extend File's Size (Non-Windows Only), 0: Extend File With Hole; 1: Extend File With Disk Space
#database
MAX_SESSIONS =100 #Maximum number of concurrent sessions
MAX_CONCURRENT_TRX =0 #Maximum number of concurrent transactions
CONCURRENT_TRX_MODE =0 #Concurrent transactions mode
TRX_VIEW_SIZE =512 #The buffer size of local transaction ids in TRX_VIEW
MAX_SESSION_STATEMENT =20000 #Maximum number of statement handles for each session
MAX_CONCURRENT_OLAP_QUERY =0 #Maximum number of concurrent OLAP queries
BIG_TABLE_THRESHHOLD =1000 #Threshhold value of a big table in 10k
MAX_EP_SITES =64 #Maximum number of EP sites for MPP
PORT_NUM =5236 #Port number on which the database server will listen
FAST_LOGIN =0 #Whether to log information without login
DDL_AUTO_COMMIT =1 #ddl auto commit mode, 0: not auto commit; 1: auto commit
COMPRESS_MODE =0 #Default Compress Mode For Tables That Users Created, 0: Not Compress; 1: Compress
PK_WITH_CLUSTER =1 #Default Flag For Primary Key With Cluster, 0: Non-Cluster; 1: Cluster
EXPR_N_LEVEL =200 #Maximum nesting levels for expression
N_PARSE_LEVEL =100 #Maximum nesting levels for parsing object
MAX_SQL_LEVEL =500 #Maximum nesting levels of VM stack frame for sql
BDTA_SIZE =1000 #batch data processing size.SIZE OF BDTA(1-10000)
OLAP_FLAG =0 #OLAP FLAG, 1 means enable olap
JOIN_HASH_SIZE =500000 #the hash table size for hash join
HFILES_OPENED =256 #maximum number of files can be opened at the same time for huge table
FAST_COMMIT =0 #0 or 1 means normal commit; other may speed up commit, but may not assure ACID
ISO_IGNORE =0 #ignore isolation level flag
TEMP_SIZE =10 #temporary file sizein Megabytes
TEMP_SPACE_LIMIT =0 #temp space limit in megabytes
FILE_TRACE =0 #Whether to log operations of database files
COMM_TRACE =1 #Whether to log warning information of communication
CACHE_POOL_SIZE =20 #SQL buffer size in megabytes
PLN_DICT_HASH_THRESHOLD =20 #Threshold in megabytes for plan dictionary hash table creating
STAT_COLLECT_SIZE =10000 #minimum collect size in rows for statistics
STAT_ALL =0 #if collect all the sub-tables of a partition table
PHC_MODE_ENFORCE =0 #join mode
ENABLE_HASH_JOIN =1 #enable hash join
ENABLE_INDEX_JOIN =1 #enable index join
ENABLE_MERGE_JOIN =1 #enable merge join
MPP_INDEX_JOIN_OPT_FLAG =0 #enhance index inner join in mpp
MPP_NLI_OPT_FLAG =0 #enhance nest loop inner join in mpp
MAX_PARALLEL_DEGREE =1 #Maximum degree of parallel query
PARALLEL_POLICY =0 #Parallel policy
PARALLEL_THRD_NUM =10 #Thread number for parallel task
PARALLEL_MODE_COMMON_DEGREE =1 #the common degree of parallel query for parallel-mode
PUSH_SUBQ =0 #Whether to push down semi join for correlated subquery
OPTIMIZER_AGGR_GROUPBY_ELIM =1 #Whether to attemp to eliminate group-by aggregations
UPD_TAB_INFO =0 #Whether to update table info when startup
ENABLE_IN_VALUE_LIST_OPT =6 #Flag of optimization methods for in-list expression
ENHANCED_BEXP_TRANS_GEN =1 #Whether to enable enhanced transitive closure of boolean expressions
ENABLE_DIST_VIEW_UPDATE =0 #whether view with distinct can be updated
STAR_TRANSFORMATION_ENABLED =0 #Whether to enable star transformation for star join queries
MONITOR_INDEX_FLAG =0 #monitor index flag
AUTO_COMPILE_FLAG =1 #Whether to compile the invalid objects when loading
RAISE_CASE_NOT_FOUND =0 #Whether raise CASE_NOT_FOUND exception for no case item matched
FIRST_ROWS =100 #maximum number of rows when first returned to clients
LIST_TABLE =0 #Whether to convert tables to LIST tables when created
ENABLE_SPACELIMIT_CHECK =1 #flag for the space limit check, 0: disable 1: enable
BUILD_VERTICAL_PK_BTREE =0 #Whether to build physical B-tree for primary key on huge tables
BDTA_PACKAGE_COMPRESS =0 #Whether to compress BDTA packages
HFINS_PARALLEL_FLAG =0 #Flag of parallel policy for inserting on huge table
HFINS_MAX_THRD_NUM =100 #Maximum number of parallel threads that responsible for inserting on huge table
LINK_CONN_KEEP_TIME =15 #Max idle time in minute for DBLINK before being closed
DETERMIN_CACHE_SIZE =5 #deterministic function results cache size(M)
NTYPE_MAX_OBJ_NUM =1000000 #Maximum number of objects and strings in composite data type
CTAB_SEL_WITH_CONS =0 #Whether to build constraints when creating table by query
HLDR_BUF_SIZE =8 #HUGE table fast loader buffer size in Megabytes
HLDR_BUF_TOTAL_SIZE = 4294967294 #HUGE table fast loader buffer total size in Megabytes
HLDR_REPAIR_FLAG =0 #Flag of repairing huge table after exception, 0: NO 1: YES
HLDR_FORCE_COLUMN_STORAGE =1 #Whether force column storage for last section data, 0: NO 1: YES
HLDR_FORCE_COLUMN_STORAGE_PERCENT =80 #Minumun percent of unfully section data for huge force column storage
HLDR_HOLD_RATE =1.50 #THE minimum rate to hold hldr of column number(1-65535)
HLDR_MAX_RATE =2 #THE minimum rate to create hldr of column number(2-65535)
HUGE_ACID =0 #Flag of concurrent mechanism for HUGE tables
HUGE_STAT_MODE =2 #Flag of default stat mode when create huge table, 0:NONE 1:NORMAL 2:ASYNCHRONOUS
HFS_CHECK_SUM =1 #Whether to check sum val for hfs data
HBUF_DATA_MODE =0 #Whether to uncompress and decrypt data before read into HUGE buffer
DBLINK_OPT_FLAG =13 #optimize dblink query flag
SEC_INDEX_PARALLEL_INSERT_FLAG=0 #Whether to use parallel insert for secondary indexes
FILL_COL_DESC_FLAG =0 #Whether to return columns description while database returns results
BTR_SPLIT_MODE =0 #Split mode for BTREE leaf, 0: split half and half, 1: split at insert point
BLOB_OUTROW_REC_STOR =5 #Flag for blob outrow record storage
TS_RESERVED_EXTENTS =64 #Number of reserved extents for each tablespace when startup
TS_SAFE_FREE_EXTENTS =512 #Number of free extents which considered as safe value for each tablespace
TS_MAX_ID =8192 #Maximum ID value for tablespaces in database
TS_FIL_MAX_ID =255 #Maximum ID value for files in tablespace
DECIMAL_FIX_STORAGE =0 #Whether convert decimal data to fixed length storage
SQL_SAFE_UPDATE_ROWS =0 #Maximum rows can be effected in an update&delete statement
ENABLE_HUGE_SECIND =0 #Whether support huge second index, 0: disable, 1: enable
TRXID_UNCOVERED =0 #Whether disable scanning 2nd index only when pseudo column trxid used, 0: disable, 1: enable
LOB_MAX_INROW_LEN =900 #Max lob data inrow len
RS_PRE_FETCH =1 #Whether enable result pre-fetch
#pre-load
LOAD_TABLE = #need to pre-load table
LOAD_HTABLE = #need to pre-load htable
#client cache
CLT_CACHE_TABLES = #Tables that can be cached in client
RLOG_CRC =1 #whether use crc check in log
#redo log
RLOG_BUF_SIZE =512 #The Number Of Log Pages In One Log Buffer
RLOG_POOL_SIZE =128 #Redo Log Pool Size In Megabyte
RLOG_PARALLEL_ENABLE =0 #Whether to enable database to write redo logs in parallel mode
RLOG_IGNORE_TABLE_SET =1 #Whether ignore table set
RLOG_APPEND_LOGIC =0 #Type of logic records in redo logs
RLOG_APPEND_SYSTAB_LOGIC =0 #Whether to write logic records of system tables in redo logs when RLOG_APPEND_LOGIC is set as 1
RLOG_RESERVE_SIZE =40960 #Number of reserved redo log pages for each operation
RLOG_CHECK_SPACE =1 #Whether to check that the available space in redo logs is enough
RLOG_SAFE_SPACE =128 #Free redo log size in megabytes that can be considered as a save value
RLOG_SAFE_PERCENT =25 #Percent value of free redo log space that can be considered as a save value
RLOG_SEND_APPLY_MON =64 #Monitor recently send or apply rlog_buf info
REDO_PRE_LOAD =128 #Redo pre load size(M)
REDO_PWR_OPT =1 #Whether to enable PWR optimization when system restarted after failure
REDO_IGNORE_DB_VERSION =0 #Whether to check database version while database is redoing logs
ELOG_REPORT_LINK_SQL =0 #Whether to write the SQLs that sent to remote database by DBLINKs into error log file
REDOS_BUF_SIZE =1024 #The max buffer size of rlog redo for standby In Megabyte
REDOS_MAX_DELAY =1800 #The permitted max delay for one rlog buf redo on standby In Second
REDOS_BUF_NUM =4096 #The max apply rlog buffer num of standby
REDOS_PRE_LOAD =32 #Number of pre-load apply rlog buffer for standby
#transaction
ISOLATION_LEVEL =1 #Default Transaction Isolation Level, 1: Read Commited; 3: Serializable
DDL_WAIT_TIME =10 #Maximum waiting time in seconds for DDLs
BLDR_WAIT_TIME =10 #Maximum waiting time in seconds for BLDR
MPP_WAIT_TIME =10 #Maximum waiting time in seconds for locks on MPP
FAST_RELEASE_SLOCK =1 #Whether to release share lock as soon as possible
SESS_CHECK_INTERVAL =3 #Interval time in seconds for checking status of sessions
LOCK_TID_MODE =1 #Lock mode for select-for-update operation
LOCK_TID_UPGRADE =1 #Upgrade tid lock to X mode, 0:no, 1:yes
NOWAIT_WHEN_UNIQUE_CONFLICT =0 #Whether to return immediately when unique constraint violation conflict happens
UNDO_EXTENT_NUM =16 #Number of initial undo extents for each worker thread
MAX_DE_TIMEOUT =10 #Maximum external function wait time in Seconds
TRANSACTIONS =75 #Maximum number of concurrent transactions
MVCC_RETRY_TIMES =5 #Maximum retry times while MVCC conflicts happen
ENABLE_FLASHBACK =0 #Whether to enable flashback function
UNDO_RETENTION =90.000 #Maximum retention time in seconds for undo pages since relative transaction is committed
PARALLEL_PURGE_FLAG =0 #flag for parallel purge of undo logs
PURGE_WAIT_TIME =100 #Maximum wait time in microseconds for purging undo pages
PSEG_RECV =1 #Whether to rollback active transactions and purge committed transactions when system restarts after failure
ENABLE_IGNORE_PURGE_REC =0 #Whether to ignore purged records when returning -7120
ENABLE_TMP_TAB_ROLLBACK =1 #enable temp table rollback
ROLL_ON_ERR =0 #Rollback mode on Error, 0: rollback current statement 1: rollback whole transaction
XA_TRX_IDLE_TIME =60 #Xa transaction idle time
LOB_MVCC =1 #Whether LOB access in MVCC mode
#security
PWD_POLICY =2 #Flag of password policy
ENABLE_ENCRYPT =0 #Encrypt Mode For Communication, 0: Without Encryption; 1: SSL Encryption; 2: SSL Authentication
ENABLE_UDP =0 #Enable udp For Communication, 0: disable; 1: single; 2: multi
UDP_MAX_IDLE =15 #Udp max waiting time in second
UDP_BTU_COUNT =8 #Count of udp batch transfer units
ENABLE_IPC =0 #Enable ipc for communication, 0: disable; 1: enable
AUDIT_FILE_FULL_MODE =1 #operation mode when audit file is full,1: delete old file; 2: no longer to write audit records
AUDIT_MAX_FILE_SIZE =100 #maximum audit file size in Megabytes
ENABLE_OBJ_REUSE =0 #Whether to enable objects reuse mechanism
ENABLE_REMOTE_OSAUTH =0 #Whether to enable remote authorization by operating system users
ENABLE_LOCAL_OSAUTH =0 #Whether to enable local authorization by operating system users
MSG_COMPRESS_TYPE =2 #Flag of message compression mode
ENABLE_STRICT_CHECK =0 #Whether to check access rights to objects that exist as part of EXECUTE IMMEDIATE sentences in store procedures or functions
MAC_LABEL_OPTION =1 #Flag of access rights to SP_MAC_LABEL_FROM_CHAR
LDAP_HOST = #LDAP Server ip
COMM_ENCRYPT_NAME = #Communication encrypt name, if it is null then the communication is not encrypted
COMM_VALIDATE =1 #Whether to validate message
ENABLE_EXTERNAL_CALL =0 #Whether permit external call
EXTERNAL_JFUN_PORT =6363 #DmAgent port for external java fun. 0: use ap instead of use DMAgent.
ENABLE_PL_SYNONYM =0 #Whether try to resolve PL object name by synonym.
ENABLE_DDL_ANY_PRIV =0 #Whether enable grant and revoke ddl any privilege.
FORCE_CERTIFICATE_ENCRYPTION =0 #Whether to encrypt login user name and password use certificate
REGEXP_MATCH_PATTERN =0 #Regular expression match pattern, 0: support non-greedy match; 1: only support greedy match
#compatibility
BACKSLASH_ESCAPE =0 #Escape Mode For Backslash, 0: Not Escape; 1: Escape
STR_LIKE_IGNORE_MATCH_END_SPACE =1 #Whether to ignore end space of strings in like clause
CLOB_LIKE_MAX_LEN =10240 #Maximum length in kilobytes of CLOB data that can be filtered by like clause
EXCLUDE_DB_NAME = #THE db names which DM7 server can exclude
MS_PARSE_PERMIT =0 #Whether to support SQLSERVER's parse style
COMPATIBLE_MODE =0 #Server compatible mode, 0:none, 1:SQL92, 2:Oracle, 3:MS SQL Server, 4:MySQL, 5:DM6, 6:Teradata
DATETIME_FMT_MODE =0 #Datetime fmt compatible mode, 0:none, 1:Oracle
DOUBLE_MODE =0 #Calc double fold mode, 0:8bytes, 1:6bytes
CASE_COMPATIBLE_MODE =1 #Case compatible mode, 0:none, 1:Oracle
EXCLUDE_RESERVED_WORDS = #Reserved words to be exclude
COUNT_64BIT =1 #Whether to set data type for COUNT as BIGINT
CALC_AS_DECIMAL =0 #Whether integer CALC as decimal, 0: no, 1:only DIV, 2:all only has charactor
CMP_AS_DECIMAL =0 #Whether integer compare as decimal, 0: no, 1:part, 2:all
CAST_VARCHAR_MODE =1 #Whether to convert illegal string to special pseudo value when converting string to integer
PL_SQLCODE_COMPATIBLE =0 #Whether to set SQLCODE in PL/SQL compatible with ORACLE as far as possible
LEGACY_SEQUENCE =0 #Whether sequence in legacy mode, 0: no, 1:yes
DM6_TODATE_FMT =0 #To Date' HH fmt hour system, 0: 12(defalut) , 1: 24(DM6)
PK_MAP_TO_DIS =0 #Whether map pk cols into distributed cols automatically
DROP_CASCADE_VIEW =0 #Whether to drop cascade view while dropping table or view
#request trace
SVR_LOG_NAME =SLOG_ALL #Using which sql log sys in sqllog.ini
SVR_LOG =0 #Whether the Sql Log sys Is open or close. 1:open, 0:close.
#system trace
GDB_THREAD_INFO =0 #Generate gdb thread info while dm_sys_halt. 1: yes; 0: no
TRACE_PATH = #System trace path name
SVR_OUTPUT =0 #Whether print at background
#ecs
ENABLE_ECS =0 #Whether to enable elastic calc system
EP_GROUP_NAME = DMGROUP #Server group name as worker
AP_GROUP_NAME = DMGROUP #Server group name as cooperative worker
DCRS_IP = LOCALHOST #IP on which the dcrs server will listen
DCRS_PORT_NUM =6236 #Port number on which the database dcrs will listen
AP_IP = LOCALHOST #The ap server IP for dcrs
AP_PORT_NUM =0 #Port number on which the database ap will listen
AP_PARALLEL_DEGREE =10 #Maximum degree of parallel for ap
ENABLE_ECS_MSG_CHECK =0 #Whether to enable elastic check msg accumulate
#monitor
ENABLE_MONITOR =1 #Whether to enable monitor
MONITOR_TIME =1 #Whether to enable monitor timing
MONITOR_SYNC_EVENT =0 #Whether to enable monitor sync event
MONITOR_SQL_EXEC =0 #Whether to enable monitor sql execute
MEMORY_MONITOR =0 #Whether to enable memory leak detection
ENABLE_FREQROOTS =0 #Whether to collect pages that used frequently
MAX_FREQ_ROOTS =200000 #Maximum number of frequently used pages that will be collected
MIN_FREQ_CNT =100000 #Minimum access counts of page that will be collected as frequently used pages
LARGE_MEM_THRESHOLD =1000 #Large mem used threshold by k
ENABLE_MONITOR_DMSQL =1 #Flag of performance monitoring:sql or method exec time.0: NO. 1: YES.
#data watch
DW_MAX_SVR_WAIT_TIME =0 #Maximum time in seconds that server will wait for DMWATCHER to startup
DW_INACTIVE_INTERVAL =60 #Time in seconds that used to determine whether DMWATCHER exist
DW_PORT =0 #Instance tcp port for watch2
ALTER_MODE_STATUS =1 #Whether to permit database user to alter database mode and status by SQLs
ENABLE_OFFLINE_TS =1 #Whether tablespace can be offline
SESS_FREE_IN_SUSPEND =60 #Time in seconds for releasing all sessions in suspend mode after archive failed
SUSPEND_WORKER_TIMEOUT =600 #Suspend worker thread timeout in seconds
SUSPENDING_FORBIDDEN =0 #Suspending thread is forbidden
#for context index
CTI_HASH_SIZE =100000 #the hash table size for context index query
CTI_HASH_BUF_SIZE =50 #the hash table cache size in Megabytes for context index query
USE_FORALL_ATTR =0 #Whether to use cursor attributes of FORALL statements
ALTER_TABLE_OPT =0 #Whether to optimize ALTER TABLE operation(add, modify or drop column)
#dcp
ENABLE_DCP_MODE =0 #Whether to work as a proxy for database cluster
DCP_PORT_NUM =5237 #Port number on which DCP will listen
DCP_CONN_POOL_SIZE =1000 #DCP connection pool size
USE_RDMA =0 #Whether to use rdma
#configuration file
MAL_INI =0 #dmmal.ini
ARCH_INI =0 #dmarch.ini
REP_INI =0 #dmrep.ini
LLOG_INI =0 #dmllog.ini
TIMER_INI =0 #dmtimer.ini
MPP_INI =0 #dmmpp.ini
#other
IDLE_MEM_THRESHOLD =50 #minimum free memory warning size in Megabytes
IDLE_DISK_THRESHOLD =1000 #minimum free disk space warning size in Megabytes
IDLE_SESS_THRESHOLD =5 #minimum available session threshold value
ENABLE_PRISVC =0 #Whether to enable priority service
DSC_N_CTLS = 10000 #Number Of LBS/GBS ctls
DSC_N_POOLS = 1 #Number Of LBS/GBS pools
DSC_ENABLE_MONITOR =1 #Whether to monitor request time
DSC_REMOTE_READ_MODE =1 #PAGE remote read optimize mode
HA_INST_CHECK_IP = #HA instance check IP
HA_INST_CHECK_PORT =65534 #HA instance check port
PWR_FLUSH_PAGES =1000 #Make special PWR rrec when n pages flushed
REDO_UNTIL_LSN = #redo until lsn
IGNORE_FILE_SYS_CHECK = 1 #ignore file sys check while starup
FILE_SCAN_PERCENT = 100.00 #percent of data scanned when calculating file used space
STARTUP_CHECKPOINT = 0 #checkpoint immediately when startup after redo
CHECK_SVR_VERSION =1 #Whether to check server version
BAK_USE_AP = 1 #backup use assistant plus-in, 1:use AP; 2:not use AP. default 1.
ENABLE_DBLINK_TO_INV =0 #Whether to convert correlated subquery which has dblink to temporary function
ENABLE_BLOB_CMP_FLAG =0 #Whether BLOB/TEXT types are allowed to be compared
ENABLE_CREATE_BM_INDEX_FLAG =1 #Allow bitmap index to be created
页:
[1]