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:
bcp_delim
bcp_decimal_char
For all relational databases:
statistics_increment
show_perf_statistics
show_statistics
show_table_stats
statistics_increment
max_temp_storage (Windows only)
max_clone_count (-s option only)
controlled_execution (dbutility only)
min_check_time
stop_after_given_afn (dbutility only)
stop_after_fixups
linc_century_base
inhibit_ctrl_chars
inhibit_8_bit_data
convert_ctrl_char
error_display_limits
discard_data_errors
suppress_dup_warnings
display_bad_data
century_break
enable_optimized_col
enable_optimized_sql
use_ext_translation
eatran_dll_name
- Enter the following command:
dbutility [signon_options misc_options] process datasource
Where
|
Is
|
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:
-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.
|
datasource
|
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.