Troubleshooting Incoming Data Paths - BAR

Teradata Appliance Backup Utility Installation and User Guide

Product
BAR
Release Number
16.20
Published
November 2017
Language
English (United States)
Last Update
2018-07-13
dita:mapPath
myx1512701901323.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3134
Product Category
Teradata Tools and Utilities

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.

  1. Use the Appliance Backup Utility GUI to create a Backup Selected Objects job, configured with one stream per Appliance Backup Utility client.
  2. Select at least one database table greater than 1 GB.
  3. Click Build ARC script.
  4. Click OK.
  5. In the Script Options dialog box, enter a job name.
  6. Click Preview to edit the job.
  7. In the Script Editor, change FILE=ARCHIVE; to FILE=_DUMMY;.
  8. [Optional] If you want to run the job more than once, click Save.
  9. Click Launch.
  10. 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).