Siemens V 4.0 User Manual
GINA V4.0 System Administrator Guide – September 2000
195
DB administration
Dr
uc
k v
om 24. 01.2001 17:01.04
sys-adm
Should a recovery procedure be required, manual interception to diagnose the error on the
one hand and rectify it on the other (replace the faulty component) is generally necessary.
Only then can the data recovery be performed from the backup archives using the appro-
priate programs (
one hand and rectify it on the other (replace the faulty component) is generally necessary.
Only then can the data recovery be performed from the backup archives using the appro-
priate programs (
onarchive
). This process can take a long time, during which the database
can only be partially used or not at all. If this cannot be tolerated in reality (error-protected
24-hour operation), additional replica databases can be installed on a secondary system,
with the option of automatically switching over to the replica in the event of error. Of course,
this also means that appropriate access possibilities (connections) are required to commu-
nicate with this secondary system.
24-hour operation), additional replica databases can be installed on a secondary system,
with the option of automatically switching over to the replica in the event of error. Of course,
this also means that appropriate access possibilities (connections) are required to commu-
nicate with this secondary system.
A detailed description of these topics can be found in the appropriate manuals for the data-
base system [19], [20], [21].
base system [19], [20], [21].
8.2.3
Logging database errors
GINA allows you to log INFORMIX errors in a file for the purpose of debugging during the
development phase.
development phase.
If the
GINA_DBPROT
environment variable is set when the application is started, database
errors at SQL level are logged to the file specified by the value in this variable. In the case
of errors in filter iterators, the relevant select statement is output before the INFORMIX error
message.
of errors in filter iterators, the relevant select statement is output before the INFORMIX error
message.
GINA_DBPROT
must contain a valid file name. The file is created automatically if it does not
yet exist. If the file already exists, new error messages are simply appended to the existing
file.
file.