#DaMeng Database Server Configuration file
#this is comments
#file location of dm.ctl
CTL_PATH = /DM/data/DAMENG/dm.ctl #ctl file path
CTL_BAK_PATH = /DM/data/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 = /DM/data/DAMENG #system path
CONFIG_PATH = /DM/data/DAMENG #config path
TEMP_PATH = /DM/data/DAMENG #temporary file path
BAK_PATH = /DM/data/DAMENG/bak #backup file path
DFS_PATH = $/DAMENG #path of db_file in dfs
#instance name
INSTANCE_NAME = DMSERVER #Instance name
#memory pool and buffer
MAX_OS_MEMORY = 70 #Maximum Percent Of OS Memory
MEMORY_POOL = 42768 #Memory Pool Size In Megabyte
MEMORY_N_POOLS = 1 #Number of Memory Pool
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 = 1 #Memory Pool Magic Checking Flag
HUGEPAGE_THRESHOLD = 16 #IF not zero, try using hugepage if allocating size >= thresold * 2M
MEMORY_BAK_POOL = 1024 #Memory Backup Pool Size In Megabyte
HUGE_MEMORY_PERCENTAGE = 50 #Maximum percent of HUGE buffer that can be allocated to work as common memory pool
HUGE_BUFFER = 80 #Initial Huge Buffer Size In Megabytes
HUGE_BUFFER_POOLS = 4 #number of Huge buffer pools
BUFFER = 31650 #Initial System Buffer Size In Megabytes
MAX_BUFFER = 31650 #
BUFFER_POOLS = 211 #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 = 128 #system KEEP buffer size in Megabytes
RECYCLE = 390 #system RECYCLE buffer size in Megabytes
RECYCLE_POOLS = 3 #Number of recycle buffer pools
ROLLSEG = 128 #system ROLLSEG buffer size in Megabytes
ROLLSEG_POOLS = 3 #Number of rollseg buffer pools
MULTI_PAGE_GET_NUM = 1 #Maximum number of pages for each read of buffer
PRELOAD_SCAN_NUM = 0 #The number of pages scanned continuously to start preload task
PRELOAD_EXTENT_NUM = 0 #The number of clusters preloaded for the first time
SORT_BUF_SIZE = 64 #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 = 32 #dictionary buffer size in Megabytes
HFS_CACHE_SIZE = 256 #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
TSORT_OPT = 1 #minimizing memory allocation during small rowset sorting if possible
DFS_BUF_FLUSH_OPT = 0 #Whether to flush buffer page in opt mode for DFS storage
#thread
WORKER_THREADS = 64 #Number Of Worker Threads
TASK_THREADS = 64 #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 = 8192 #Worker Thread Stack Size In Kilobytes
WORK_THRD_RESERVE_SIZE = 200 #Worker Thread Reserve 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;
VPD_CAN_CACHE = 0 #VPD 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 Of cached 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
MAX_N_GRP_PUSH_DOWN = 5 #Maximum Number Of Rels For Group push down 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 = 31 #the optimized flag of LIKE expression
FILTER_PUSH_DOWN = 0 #whether push down filter to base table
USE_MCLCT