1 # CSQL System Configuration File
3 #####################################Server Section########################
4 #Important: For Server section parameters, make sure that the value is same for the
5 # server process and all the csql client process which connects to it. otherwise,
6 # behavior is undefined
8 # Page size. Each database is logically divided into pages and allocation happens
9 # in this unit of pages. Increasing this value will reduce frequent allocation of pages.
12 #Total number of client process which can connect and work with the
13 # database concurrently
16 # Maximum size of the system database.
17 MAX_SYS_DB_SIZE=1048576
19 #Maximum size of the user database file.
22 #Shared memory key to be used by the system to create and locate system database.
25 #Shared memory key to be used by the system to create and locate user database.
28 #Log level 0->no logging 1->Fine 2->Finer 3->Finest
31 #Give full path for the log file where important system actions are stored.
32 LOG_FILE=/tmp/csql/log/log.out
34 #The virtual memory start address at which the shared memory segment
35 # will be created and attached.
38 # Whether to enable durability
41 # Can be set true only when DURABILITY is true
44 # Specifies the durability mode for redo log generation
46 # 1 ->uses standard redo logging with O_APPEND mode
47 # 2 ->uses standard logging with serialization
48 # 3 ->uses O_SYNC flag
49 # 4 ->uses O_DIRECT flag
53 #Give full path for the database file where table and record information will
54 #be stored for durability
55 DATABASE_FILE=/tmp/csql/db
57 #Important: For Server section parameters, make sure that the value is same for the server process and all the csql client process which connects to it. otherwise, behavior is undefined
59 # Give full path for the std error file to store all the errors during database operations
62 #####################################Client Section########################
64 #Mutex timeout interval seconds
66 MUTEX_TIMEOUT_USECS=5000
67 MUTEX_TIMEOUT_RETRIES=10
69 #Lock timeout interval seconds
71 LOCK_TIMEOUT_USECS=5000
72 LOCK_TIMEOUT_RETRIES=10
74 #####################################Cache Section########################
76 #Whether to enable caching of tables from target database
79 #Set cache id for multiple bidirectional cache node for single data source
82 #DSN Name to connect to the target database.
83 #This should be present in ~/odbc.ini file
87 # Whethere to enable bidirectional updates for cached tables.
88 ENABLE_BIDIRECTIONAL_CACHE=false
90 CACHE_RECEIVER_WAIT_SECS=10
92 #Mode of operation SYNC or ASYNC
95 ##########################SqlNetworkServer Section########################
97 # Whether to enable SqlNetwork server
100 #Set port for Network access
103 #Whether to enable Replication across the sites
106 #No of sites to replicate
109 #Give full path for the file where all the table information is stored
110 TABLE_CONFIG_FILE=/tmp/csql/csqltable.conf
112 #Give full path of the file where all the DSN information is stored
113 DS_CONFIG_FILE=/tmp/csql/csqlds.conf
115 #Give full path for the file where all the peer site information is stored
116 NETWORK_CONFIG_FILE=/tmp/csql/csqlnw.conf
118 # MSGKEY for creating msg queue for MsgQueue Server
122 #####################################End Section########################