Monitor a Mass Ingestion Specification in the Administrator Tool
You can monitor a mass ingestion specification in the Administrator tool. Monitor the application and the ingestion mapping jobs that ingest the source tables that you configure in a mass ingestion specification.
Monitor the Application and Ingestion Mapping Jobs
Monitor the application and ingestion mapping jobs on the Monitor tab. You can view statistics on the Summary Statistics tab or the Execution Statistics tab.
Summary Statistics
On the Summary Statistics tab, you can view summaries of multiple applications and ingestion mapping jobs. The summaries provide details on object distribution, object state, and Data Integration Service resource usage for a specified time range.
You can choose one of the following options to view a summary:
- •Graphical distribution. Displays visual data on the application and mapping job distributions.
- •Tabular distribution. Displays the total completed, running, canceled, aborted, and failed jobs.
- •Details. Displays a list of the application or mapping jobs, requests, or connections that are involved
- •Export data. Exports the detail data for a specific application or mapping job to a .csv file.
For more information, see the Informatica Administrator Guide.
Execution Statistics
On the Execution Statistics tab, you can monitor the application and the ingestion mapping jobs that run on a Data Integration Service.
You can select an application in the Navigator. The contents panel shows the following views:
- •Properties view. Shows the general properties and run-time statistics. Use the properties view to view additional information about the application and mapping jobs in the application.
- •Reports view. Shows monitoring reports. Use the Reports view to monitor reports about the application and mapping jobs.
You can browse to the deployed mapping jobs in the application to view information about the ingestion mapping jobs that ingest the source tables in a mass ingestion specification.
The following image shows the Execution Statistics tab for a deployed mapping job:
- 1. Data Integration Service. The Data Integration Service where the mass ingestion specification is deployed.
- 2. Application. The application that runs the mapping jobs in a deployed mass ingestion specification.
- 3. Deployed mapping jobs. The mappings that perform the ingestion jobs configured in the mass ingestion specification.
- 4. Contents panel. The properties that describe the mapping jobs.
- 5. General properties. The properties that summarize a mapping job.
- 6. Execution plan. The Blaze, Spark, or Hive execution plan that summarizes the job statistics on Hadoop.
The following table describes the information that you can view in the contents panel for a deployed mapping job:
Property | Description |
|---|
Name | The name of the mass ingestion specification associated with the mapping job. The name appears in the following format: m_<mass ingestion specification name> |
Job Name | The name of the source table that the mapping job ingests. The name appears in the following format: <source table name>_m_<mass ingestion specification name> Sort the mapping jobs by job name to quickly find the mapping that ingests a source table. |
Type | The job type that defines a task in the mapping. |
State | The status of the mapping job. |
Job ID | The Job ID that identifies the mapping job. |
Started By | The user who initiated the mass ingestion specification run instance. |
Start Time | The time that the mapping job is initiated. |
Elapsed Time | The time that the mapping job requires to complete. |
End Time | The time that the mapping job is completed. |
For more information on execution statistics, see the Informatica Administrator Guide.
For more information on Blaze, Spark, and Hive execution plans, see the Informatica Big Data Management Administrator Guide.
Canceling Ingestion Jobs
You can cancel a running ingestion mapping job. You might want to cancel a job that stops responding or that is taking an excessive amount of time to complete.
When you cancel an ingestion mapping job, you cancel the mapping that performs the ingestion job for a source table in a run instance of a mass ingestion specification. If you monitor the mass ingestion specification from the Mass Ingestion tool, the source table status displays Canceled.
After you cancel an ingestion mapping job, you can reissue the mapping to restart the ingestion mapping job for the source table. You can also restart the ingestion mapping job from the Mass Ingestion tool.
If a large number of jobs in the mass ingestion specification stop responding, you can abort all of the jobs from the command line.
For more information, see
abortRun in the "infacmd mi Command Reference" appendix.
1. Click the Execution Statistics view.
2. In the Domain Navigator, expand a Data Integration Service.
3. Expand the application that contains the information for a deployed mass ingestion specification and select Deployed Mapping Jobs.
A list of jobs appears in the contents panel.
4. In the contents panel, select the ingestion mapping job.
5. From the Actions menu, select Cancel Selected Object.
6. To restart the ingestion mapping job, select Reissue Selected Object.
