Settings Tab
In the Settings tab, you can configure the following:
- Compare DDL
- Select this check box to compare the DDL of source tables with those of the existing target tables.
- Overwrite existing objects
- Select this check box to set the default value to overwrite jobs.
- Disable fallback
- Select this check box to disable fallback when copying objects.
- Cleanup
- Data Copy has an internal repository that stores job data from previously run jobs. The cleanup service is enabled by default and jobs are deleted every 60 days. You can customize this setting to align with your business needs and designate cleanup based on the following in the cleanup setting:
- Age of data
- Percent of the repository is full
- Both age and percent full
A daily cleanup check is performed at the time you specify; and if the age or space threshold is reached, the excess data is deleted from the repository.
- Retries
- A Data Copy plan execution may fail to complete successfully if they are blocked because there are locks on source or target database objects. In addition, SQL execution may fail if a transaction is aborted due to a deadlock (Error 2631). You can configure the copy manager to detect these situations and attempt to restart the job or deadlocked transaction after time intervals you specify using the follow options in the retries setting:
- Blocked Jobs
- Deadlocked transactions
Event Log
You have the following options for logging events:
- Log events directly in Teradata Ecosystem Manager.
- Log events to an internal Event table that Data Copy manages.
- Log events on both Teradata Ecosystem Manager and Event table in Data Copy
You can set up one or more event table by selecting + icon or select the available event table and set as default.
Default Databases
In the Default Databases tab, you can configure and manage default target, source, and staging databases for tables and temporary artifacts. Copy plans use these defaults as their setting. You can configure defaults for the following:
- Target databases
- Source staging database for tables
- Target staging database for tables
- Target staging database for temporary artifacts
To configure a default database, do the following:
- Select + icon beside the type of default database you want to create.
- Log into the environment using your credentials.
- Select the database from drop down menu.
- Save the setting.