|
|
|
|
|
The following are examples of the util utility:
Export job processing definitions
The following command exports job processing definitions from the default Control‑M/EM database to the ASCII data file production for database user dbuser1, whose password is secure01:
util -U dbuser1 -P secure01 -export -type def -file production
Import calendar data
The following steps are used to import calendar data from the ASCII data file month_cal to the default Control-M/EM database:
Stop all Control-M/EM database gateways.
Specify the following command:
util -U dbuser1 -P secure01 -import -type cal -file month_cal
Delete database contents
The following command deletes the contents of the folder A0301190CT_BJOB from database CITIES:
util -D CITIES -U dbuser1 -P secure01 -delete -name A0301190CT_BJOB
Clean the database
The following command cleans database WAGE_RATES:
util -D WAGE_RATES -U dbuser1 -P secure01 -clean_database
Build a database schema
The following command builds a new schema for database PAYROLL:
util -D PAYROLL -U dbuser1 -P secure01 -build_schema
Export a database definition folder
The following command exports the INVENTORY definition folder for data center WIP from the default Control-M/EM database to the file wip_stores:
util -U dbuser1 -P secure01 -export -folder INVENTORY \
-dcname WIP -file wip_stores
Import a database definition folder
The following command imports the WORK_IN_PROGRESS definition folder (replacing any data that may have been in this database folder) from file wip_stores to the PRODUCTION database:
util -D PRODUCTION -U dbuser1 -P secure01 -import \
-replace -folder WORK_IN_PROGRESS -file wip_stores
Parent Topic |