3 Set missing configuration parameters in csql.conf file in this directory.
11 Make sure that the directory and files created be present before running the server.
16 This is a soak test suit where csqlserver will run forever.
17 The size of USERDB is 1073741824 bytes. (1GB);
19 Set kernel.shmmax=1610612736 (1.5GB)
20 Table of the following schema should be created in csql and TDB
22 CREATE TABLE soakTable(f1 smallint, f2 int, f3 bigint, f4 char(28), primary key(f2));
24 Size of each record will be 64kB.
25 The total number of pages = 131068.
26 One page will have 127 records.
27 Hence there can be (131068 * 127) = 16645636 records in the database.
29 There will be following processes that will be working on the 't1' table doing vvarious operations.
31 1. csqlInsert: (SqlApi Script)
32 This process will be inserting a record every 200 ms picking a random integer the value between 1 and 16645636.
34 2. odbcInsert: (odbc script)
35 This process will be inserting a record every 200 ms picking a random integer between 1 and 100000.
37 3. jdbcDelete: (jdbc script)
38 This process will delete first record fetched in the table every 200 ms.