Purpose
The cleanup command cleans up Teradata ARC, Teradata PT API, and Teradata JDBC tasks from a job that failed or was stopped before completing successfully. The command deletes staging, error, work, and log tables and releases HUT locks, depending on the underlying utility used for the job.
Syntax
Parameters
See Parameter Order.
- broker.port
- [Optional] You may enter a broker port to overwrite the default value specified in the commandline.properties file in order to connect to a different ActiveMQ server (and therefore a different daemon) at runtime.
- broker.url
- [Optional] You may enter a broker URL to overwrite the default value specified in the commandline.properties file in order to connect to a different ActiveMQ server (and therefore a different daemon) at runtime.
- job_name
- Name of the job to be cleaned up.
- security_password
- [Optional] Password for the super user or authorized Viewpoint user.
- security_password_encrypted
- [Optional] Encrypted password for the super user.
- security_username
- [Optional] User ID of the super user or authorized Viewpoint user. The user ID of the super user is dmcl_admin and cannot be changed.
Usage Notes
When cleaning up a:
- Teradata ARC job, scripts are generated for the source and target systems to release any table locks and turn off online archiving. Any running Teradata ARC process for that job instance is terminated.
- Teradata PT API job, existing target log, work, error, and staging tables are dropped.
- Teradata JDBC job, existing target staging tables are dropped.
The cleanup command only cleans up job instances that are not currently running. To clean up a currently running job, stop the job and then run cleanup.
XML File Example
For the cleanup command, type datamove cleanup -f parameters.xml.
In the following example, the parameters file cleans up database artifacts that are left by the stopped or failed job 12315DFHJKS:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?> <dmCleanup xmlns="http://schemas.teradata.com/dataMover/v2009" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.teradata.com/unity/datamover.xsd"> <job_name>12315DFHJKS</job_name> </dmCleanup>