To do this

Using dbutility

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

Perform a initial clone

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

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

redefine

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

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

generate

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

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

refresh

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

reorg

Reorganize (Data Source > Reorganize).

To run user scripts or DATABridge Client scripts

runscript

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

switchaudit

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

Unload Data Source (Data Source > Advanced)

To restore the client control tables using the backup file

reload

Reload Data Source (Data Source > Advanced)

To export the binary configuration file to an editable text file

export

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

import

Not available.

To create user scripts

createscripts

No command ine options are available.

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