To do this

With this dbutility command

With the Service (via Client Console)

Create client control tables

configure

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

clone

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

define

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

redefine

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

To show client control table entries for data sets

display

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

generate

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

process

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)

refresh

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

reorg

Select Data Source > Reorganize.

To run user scripts or DATABridge Client scripts

runscript

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

switchaudit

Not supported.

To back up the client control tables

unload

Select Data Source > Advanced > Unload Data Source.

To restore the client control tables using the backup file

reload

Select Data Source > Advanced > Reload Data Source.

To export the binary configuration file to an editable text file

export

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

import

Not available.

To create user scripts to back up customizations made by the Client Configurator

createscripts

Select Data Source > Advanced > Create User Scripts.