Operation of DBAccess Server is controlled by start parameters. These start parameters are stored in an initialization file called SYSDAT.SESDBA.091.INIT. The initialization file has the following entries:
[DBMS] Product=SESAM/SQL Version=9.1A [Connect] SESCONF=<ses_conf> SESAMAdmPass=<SESAM_administration-password> DefaultCatalog=<default-catalog> DefaultSchema=<default-schema> DefaultUser=<default-user> UserIdentification=<True/False> [SSLConnect] SSLUsage=NO SSLCertificate=<Certificate-file> SSLKey=<Key-file> [MainTask] ServerPort=2112 AdminPort=2113 UserFile=<user-filename> ConvTable=<EBCDIC-ASCII-conversion-filename> MsgFile=<message-filename> SessionLogFile=<True/False> RunPrio=210 TasksPrestart=3 TasksMaximum=100 ConnectQueue=5 PackageLen=8192 OptLogMsgLen=8192 MaxPreparableStatements=64 [ServerTask] SESAM_Prefetch=20 [Trace] AdminTask=0 MainTask=0 ServerTask=0[AdminClient] ServerHost=127.0.0.1
These entries can and must be modified by the administrator to enable control of DBAccess Server. This applies in particular when the ADO.NET interface is operated parallel to the JDBC interface.
Description of the entries
The entries in the initialization file have the following meanings:
Section [DBMS]
Key | Default | Meaning | A |
Product | SESAM/SQL | DBMS product name | N |
Version | 9.1A | DBMS version | N |
Section [Connect]
Key | Default | Meaning | A |
SESCONF | SESDBA.SESCONF | SESAM configuration file | Y |
SESAMAdmPass | (empty) | Password for SESAM/SQL administration | Y |
DefaultCatalog | D0CATALOG | Default catalog name, used as default for the CONNECT client operation. 1 | Y |
DefaultSchema | D0SCHEMA | Default schema name, used as default for the CONNECT client operation 1 | Y |
DefaultUser | D0USER | Default user name, used as default for the CONNECT client operation. Not casesensitive. | Y |
UserIdentification | true | Switch determines whether the server works with (true) or without (false) user identification. | Y |
1Regular names must be written in uppercase characters. Non-regular names must not be enclosed in quotation marks. In other words, the names must be written as they appear in the INFORMATION_SCHEMA (e.g. TABLES table).
Abschnitt [SSLConnect]
Schlüssel | Standard | Erläuterung | A |
SSLUsage | NO | NO: (default) PREFER: REQUIRE: | N |
SSLCertificate | (empty) | Certificat specification (file containing certificatet) for SSL connections | N |
SSLKey | (empty) | File with private key for network traffic encryption for SSL connections | N |
Section [MainTask]
Key | Default | Meaning | A |
ServerPort | 2112 | Port number of the main task; this port number must also be administered at the client computer. | N |
AdminPort | 2113 | Port number of the admin task | N |
UserFile | SESDBA.USERFILE | Name of the user file of the server | N |
ConvTable | SYSDAT.SESDBA.091. | File name of the conversion table of the server. | N |
MsgFile | SYSMES.SESDBA.091 | Name of the SESAM-DBAccess message file | N |
SessionLogFile | False | True: information about connections is written in a session log file. | D |
RunPrio | 210 | Run priority for tasks | P |
TasksPrestart | 3 | Number of tasks that the server starts in advance to increase connection speed1(0 - 500). | P |
TasksMaximum | 100 | Maximum number of server tasks that the server can start simultaneously 1 (1 - 500). | P |
ConnectQueue | 5 | Number of queued connect requests if the server has already reached the maximum number of server tasks (0-100). | P |
PackageLen | 8192 | Size of message packages (1024 - 32768). | P |
OptLogMsgLen | 8192 | Optimum size of logical messages | P |
MaxPreparable Statements | 64 | Max. number of prepared statements | P |
1The number of tasks which the server can start is limited by the parameters above. If the values specified for TasksPrestart / TasksMaximum are not reached, you should check the MAXUP / NPROC values of the Posix installation which limit the number of processes per user / in the system.
Section [ServerTask]
Key | Default | Meaning | A |
SESAM_Prefetch | 20 | Number of records requested by SESAM in prefetch mode. | P |
Section [Trace]
Key | Default | Meaning | A |
AdminTask | 0 | Trace level of the admin task | D |
MainTask | 0 | Trace level of the main task | D |
ServerTask | 0 | Trace level of the server task | D |
Section [AdminClient]
Key | Default | Meaning | A |
ServerHost | 127.0.0.1 | IP address of the server | N |
The column A indicates whether the administrator must modify the standard values:
N | In general, no modifications are necessary. |
Y | Default values must be modified in accordance with the SESAM installation and database. |
P | Default values can be modified to improve performance if the user profile is known. |
D | Modifications are only necessary to produce debugging information. |
Time at which keys are evaluated
All keys are evaluated when the server is startup. The keys are stored within a memory pool, so they can be accessed by all tasks. Any modifications made during the current operation have no effect. The modifcations become valid when the server is restarted.
By using the administration command REUSE-INI-FILE the changed entries in section [trace] can be made valid for all the tasks.