data_source

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.

hostname

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

hostport

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

hostprot

Reserved

stop_time

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.

end_stop_time

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.

update_level

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

status_bits

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.

Bit

Description

1-256

For internal use only.

512

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.

1024

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

2048

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

4096

Reserved

8192

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

tab_name_prefix

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.

data_source_id

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.

last_run_status

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.

stop_afn

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.

af_origin

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

0

Audit file processed by DBEngine

1

DATABridge Tanker files processed by DBEngine

2

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

3

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.

4

Cached audit file processed by DBEnterprise.

server_version

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

engine_version

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

support_version

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

dbe_version

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

client_version

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

cfgsrvr_version

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

service_version

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

old_update_level

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.

db_timestamp

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'.