DATASOURCES Client Control Table

The DATASOURCES client control table contains the data sources defined for the DATABridge Client. Each data source represents both a connection to a host and a DMSII database. You can define more than one data source within the DATASOURCES client control table as long as each data source name is unique. All of the data sources you define within the DATASOURCES table apply to one relational database.

Note: Do not modify client control tables directly. Instead, use the settings in the Client Console and Client Configurator to add and customize data sources.

The following table contains descriptions of each column, in the order in which it appears in the DATASOURCES table.




This value is the name you give the data source when you use the DATABridge Client define command. The name can be a maximum of 30 characters, and it must match one of the following:

  • The entry for SOURCE in the DBServer control on the host.
  • A base or filtered source as defined for Enterprise Server.


This column specifies the host name or IP address of the host (or Enterprise Server).


This column specifies the TCP/IP port number used to connect to DBServer or Enterprise Server.




This column specifies the start of the DATABridge Client blackout period expressed as an integer value representing 24‑hour time (hhmm format).

At a few key points during execution, the DATABridge command-line client (dbutility) tests this column to determine whether or not it should continue processing. The configuration file parameter controlled_execution enables this feature while the parameter min_check_time specifies the minimum delay time (for example, a typical time value may be 5 minutes) between checks of stop_time. The program checks at the start of a process or clone command and after commits, provided enough time has elapsed since the last check.

Note: Service-based operations ignore the value of this column.


This column specifies the end of the blackout period for the DATABridge command-line client (dbutility). It is expressed as an integer value representing 24-hour time (hhmm format).

For example, if stop_time is 2000 and end_stop_time is 200, the DATABridge Client refrains from running between 8:00 p.m. and 2:00 a.m.

Note: Service-based operations ignore the value of this column.


This column contains the update level of the DMSII database at the time the last define or redefine command was run.


This column contains a set of bits that the DATABridge Client sets. Some of these bits contain state information that is useful. Modifying this column can result in problems with the client. The following list is intended to be useful and is not comprehensive.






For internal use only.



SRC_NotBackedUp - When this bit is set, an unload file is created to ensure that the data source backup is not overwritten; the bit is then cleared. After the Client resumes audit file processing and a transaction group is successfully processed, this bit is set.



SRC_FileXtract - This bit indicates that the data source is a FileXtract file rather than a DMSII database.



SRC_ITRANS - This bit echoes the value of the DMSII database's INDEPENDENTTRANS flag.






SRC_DBEnterprise - When this bit is set, it indicates that the data source is an Enterprise Server data source, versus DATABridge Server data source.


This column holds an optional one- to eight-character prefix which is added to all table names in the data source. This prefix, which you must supply, allows you to distinguish between identically named data sets in multiple data sources, without having the define and redefine commands rename tables to eliminate name conflicts. The configuration file parameter use_column_prefixes extends this prefix to all column names.


This column allows you to provide a numeric identifier to distinguish records that belong to a particular data source from other records in a multi-source environment using a user script, or a relational database query tool. In addition, you must set the external_columns column to 128 or 2048 for the data set name.


This column holds the exit code of the last DATABridge Client process or clone command that was run. When the exit status is not available (such as when the DATABridge Client is running or abended), the exit_status entry is 9999.


This column specifies the AFN value when the configuration file parameter stop_after_given_afn is enabled.

Note: Service-based operations ignore the value of this column.


This column specifies the origin of the current audit file being processed. The following values are defined for this column:



Audit file processed by DBEngine



DATABridge Tanker files processed by DBEngine



Audit file processed by DBEnterprise using DBEngine to access regions. This is referred to as indirect disk.



Audit file processed by DBEnterprise using direct disk I/O. This is referred to as direct disk and is the most economical way to process audit files in term host resource utilization.



Cached audit file processed by DBEnterprise.


This column indicates the version of DBServer last used by the Client.


This column indicates the version of DBEngine last used by the Client.


This column indicates the version of the Support Library last used by the Client.


This column indicates the version of Enterprise Server last used by the DATABridge Client.


This column indicates the version of the last dbutility or DBClient that was run for this data source


This column indicates the version of DBClntCfgServer that was last used by the service to access the data source.


This column indicates the version of the service that launched a client run for the data source.


This column holds the previous value of update_level when running a redefine command. This value is used to name the reorg scripts that contain the DMSII database’s update level.


This column contains the timestamp of the DMSII database, which is the time when the database was created. It is used by the client to verify that the client is using the same database as it originally was. If this column is set to zeroes, then this test is not performed.

Caution: This column contains a DMSII TIME(6) value, which is binary and 6 bytes long.

For SQL Server, set db_timestamp=0.
For Oracle, set audit_ db_timestamp ='000000000000'.
For DB2, set audit_ db_timestamp =x'000000000000'.

Note: The data source CTLTAB_VERSION in the DATASOURCES table is a special entry created by the DATABridge Client. It indicates the version of the client control tables. Do not try to process this data source, and do not remove it from the table.