To isolate performance problems with backup jobs, you can create files that test incoming data paths. A backup job obtains the data from the Teradata Database and writes it to NULL.
- Use the Appliance Backup Utility GUI to create a Backup Selected Objects job, configured with one stream per Appliance Backup Utility client.
- Select at least one database table greater than 1 GB.
- Click Build ARC script.
- Click OK.
- In the Script Options dialog box, enter a job name.
- Click Preview to edit the job.
- In the Script Editor, change FILE=ARCHIVE; to FILE=_DUMMY;.
- [Optional] If you want to run the job more than once, click Save.
- Click Launch.
-
After the job completes, use the ARC output to calculate the rate of bytes transferred for each stream by dividing the table byte count by the number of elapsed seconds.
09/22/2010 12:06:37 ARCHIVING DATABASE "HISTORY" 09/22/2010 12:06:37 ARCHIVING DATABASE "HISTORY" 09/22/2010 12:07:14 TABLE "HIST16G" - 8,724,338,948 BYTES, 16,777,574 ROWS ARCHIVED FOR THIS STREAM
In the example, the rate is 224 Megabytes per second (8,724,338,948 bytes/37 seconds/1,048,576 bytes).