data_source

This column contains the name of the SOURCE name that identifies the DMSII database from which this data was taken. The data source name is defined when you run dbutility define. It must match the data source name in the DBServer parameter file on the host.

dataset_name

ds

This column contains the name of the DMSII data set from which this table was mapped.

table_name

table name

This column contains the name of the table as it appears in the relational database. DMSII data sets correspond to relational tables. To change this name, see Relational Database Table and Column Names.

index_name

index

This column contains the name of the relational database index that is created for fast access to this table. If the table has no index, this column is blank. This index is created via the DATABridge Client script named script.index.tablename. The value in this column is the index name used in the CREATE INDEX SQL statement.

rectype

/type

This column, which is zero for all tables mapped from fixed-format data sets, contains the record type of a DMSII variable-format data set. See Variable-Format Data Sets.

Record Type

Description

0

For a variable-format data set, this represents records that have no variable part.

1–254

Represents the variable-format record type as defined in the DASDL.

occurs_level

occ

This column contains the nesting level of OCCURS in the DMSII database. For example, an OCCURS table created from another OCCURS table has an occurs_level of 2. The original OCCURS table has an occurs_level of 1.

table_number

T#

This number is used by the SQL*Loader and bcp scripts. The DATABridge Client assigns consecutive numbers to the tables it defines for a data source during the define command. Each table within a data source has a unique table number, and the numbers begin with 1. The redefine command assigns numbers to new tables starting with the highest table number plus 1. Existing tables get their old table numbers restored.

active

A

The value of this column determines whether or not a table is cloned during a process or clone command. The default is 1, which indicates that the table will be cloned. If you change this value to 0, the table is not cloned. To disable cloning for an entire set of tables related to a DMSII data set, see DATASETS Client Control Table.

create_suffix

suf

The create_suffix column enables you to specify a value that identifies the index of the create_suffix string defined in the configuration file. For more information, see "create_table_suffix" in Generate Command Parameters.

index_suffix

The index_suffix column enables you to specify a value that identifies the index of the index_suffix string defined in the configuration file. For more information, see "create_index_ suffix" in Generate Command Parameters.

original_name

original_name

The DATABridge Client saves the original name of the renamed tables in this column so they can be identified during redefine commands.

prim_table

P

This column indicates whether or not this is a primary table.

dt_options

The dt_options column uses the following bits:

Bit

Description

1

DTOPT_Table_Renamed - The table was renamed by the user. This bit is used by the Client configurator to preserve the name change.

2

DTOPT_Index_Renamed - The table’s index was renamed by the user. This bit is used by the Client configurator to preserve the name change.

4

DTOPT_User_Table - This table was created by the by user. Not supported in DATABridge Client 6.1-6.2.

8

DTOPT_No_aux_stmts - This option inhibits the use of auxiliary statements for a given table during a process or clone command when the configuration parameter aux_stmts (default 10) is not zero.

16

DTOPT_Occ_Depends - This option, automatically set by the Client during a define or a redefine command, indicates that an OCCURS table (occurs_level > 0) contains an item with an OCCURS DEPENDING ON clause. This bit is used during update processing to properly handle cases where the value of the dms_depends_num item of an OCCURS DEPENDING ON clause changes.

32

DTOPT_All_Keys - Do not change this value.

64

DTOPT_No_Unique_Key - Do not change this value.

128

DTOPT_Preserve_Deletes - Do not change this value.

256

DTOPT_HistoryTable - This option, which is set by the define and redefine commands, indicates to the Client that this table is a history table and that all records should be treated as inserts to the history table.

Caution: Clearing this bit can corrupt history tables because it causes the Client to treat records as creates, deletes, and modifies instead of inserts.

512

DTOPT_UserSP - Indicates that the table uses the stored procedure m_tablename to perform customized functions instead of using the procedure i_tablename for an insert. This procedure is used to merge records rather than insert them into the table.

This bit is most often used for Miser databases.

1024

DTOPT_Clustered_Index - This option, which only applied to the SQL Server client, tells the DATABridge Client to create a clustered index for this table. You can globally set this option via the use_clustered_index parameter. See use_clustered_ index.

2048

DTOPT_Primary_Key - This option tells the DATABridge Client to create a primary key (instead of a unique index) for this table. When creating the script to create a primary key constraint, the Microsoft SQL Server client uses the value of the DTOPT_Clustered_Index to determine whether to add the NONCLUSTERED clause to the SQL. If this second option bit is not set, the NONCLUSTERED clause is added. You can globally set this option via use_primary_key. parameter.

4096

DTOPT_Delete_Seqno - This option is automatically set by the define or redefine command when the delete_seqno mask is set in the default_user_columns parameter value.

8192

DTOPT_Table_Split - This option is automatically set by the define or redefine command when the table is part of a split table. Do not modify this value.

16384

DTOPT_ConcatItems - This bit is automatically set by the define or redefine command and indicates that the table contains concatenated items. Do not modify this bit.

32,768

DTOPT_Clob_in_Table - This bit, which is only used by the Oracle client, indicates that the table contains an item whose data type is CLOB. Do not modify this bit.

65,536

DTOPT_OrigNameFixed - Internal use only - do not modify. This bit is used to convey whether the original table name was ever changed.

changes

These bits are used by the redefine command.

1

CHG_new - New entry

2

CHG_modified - Modified entry

4

CHG_del_before - One or more entries before this one were removed.

8

CHG_del_after - One or more entries after this one were removed.

32

CHG_index_changed - This bit, which is set by the redefine command indicates that the table’s index changed. The reorg command uses this bit as an indication that it must drop the index for the table and recreate it.

64

CHG_IndexType_changed - The index type changed primary key versus unique index or in the case of SQL Server unique index versus clustered index.

128

CHG_IndexName_changed - The index name changed, the client needs to drop the index using the old name and create the new index using the new name. The old name is saved in a temporary file by the redefine command. The reorg command deletes this file once the new index is successfully created

256

CHG_new_hist_tab - History tables were added for the data set. The redefine command sets this bit when it finds a new history table. The reorg command then can create these tables and we can continue processing without re-cloning the data set.

update_count

The update_count column represents the smoothed average number of updates for the table over the specified period of time.

update_interval

This update_interval column represent the period of time (in milliseconds) that the update_count spans.

The multi-threaded update code uses the update_count column to balance the thread load. The update_interval column will start out as 0 and increase until it reaches the value representing one hour, after which it never changes, as the average is smoothed to reflect the number of updates for each table over the last hour.

The update_count and update_interval columns were added to hold the table update statistics.

dt_user_bmask

This column, which shadows the dt_options column, contains a bit mask that represent customized columns in dt_options. This column is used by the redefine command to restore the portion of dt_options that has been customized while leaving the remaining bits intact.