There are two ways to enter the DBH start parameters:
You can pass them in the sequence of commands for starting the DBH.
You can also pass them via an input file.
Parameter input is logged to SYSLST. You can use the LOGGING parameter of the MODIFY-SDF-OPTIONS statement to specify the extent of the logging to be carried out (see the BS2000 manual “ Commands”). It is advisable to select LOGGING=ACCEPTED-FORM, so that only the start parameters you enter are logged, not the default values.
DBH start parameters in the sequence of commands for starting the DBH
You can enter the start parameters in the sequence of commands for starting the DBH in the procedure.
To do this, you must assign the SYSDTA system file to SYSCMD before the START-SESAM-DBH command.
The start parameters must come immediately after the start command START-PROGRAM.
When entering the DBH start parameters, you must follow the rules on "Entering the DBH start parameters for the independent DBH".
Passing the DBH start parameters via an input file
Before you start the DBH by means of the START-SESAM-DBH command, you have to assign the input file. There are several ways to do this.
You can assign the input file as a DBH configuration file using the link name SESCONF or via the SYSDTA system file (see "Entering the DBH start parameters for the independent DBH")
A DBH configuration file with all DBH options and their current values can be created conveniently in the active DBH session using the administration statement SAVE-DBH-OPTIONS, see "SAVE-DBH-OPTIONS".You can assign the input file as a global configuration file using the
CONNECT-SESAM-CONFIGURATION command (see "Entering the DBH start parameters for the independent DBH")
It is possible in interactive mode as well as batch mode to pass the DBH start parameters to the DBH by means of an input file (see "Starting the linked-in DBH").
Assigning a DBH configuration file
You assign the DBH configuration file using the link name SESCONF with the following command:
/ADD-FILE-LINK LINK-NAME=SESCONF,FILE-NAME=configuration_file
You assign the DBH configuration file via the SYSDTA system file with the following command:
/ASSIGN-SYSDTA TO-FILE=configuration_file
Assigning a global configuration file
This global configuration file can contain configuration parameters for several components of the SESAM/SQL system (see "Starting the linked-in DBH"). The file must have the following structure:
CONFIGURATION-LINK = linkname-1 1. dbh-option | dcn-option | dbcon-option 2. CONFIGURATION-LINK = linkname-2 3. dbh-option | dcn-option | dbcon-option CONFIGURATION-LINK = linkname-n dbh-option | dcn-option | dbcon-option . .
- This string must begin in column 1.
- The DBH options are not checked until the various tasks are executed. They can be separated by “//REMARK” comment lines.
- The link names must be unique in the file.
Example of a global configuration file
//REMARK LOAD OPTIONS FOR THE DBH ******************************** CONFIGURATION-LINK=SESDBB1 //SET-DBH-OPTIONS- // DBH-IDENTIFICATION=*PARAMETERS(- // CONFIGURATION-NAME=Z- // ,DBH-NAME=X- // )- // ,ADMINISTRATION=*PARAMETERS(- // ACCOUNTING=*PARAMETERS(- . . . //REMARK K_2_DBH_NEW_1 ****************************************** //ADD-SQL-DATABASE-CATALOG-LIST- // ENTRY-1=*CATALOG(- // CATALOG-NAME=AUFTRAGKUNDEN- // ,USER-ID=KENN1- // )- . . . //REMARK LOAD OPTIONS FOR APPLICATION PROGRAMS ****************** CONFIGURATION-LINK=SESDBB2 REMARK CONFIGURATION DATA *************************************** CNF=Z NAM=X PUF=64000 TOTAL-USERS=00128 REMARK A DB PROCESS IS ASSIGNED SPECIFICALLY TO A UTM PROCESS ***** UTMVG=JA VT
You can assign this file only with the following command:
CONNECT-SESAM-CONFIGURATION | ||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||
Operands
TO-FILE = <filename 1..54>
You specify the name of the global configuration file here.
TO-FILE = *LIBRARY-ELEMENT(...)
If the configuration file is in a library, you make the appropriate entries here.
*LIBRARY-ELEMENT(...)
LIBRARY = <filename 1..54 without-gen-vers>
You specify the library name here.
ELEMENT = <composed-name 1..64 with-under>(...)
You specify the element name here.
VERSION = *HIGHEST-EXISTING / <composed-name 1..24 with-under>
You specify a version of the element here.
TYPE = S / <alphanum-name 1..8>
You specify the type of the element here.
CONFIGURATION-LINK = <alphanum-name 1..8>
You specify here the link name to which the options for the DBH to be started are assigned in the global configuration file.
The options for the selected configuration are stored locally in a configuration file with the following name:
t SESCONF. tsn
t | Temporary identifier: # or @ |
Notes on entering control statements
When entering the DBH start parameters, you must observe the following rules regardless of whether you enter them in a procedure or an input file:
Each line must begin with the escape symbol (//).
Each start statement must begin on a new line.
If a start statement and its parameters take up several lines, each line except the last must be concluded with the continuation character (-).
The continuation character (-) is not permitted at the end of a line if there is a new start statement or an END statement on the next line.
The parameters must be entered in a fixed order (see chapter “DBH start statements and options”).
The SET-DBH-OPTIONS statement must be followed by either another start statement or the END statement.
The DBH start statements ADD-SQL-DATABASE-CATALOG-LIST and ADD-OLD-TABLE-CATALOG-LIST must both be followed by the END statement (see section “DBH start statements”).
If ADD-SQL-DATABASE-CATALOG-LIST is not followed by the ADD-OLD-TABLE-CATALOG-LIST start statement, you must enter an END statement instead. This END statement can only be omitted when the DBH is started with the default setting for the DBH option OLD-TABLE-CATALOG, which is OLD-TABLE-CATALOG =0 (see "OLD-TABLE-CATALOG").
If one of the DBH start parameters is incorrect, the DBH aborts and you receive an error message.
These rules apply in interactive mode as well as batch mode.