Archives of the TeradataForum

Message Posted: Sun, 23 Sep 2002 @ 03:20:02 GMT

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

I worked on a UNIX Data Warehouse project where the data came from MVS. We needed to maintain audits on data that was pre-processed on MVS and through the multiple UNIX steps.

This was accomplished by creating a control table in Teradata on UNIX. MVS processing sent an audit file to UNIX that contained the process program, number of records in, number of records out and control totals for selected columns. This was loaded into the control table. Each step in the UNIX process created the same type of control record. We even did validation of control information between steps to verify no records were lost. In addition an activity table was created and each UNIX process would insert a start record at the beginning and an end record as the end. This allowed timings to be calculated to identify long running processes.

Wayne N. Moran

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