MultiLoad TMSM Integration
Teradata Multi-System Manager (TMSM) is the monitoring and control facility for a variety of Dual Active Solutions offered by Teradata. The expected users of this facility are administrators of the Enterprise Data Warehouse (EDW) such as Teradata Database administrators, ETL maintenance staff, systems administrators, or anyone who needs to monitor and control processes that include, but are not limited to, Teradata Load and Unload Utilities, Teradata SQL, ETL tools, and Teradata Database.
To integrate with TMSM, MultiLoad has been enhanced to collect operational metadata and event data, obtain the Unit of Work ID (UOW ID) from TMSM for a job, and send such data to TMSM for monitoring purposes using the “send event” interface as described in the TMSM Event System API Reference. By default, a MultiLoad job will send events to TMSM as long as TMSM is active. If TMSM is not active, the job will continue to run, except that no events will be sent to TMSM.
Simple ETL process monitoring requires the tracking of the “start” and “end” of the process, which can include multiple “steps”, each of which represents an activity or event of the process to be monitored. In terms of MultiLoad, a load job can be regarded as such a process.
MultiLoad follows the flow required by TMSM:
1 Obtain a system-generated UOW ID from TMSM for a MultiLoad job
2 Send a “start” event to TMSM along with the UOW ID
3 Optionally send one or more “step” events to TMSM along with the UOW ID
4 Send an “end” event to TMSM along with the UOW ID
Below is are examples of how MultiLoad job sends event messages to TMSM in order for the job to be monitored:
Start Event -- "Connecting sessions" message which contains a MultiLoad job ID, a TDPID.
Step Event -- "Task n: Acquisition begins" message
Step Event -- "Task n: Checkpoint completes" message
Step Event -- "Task n: Acquisition completes" message
For MultiLoad Import Task:
Step Event -- "Task n: Application completes" message which contains the number of rows inserted into each of the target tables (1 message per table)
Step Event -- "Task n: Application completes" message which contains the number of rows that were updated against each of the target tables (1 message per table)
Step Event -- "Task n: Application completes" message which contains the number of rows that were deleted from each of the target tables (1 message per table)
For MultiLoad Delete Task:
Step Event -- "Task n: Application completes" message which contains the number of rows that were deleted from each of the target tables (1 message per table)
End Event -- "Job terminating" message
For detailed information on setting up the TMSM environment, refer to the Teradata Multi-System Manager Installation Guide (B035-3202).