Reorg Command Messages

The following messages appear in response to the DATABridge Client reorg command.

Begin processing configuration file "name"

This message, which only appears if the -v option is enabled, confirms that the Client is reading the specified text-based configuration file.

Clearing DataSet name[/rectype] records

This message indicates that the cleanup scripts is being run for the all the tables of the specified multisource data set.

Client exit code: dddd[(nnn)] - exit_code_text

This message displays when the command completes. On UNIX, the 8-bit exit code is shown only if it differs from the actual exit code.

Configuration information read from binary file "name"

This message, which only appears if the -v option is enabled, confirms that the Client has successfully read the specified binary configuration file.

Creating history table 'name'

This message indicates that a history table is being created because the configuration parameter enable_dynamic_hist is set True.

Creating index 'name' for history table 'name'

This message indicates that the index for a dynamically added history table is being created.

Creating index 'name' for table 'name'

This message indicates that the reorg command is creating the index for a table whose reorganization requires the index to be dropped and recreated.

Creating scripts for 'tabname'

This message is printed as a result of the reorg command executing a generate command before it does anything else.

Dataset name[/rectype] successfully reorganized

This messages is printed after a data set is successfully reorganized. It is meant to show the progress of the command that might sometime take a very long time to complete.

Dropping index for table 'name'

This message indicates that the reorg command is dropping the index for a table whose reorganization requires the index to be dropped and recreated.

End processing configuration file "name"

This message, which only appears if the -v option is enabled, confirms that the Client has processed the specified text-based configuration file.

Loading control tables for datasource

This message indicates that the DATASETS table and relational database layout information is being loaded into memory from the client control tables.

Multisource DataSet name[/rectype] ds_mode is 35

This message indicates that a multisource data set was dropped and the other data source must be reorganized before further action can occur. When the reorganization of that data source is complete, set the ds_mode to 0 to reclone it.

Oracle version: major_vers.minor_vers

This message, which is only written to the log file when using Oracle client, shows the Oracle version.

Reorganizing DataSet name[/rectype]

This messages is printed to the log file when a data set whose mode is 31 is found. When the reorganization is completed, the message “Dataset name[/rectype] successfully reorganized” is shown.

Set ds_mode to 0 for all of the sources to reclone

This message immediately follows the messages “Multisource DataSet name[/rectype] ds_mode is 35” and “The multisourced table has been dropped as there are no records left”.

Multisourced data sources get their inputs from two structurally identical DMSII databases (same DASDL) that reside on different systems (for example, two different branches of the company, each with their own database). The data is stored in the same tables in the relational database, using the source_id columns in all the tables to keep track of where the record originated.

When reorganizing a multisourced data source, the changes must be completed in both data sources before you can alter the tables. The data source that is reorganized first is placed in a waiting state until the remaining data source is reorganized. If the reorg command determines that there are no records in the table that come from any of the other multisourced data sources, it issues this message to indicate that it is time to reclone the table.

Set ds_mode to 0 when all sources have been reorganized

This message immediately follows the message “Multisource DataSet name[/rectype] ds_mode is 35”. See the previous message for an explanation of multisourced data sources. If the reorg command determines that there are records in the table that come from any of the other multisourced data sources, it issues this message to indicate that it is not yet time to reclone the table.

SQL Server version: major_vers.minor_vers

This message, which is only written to the log file when using the Microsoft SQL Server client, shows the SQL Server version. Note that SQL Server 2000 is version 8, SQL Server 2005 is version 9, SQL Server 2008 is version 10, and SQL Server 2008 R2 is version 10.5.

Stored procedures for all tables of DataSet name[/rectype] successfully refreshed

This message appears as a result of the reorg command executing the code that refreshed the stored procedures for the tables of a data set.

The multisourced table has been dropped as there are no records left

This message immediately follows the message “Multisource DataSet name[/rectype] ds_mode is 35” when the table has no records in it. It is followed by the message “Set ds_mode to 0 for all of the sources to re-clone”.