Archives of the TeradataForum

Message Posted: Thu, 09 Feb 2006 @ 16:36:24 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

In addition to the TPumpStatusTbl TPump also supports the Notify Exit. This provides an interface for custom monitoring of performance, progress, errors etc.

The Orange Book 'Feeding the Active Data Warehouse' has a section discussing TPump monitoring. One interesting technique described is putting triggers on the TPumpStatsTbl to insert to a permanent table when TPumpStatusTbl rows are created, updated, and deleted. This enables both real time monitoring and trend analysis/tracking via SQL against this permanent table.

	<Prev	Next>		<<First	<Prev	Next>	Last>>