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