1 # CSQL System Configuration File
3 #####################################Server Section########################
5 # Site ID for this CSQL server
8 #Important: For Server section parameters, make sure that the value is same for the
9 # server process and all the csql client process which connects to it. otherwise,
10 # behavior is undefined
12 # Page size. Each database is logically divided into pages and allocation happens
13 # in this unit of pages. Increasing this value will reduce frequent allocation of pages.
16 #Total number of client process which can connect and work with the
17 # database concurrently
20 # Maximum size of the system database.
21 MAX_SYS_DB_SIZE=1048576
23 #Maximum size of the user database file.
26 #Shared memory key to be used by the system to create and locate system database.
29 #Shared memory key to be used by the system to create and locate user database.
32 #Log level 0->no logging 1->Fine 2->Finer 3->Finest
35 #Give full path for the log file where important system actions are stored.
36 LOG_FILE=/tmp/csql/log/log.out
38 #The virtual memory start address at which the shared memory segment
39 # will be created and attached.
42 # Whether to enable durability
45 # Whether to enable memory map architecture for user database
48 # Specifies the durability mode for redo log generation
50 # 1 ->uses standard redo logging with O_APPEND mode
51 # 2 ->uses standard logging with serialization
52 # 3 ->uses O_SYNC flag
53 # 4 ->uses O_DIRECT flag
57 #Give full path for the database file where table and record information will
58 #be stored for durability
59 DATABASE_FILE=/tmp/csql/db
61 #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
63 # Give full path for the std error file to store all the errors during database operations
66 #####################################Client Section########################
68 #Mutex timeout interval seconds
70 MUTEX_TIMEOUT_USECS=5000
71 MUTEX_TIMEOUT_RETRIES=10
73 #Lock timeout interval seconds
75 LOCK_TIMEOUT_USECS=5000
76 LOCK_TIMEOUT_RETRIES=10
78 #####################################Cache Section########################
80 #Whether to enable caching of tables from target database
83 #DSN Name to connect to the target database.
84 #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 # Max number of seconds that the network layer waits to receive a pkt
104 NETWORK_RESPONSE_TIMEOUT=3
106 # Max number of seconds that the network layer waits to connect to sql server
107 NETWORK_CONNECT_TIMEOUT=5
109 #Whether to enable Replication across the sites
112 #No of sites to replicate
115 #Give full path for the file where all the table information is stored
116 TABLE_CONFIG_FILE=/tmp/csql/csqltable.conf
118 #Give full path of the file where all the DSN information is stored
119 DS_CONFIG_FILE=/tmp/csql/csqlds.conf
121 #Give full path for the file where all the peer site information is stored
122 NETWORK_CONFIG_FILE=/tmp/csql/csqlnw.conf
124 # Give full path for conflict Resolution file
125 CONFL_RESOL_FILE=/tmp/csql/conflResoFile.txt
127 # MSGKEY for creating msg queue for MsgQueue Server
130 # Maximum message that the message queue server is able to handle for
131 # asynchronous updates. This value is is default value of 'kernel.msgmax'
135 # Maximum number of messages that the message queue server will hold for a site
136 # that is down in the replication group.
139 # Shared memory key for id generators
141 #####################################End Section########################