Download INFORMIX-Universal Server Backup and Restore Guide

Transcript
The bar_server Table
The bar_server Table
The bar_server table lists the database servers in an installation. This table is
used to ensure that backup objects are returned to their proper places during
a restore. This table is built from $INFORMIXSQLHOSTS.
Column Name
Type
Explanation
srv_name
CHAR(18)
Database server name. Matches
$INFORMIXSERVER.
srv_node
CHAR(18)
Name of the node where the database server
resides.
ON-Bar Catalog Map
Figure 4-1 maps the ON-Bar tables. The grey lines show the referential
constraints between tables. Read from the left to the right, the data needs to
be present in the first table before you can insert it into the second table. For
example, consider the bar_object and bar_server tables. Reading from the
left to the right, the bar_server table is first and the bar_object table is second.
If you are trying to insert data into the obj_srv_name column of the
bar_object table, there has to be a matching name in the srv_name column of
the bar_server table.
Catalog Tables
4-7