Display the Client Control Tables

The client control tables do not contain replicated DMSII data. The control tables hold the layout information of the DMSII database (from the DMSII DESCRIPTION file) and the layout of the corresponding relational database tables. The DATASETS table contains state information about the replication process. To store replicated data, the relational database uses data tables, which are created using information from the control tables. Each relational database has one set of client control tables that includes the following tables: DATASOURCES, DATASETS, DATATABLES, DMS_ITEMS, and DATAITEMS. (The exception is a test environment where a second set of client control tables are created for testing purposes. This is not recommended.)

The DATABridge Client uses certain columns of the control tables to determine how DMSII database objects are represented in the relational database layout. While DATABridge makes many of these decisions, some properties can be modified by using the Client Configurator or user scripts. For example, you can rename columns, combine like items, and flatten OCCURS, to name just a few.

You can verify changes you made to a single data set by viewing only the control table entries for that data set. This output shows changes made in the Client Configuration dialog box or the DMSII and Relational Properties views of the Client Configurator.

To display the client control tables

  • From Explorer view, select a data set or a data source, and then do one of the following:
    • To display control tables on-screen in a Console view, choose Data Source > Advanced > Display Control Tables.
    • To write the control tables to the current client log file, choose Data Source > Advanced > Log Control Tables.

For space considerations, column names are abbreviated to their "display" name. For a key to these abbreviations, see Key to Control Table Columns. For a full description about the columns, see Chapter 6 of the DATABridge Client Administrator's Guide.