Comparing the Client Service to Command-Line Operations

The Client service 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 initiated by the service 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

With this dbutility command

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

Clone the data sets specified on the command line


To clone selected data sets, select Data Source > Advanced > Clone Data Sets.

Populate the client control tables with information about the DMSII data set layouts and the corresponding relational database table layouts


Select 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


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

To show client control table entries for data sets


To show the control tables in a Console view, Data Source > Advanced > Display Control Tables.

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.

Select Data Source > Generate Scripts. This is the equivalent of running the generate 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 perform the initial clone or process DMSII database updates


Select Data Source > Process. 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. This command can be run anytime.

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


Not currently supported. When you run a Reorganize command, the affected data sets are automatically refreshed by this command.

To generate new scripts for stored procedures and refresh the relational database stored procedures after a DMSII database reorganization has occurred


Select Data Source > Reorganize.

To run user scripts or DATABridge Client scripts


Select 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


Not supported.

To back up the client control tables


Select Data Source > Advanced > Unload Data Source.

To restore the client control tables using the backup file


Select Data Source > Advanced > Reload Data Source.

To export the binary configuration file to an editable text file


Select 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 to back up customizations made by the Client Configurator


Select Data Source > Advanced > Create User Scripts.

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