Comparing the Service to Command Line Operations

The service (via the Client Console) performs the same operations as the command-line client, dbutility. The primary advantage to using the service is its ease of use and the ability to automate most of your Client processes. Additionally, client runs can't be interrupted or tampered with as they occur as background runs. The following table can give you a better idea of how the two modes of operations compare when performing Client-specific tasks.

To do this

Using dbutility

Using the Service (via Client Console)

Create client control tables


The client control tables are automatically created if they don't already exist when Define/Redefine is selected or the Client Configurator is started.

Perform a initial clone


Process (from the Data Source menu)

For subsequent clones, select Clone Data Sets (Data Source > Advanced > Clone Data Sets).

Create the structure (relational database tables, layouts, and control information) required for a new data source on the secondary database


Define/Redefine (Data Source > Advanced > Define/Redefine). DBClntCfgServer executes the appropriate command (Define or Redefine).

Redefine All is the equivalent of the command-line redefine command with the -R option. If a define command is needed, the -R option will be ignored.

Apply changes from the primary database to the relational database structure while preserving existing information


Define/Redefine (Data Source > Advanced > Define/Redefine). When this command is selected DBClntCfgServer executes the appropriate command.

To show client control table entries for data sets (whose active column is 1)


Display Control Tables (Data Source > Advanced > Display Control Tables) shows the control tables in a Console view.

To write control tables to the log, select Data Source > Advanced > Log Control Tables.

To create script files


Note:Use the –u option to create and place all of the script files in the dbscripts subdirectory.

Generate Scripts command (Data Source > Generate Scripts). This runs the command with no command-line options.

To force script files to be created in the dbscripts subdirectory, select Data Source > Advanced > Generate All Scripts.

To check the DMSII database for updates


Process command (Data Source > Process). This command can be run anytime. The service, which controls scheduling for all process commands, starts DBClient at the scheduled time (if specified) and terminates DBClient when the process command finishes.

To recreate the stored procedures for tables associated with a given data set in the specified data source (for example, after a DMSII reorganization).


The Console does not directly support this command. When you run a Reorganize command, the affected data sets are automatically refreshed by this command.

(After a DMSII database reorganization has occurred) to generate new scripts for stored procedures and refresh the relational database stored procedures


Reorganize (Data Source > Reorganize).

To run user scripts or DATABridge Client scripts


Run Script (Data Source > Advanced > Run Script). This command runs the script in the user script directory (user_script_dir ), the name and location of which is defined in the client configuration file. If you start the filename with a backslash for a Windows client or a slash for a UNIX client, this command uses the -n option, which overrides the directory specification.

To close an audit file on the host


Supported only when Switch DMSII audit file on notify is enabled in the Client Configuration dialog box in the Client Console and NOTIFY is used on the host.

To back up the client control tables


Unload Data Source (Data Source > Advanced)

To restore the client control tables using the backup file


Reload Data Source (Data Source > Advanced)

To export the binary configuration file to an editable text file


Export Client Configuration (Data Source > Advanced > Export Client Configuration). You can only execute the export command with the default command-line options from the Client Console.

To import a text configuration file (and convert it to a binary file) for use with the Client


Not available.

To create user scripts


No command ine options are available.

Create User Scripts (Data Source > Advanced > Create User Scripts).

For more information about dbutility commands, see dbutility Commands. For more information about the Client Console, see the Help included within the Console and Using the Console and Service, in this section.


Using the Console and Service