Archives of the TeradataForum

Message Posted: Sat, 16 May 2015 @ 17:21:41 GMT

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

Yes. This is what we do. After the job starts we run this tarajobquery command every 10 minutes until the backup completes or fails (If it fails we notify the DBA).

     /opt/teradata/tara/gui/bin/tarajobquery -j  -f  -l -u administrator -e
     /opt/teradata/tara/server/bin/tara.pwd

This generates a series of files (One for each stream) plus a few more.

The job ID we get by querying /var/opt/teradata/tara/server/jir.

We later read through each file, parse each line to total up how much has been backed up and the last object. This gives the size since when the backup started. This allows us to find a rate per stream and email the results as the backup is progressing.

We also start the tara job using /opt/teradata/tara/server/bin/taralaunch -u administrator -e /opt/teradata/tara/server/bin/tara.pwd -j

This way the backup is only started after the loads complete. In our case we only backup weekly so it works out.

Kiki Sanchez
Data Warehouse Group
Technology Division
United Airlines

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