Siemens V 4.0 manual Gina V4.0 System Administrator Guide September

Setting up the database

To enable these aims to be achieved, knowledge is required on datasets and their dynamics (static, low frequency of change, high rate of change), as well as the access behavior to the data (navigating, value-based). This information is supplied to the Persistency Service gen- erator as customizing[14] input in an optimization process. From this input, the Persistency Service generator produces the optimized definition of the database schema (table layout, indexing, constraints) and the access functions to database tables (see section 5.2 on page 33).

A further task of the database administrator is to configure the database server. Here, the parameters for the operation of the database are defined in the appropriate configuration files and runtime procedures (specific to the selected database system). These parameters include maximum values such as

–the number of transactions permitted in parallel

–the wait time for a response from a remote database server

–name spaces for the current session like DBSERVERNAME or SERVERNUM

–parameters that affect the execution of the session, e. g. the time interval between two checkpoints.

If the database and transaction monitor are linked via the XA interface, the information required by the participating systems must be configured in appropriate generation and start procedures.

The initialization of the database is particularly important. This includes the initialization of tables from a file which contains the data in ASCII notation, or the transfer of binary- encoded data as an excerpt from a secondary database of the same type. Migration tools which are specific to the database system are available for transferring data from existing databases or files.

32 GINA V4.0 System Administrator Guide – September 2000