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
86 # Whethere to enable bidirectional updates for cached tables.
87 ENABLE_BIDIRECTIONAL_CACHE=false
89 CACHE_RECEIVER_WAIT_SECS=10
91 #Mode of operation SYNC or ASYNC
94 ##########################SqlNetworkServer Section########################
96 # Whether to enable SqlNetwork server
99 #Set port for Network access
102 # Max number of seconds that the network layer waits to receive a pkt
103 NETWORK_RESPONSE_TIMEOUT=3
105 # Max number of seconds that the network layer waits to connect to sql server
106 NETWORK_CONNECT_TIMEOUT=5
108 #Whether to enable Replication across the sites
111 #No of sites to replicate
114 #Give full path for the file where all the table information is stored
115 TABLE_CONFIG_FILE=/tmp/csql/csqltable.conf
117 #Give full path of the file where all the DSN information is stored
118 DS_CONFIG_FILE=/tmp/csql/csqlds.conf
120 #Give full path for the file where all the peer site information is stored
121 NETWORK_CONFIG_FILE=/tmp/csql/csqlnw.conf
123 # Give full path for conflict Resolution file
124 CONFL_RESOL_FILE=/tmp/csql/conflResoFile.txt
126 # MSGKEY for creating msg queue for MsgQueue Server
129 # Maximum message that the message queue server is able to handle for
130 # asynchronous updates. This value is is default value of 'kernel.msgmax'
134 # Maximum number of messages that the message queue server will hold for a site
135 # that is down in the replication group.
138 # Shared memory key for id generators
140 #####################################End Section########################