To clone a DMSII database via dbutility process
- 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 D.)
For Microsoft SQL Server:
For Oracle and DB2:
For all relational databases:
max_temp_storage (Windows only)
max_clone_count (-s option 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:
SQL Server or DB2:
[-U userid] [-P password] [-O ODBCdatasource]
[-U userid] [-P password] [-D database]
Any of the following miscellaneous command line options:
-L forces the client to use a new log file for this run.
-T fileprefix to specify a prefix to be used instead of the default trace prefix ("trace")
-f filename to specify a configuration file other than the default dbridge.cfg file in the working directory
-w (toggle for use_dbwait in dbridge.cfg)
-K inhibits the audit file removal WFL from being run on the host
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.