#DateForumTypeThreadPost
525 Dec 2014 @ 12:53 PSTDatabaseReplyHow to decide about Stats for new queriesPerform an explain on the query. If the stats on one or more cols are not used in your query, drop them since they take up space in the dictionary table(s).
425 Dec 2014 @ 12:11 PSTDatabaseReplyConnecting Multiple Teradata ServersHi abhijit.p,   If you want to copy All AMP/cluster/specific-AMP table/database from one machine to another, You can give a try to NPARC without creating the dump file. There is no need...
324 Dec 2014 @ 11:14 PSTDatabaseReplyARC, can you recover, continue if a ROLLFORWARD operation fails?Hi SRUMBLE,   Yes, you can restart the job in case a "Lost connection" scenario in middle of the job while running through TARA. It is because the locks are still intact. &nb...
224 Dec 2014 @ 11:12 PSTDatabaseReplyARCMAIN giving Error 3802:Database '$ARC' does not exist.Hello zigzagdna,   $ARC is basically a database to keep track of catalog information in the table named as CATALOG by default. If $ARC database is not available and you supplied CATALOG...
124 Dec 2014 @ 11:04 PSTDatabaseReplyARCMAIN giving Error 3802:Database '$ARC' does not exist.Hi Divine786,   The dump file should be in the working directory where you invoked the script using ARC if you are running a standalone ARC utility. If you have submitted the job through TA...