Unscheduled Updating

Use this procedure when you want to run dbutility process independent of scheduling.

To update the DATABridge data tables in the relational database

  1. Make sure that DBServer or DBEnterprise is running. If it is not, the DATABridge Client will try to connect to the server and eventually time out.
  2. Make sure that your signon parameters are set appropriately.
  3. If the [EbcdictoAscii] section of the configuration file (to customize character translation) has changed since the initial clone, your data may not be consistent. You might need to reclone.
  4. Make sure that the current directory is the one you created for this data source. This ensures that DATABridge Client can locate the scripts. (Scripts are only required during an update if there's a purged data set.)
  5. Enter the following:

    dbutility [signon_options misc_options] process datasource

    Option

    Description

    signon_options

    For each DATABridge Client type, the following command-line options sign on to the relational database (and DBServer):

    DB2 and Informix:

    [-U userid] [-P password] [-O ODBCdatasource]

    Oracle:

    [-U userid] [-P password] [-D database]

    SQL Server:

    [-U userid] [-P password] [-W] [-O ODBCdatasource]

    misc_options

    Any of the following miscellaneous command line options:

    -L forces the client to use a new log file for this run.

    -f filename to specify a configuration file other than the default dbridge.cfg file in the working directory

    -w to toggle the use_dbwait parameter

    -K to inhibit running the audit file removal WFL on the host

    -T forces the client to use a new trace file for this run, if tracing is enabled.

    For information on the command-line options, see dbutility Command-Line Options.

    datasource

    The name of the data source specified in the DBServer control file or by Enterprise Server.

When you run a process command to update the DATABridge tables in the relational database, the following occurs:

  • All modified records are overwritten with their new values. If the target record is not found in the table, the DATABridge Client adds the record to the table instead.
  • All deleted records are deleted.
  • All added records are inserted into to the data tables. If the target record is already in the table, the DATABridge Client modifies the record in the table instead.