How to do it...

  1. Connect to the Teradata arcmain utility:
  1. Log in using the archive user to execute the backup job.
  2. Copy the following statement and execute it in the arcmain window. Save the file with the PPITBL_Bckup_2018.arc name:
  1. Execute the file using the following command. This command needs to be executed from the arcmain window and not from bteq or the command prompt:
/*Execute arcmain*/arcmain < ppitbl.bckup_2018.arc.txt
  1. You can check the log to check the progress of the job.

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.