Siemens V 4.0 User Manual
GINA V4.0 System Administrator Guide – September 2000
31
Dr
uc
k v
om 24. 01.2001 17:00.24
per-k
onf
5 Configuring the Persistency Service
When examining the configuration of the Persistency Service, it is generally a good idea to
consult the documentation relating to the underlying database management system. All
explanations in this chapter relate to the database management system INFORMIX on the
UNIX platform. The environment can be different for other database management systems
or on other operating systems.
consult the documentation relating to the underlying database management system. All
explanations in this chapter relate to the database management system INFORMIX on the
UNIX platform. The environment can be different for other database management systems
or on other operating systems.
5.1 Setting up the database
The database is set up in several stages. First of all the system software of the database
management system used must be installed as prescribed by the manufacturer [19]. In
addition, IDs must be created for the administration of the database system. In this context,
it is also important to consider the definition of roles (IDs) in the area of administration and
security. Both the database server environment, for example INFORMIX Dynamic Server
2000, and that of the development environment, for example ESQL (in the client SDK), must
be installed.
management system used must be installed as prescribed by the manufacturer [19]. In
addition, IDs must be created for the administration of the database system. In this context,
it is also important to consider the definition of roles (IDs) in the area of administration and
security. Both the database server environment, for example INFORMIX Dynamic Server
2000, and that of the development environment, for example ESQL (in the client SDK), must
be installed.
In the next phase, the resources assigned to the database system must be configured. This
particularly includes system resources such as
–
particularly includes system resources such as
–
the number of needed semaphores,
–
size and number of shared memory segments,
–
configuration of disk memory (raw devices, RAID controller), and the
–
definition of connections (connectivity) to the database server.
When using the INFORMIX database system, for example, the entries in the files
/etc/hosts
and
/etc/services
must match those in the
sqlhosts
file. In general,
these global activities must be performed under the
root
administrator ID.
The next step is for the database administrator to structure the assigned disk resources
(dividing into chunks), applying a structure (dbspaces, blobspaces) which can be used in
the definition of the database schema and in the backup and recovery concept. The aim of
this activity is to achieve an optimum solution under the aspects of fault tolerance, perfor-
mance and availability. These activities are supported by appropriate tools, which are sup-
plied with the database system. For example, here INFORMIX offers the
(dividing into chunks), applying a structure (dbspaces, blobspaces) which can be used in
the definition of the database schema and in the backup and recovery concept. The aim of
this activity is to achieve an optimum solution under the aspects of fault tolerance, perfor-
mance and availability. These activities are supported by appropriate tools, which are sup-
plied with the database system. For example, here INFORMIX offers the
onmode
tool.