Siemens V 4.0 User Manual
194
GINA V4.0 System Administrator Guide – September 2000
DB administration
8.2 DB administration
The database system INFORMIX Dynamic Server 2000 Version 9.2 is used for data storage
within the Persistency Service. This results in a range of tasks for DB administration which
can be completed with the aid of appropriate utilities. As already described, the transaction
monitor and the database are synchronized by the XA protocol. It must be ensured that this
link is supported in the current installation.
within the Persistency Service. This results in a range of tasks for DB administration which
can be completed with the aid of appropriate utilities. As already described, the transaction
monitor and the database are synchronized by the XA protocol. It must be ensured that this
link is supported in the current installation.
The main tasks in operating the database lie in the area of precautionary backup and tuning
in the distribution of data on the available storage media.
in the distribution of data on the available storage media.
In this case too, knowledge is required of the respective service functions in the database
system, which are described in the relevant manuals.
system, which are described in the relevant manuals.
8.2.1
Security management
The database system allows you to log events in an audit procedure in order to obtain infor-
mation on the activities of users or user groups, particularly in relation to attempts to acquire
rights for themselves or others. The ID of the database administrator (
mation on the activities of users or user groups, particularly in relation to attempts to acquire
rights for themselves or others. The ID of the database administrator (
informix
) should
always be monitored by the audit function. In Version 9.2 of INFORMIX Dynamic Server
2000, the functionality of the database administrator can also be distributed over a number
of roles in order to improve the separation of administration and security functions. The
actual steps involved are described in the relevant manuals [21]. Moreover, access rights
to database objects (tables, procedures) can be assigned on the level of the GRANT and
REVOKE function. A precise description can be found in [16].
2000, the functionality of the database administrator can also be distributed over a number
of roles in order to improve the separation of administration and security functions. The
actual steps involved are described in the relevant manuals [21]. Moreover, access rights
to database objects (tables, procedures) can be assigned on the level of the GRANT and
REVOKE function. A precise description can be found in [16].
8.2.2
Data backup
This aspect is concerned with the use of backed up data to fully or partially recover a data-
base which can no longer be used due to the failure of a disk drive, for example. This type
of backup archive is created and subsequently recovered with the aid of utilities which are
provided by the database system.
base which can no longer be used due to the failure of a disk drive, for example. This type
of backup archive is created and subsequently recovered with the aid of utilities which are
provided by the database system.
The task of the database administrator is to minimize the effort involved, whilst working on
the basis of restoring a database securely. The backup can be installed as an automatic
process, whereby utilities of the INFORMIX database system, such as
the basis of restoring a database securely. The backup can be installed as an automatic
process, whereby utilities of the INFORMIX database system, such as
onarchive
, can be
used in conjunction with
onautovop
.
1)
An important function in increasing availability lies in the use of RAID memory or in the uti-
lization of the database function to mirror disk areas (chunks).
lization of the database function to mirror disk areas (chunks).
1)
The
dbexport
and
dbimport
commands from INFORMIX-OnLine do not back up the full information
on the status of the XA interface.
You should therefore never use these commands to back up data.
You should therefore never use these commands to back up data.