To run the process command
- Make sure that DBServer or Enterprise Server is running. If it is not, the DATABridge Client will try to connect to the host and eventually time out.
- Make sure that your signon parameters are configured appropriately.
- If you plan to use the [EbcdictoAscii] section to customize character translation or any other parameters in the dbridge.cfg file, set them before you continue. In particular, make sure you have appropriate settings for the following parameters. (For information on setting these parameters, see Appendix C: Client Configuration.)
For Oracle and DB2:
For all relational databases:
max_temp_storage (Windows only)
max_clone_count (-s option only)
controlled_execution (dbutility only)
stop_after_given_afn (dbutility only)
- Enter the following command:
dbutility [signon_options misc_options] process datasource
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]
[-U userid] [-P password] [-D database]
[-U userid] [-P password] [-W] [-O ODBCdatasource]
Any of the following miscellaneous command-line options:
-f filename specifies a configuration file other than the default dbridge.cfg file in the working directory.
-s tells the client not to use the bulk loader.
-w (toggle for use_dbwait in dbridge.cfg)
-L forces the client to use a new log file for this run.
-K inhibits the audit file removal WFL from being run on the host.
-T forces the client to use a new trace file for this run, if tracing is enabled.
The name of the data source specified in the DBServer control file (DATA/SERVER/CONTROL) or via Enterprise Server.
If the DATABridge Client connects to DBServer, it selects all the data sets whose corresponding active columns have a value of 1 in the DATASETS table. Next, the DATABridge Client requests that DBServer clone all the selected data sets. At the end of the data extraction phase, the DATABridge Client issues another request to start sending the fixup records followed by updates. The processing of audit files continues until there are no more audit files available.
If the DATABridge Client connects to DBEnterprise, DBEnterprise supplies the data, either by reading the DMSII data set directly or by issuing a request to DBServer to have DBEngine read a block of data from a specific region of the disk. DBEnterprise then processes this block of data. Since DBEngine is only reading raw data and does not do any processing of this data, this mode of operations is much less expensive in term mainframe resource utilization. In the case of audit file data, DBEnterprise either reads gets the data from its caches (if configured), or it reads the audit file directly by issuing a request to DBServer to have DBEngine read a block of data from a specific region of the disk.
After cloning, use the data in the relational database as usual. When you are ready to update the relational database with changes made to the DMSII database, see Updating the DATABridge Data Tables.