Archives of the TeradataForum
Message Posted: Wed, 08 Jan 2003 @ 19:58:15 GMT
I can think of three ways to do this.
1. Select 1 from every table and see whether you get an error message. This works and can be encapsulated in a program, but it's slow.
2. Run CheckTable. In our shop, the DBA's do not have access to CheckTable, but maybe you do.
3. Run arcmain to archive the data to nowhere (/dev/null) and examine the output. Not the most elegant thing, maybe, but it's fairly fast.
For instance, if you archive to file=BLAKHOLE, the following command will send the archive to the bit bucket. This assumes that you have the MVS-style version of arcmain; I don't know whether this would work with the ASF2 version.
arcmain verbose2 "filedef=(BLAKHOLE,/dev/null)"
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|