Arcmain table load progress while copy/restore locking

Database
Enthusiast

Arcmain table load progress while copy/restore locking

We are using 13.10 and currently copying a table from one database to another and it's quite large (and yes, we are planning to partition it very soon).

Performing an arcmain archive and copy commands for a single table will work but the copy can take some time.  I couldn't find a way to see the progress of the copy process to estimate time of completion and to ensure we will not run out of perm space.  The table is locked so I can't count the rows and the dbc.tablesize table seems to only update when the copy is done so those won't work.  I assume there is some kind of indicator showing the progress of the copy, but I can't seem to find it, I hope that someone can provide something that I can try.

Thanks,

Noel

1 REPLY
Teradata Employee

Re: Arcmain table load progress while copy/restore locking

Try the VERBOSE run-time option in ARC to periodically report row counts. The qrysessn utility can also be used to display details on I/O done by the child sessions.