You can also specify values for staging and target database tags at the system level. Specify at the system level by executing the save_configuration command, the same command used to set other Data Mover configuration properties.
When staging_database, staging_database_for_table, and target_database tag values are specified at the system level, Data Mover applies them to all table objects included in the job request. If these values are supported for non-table objects, you must specify them at the object level.
A new property named system.default.database.enabled controls the system level default values for the target and staging databases. For each target system, you can set three values for the default databases. Within the systemLevelDatabase element, the system tag is mandatory and the databases tags are all optional. Here is an example of the new property in the save_configuration XML file:
<property> <key>system.default.database.enabled</key> <value>true</value> <defaultDatabases> <systemLevelDatabase> <system>targetSystem1</system> <!-- Tdpid here --> <staging_database>stagingDB1</staging_database> <staging_database_for_table>stagingDBForTable1</staging_database_for_table> <target_database>targetDB1</target_database> </systemLevelDatabase> <systemLevelDatabase> <system>targetSystem2</system> <!-- only specify the target database for targetSystem2 --> <target_database>targetDB2</target_database> </systemLevelDatabase> </defaultDatabases> <description>Purpose: Enable/Disable the default target/staging databases at the system level. Default value false means disabled.</description> </property>