Archives of the TeradataForum
Message Posted: Fri, 16 Mar 2001 @ 19:29:38 GMT
| Subj: | | Re: Real-time loading and transformations |
| |
| From: | | Mary M. Conley |
This may not be exactly what you are looking for .....
At AT&T, my production Teradata system is used for OLTP, in which we only allow 1 & 2 amp operations while the on-lines are up.
Therefore we severely limit queries of the data by users. To compensate for this, we keep a copy of the data on another machine for users
to access. We have implemented a process where every 60 minutes we apply the updates from production onto the copy database. We have
journaling on the tables in both databases.
We began the process by Arcmain dumping the tables and journal from production, and then Arcmain copying the tables and journal to the
copy database. Then every 60 minutes we dump the production journal and apply the updates to the copy database and then roll forward. The
only time we stop the hourly process is when we are dumping production. Once a month we totally refresh the copy database from production.
All of these processes are controlled by our MVS scheduling system.
Shelly Conley
AT&T
| 
