Archives of the TeradataForum

Message Posted: Wed, 08 Jan 2003 @ 19:58:15 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Table being loaded during archive so it is skipped

From:		Geoffrey Rommel

Anomy wrote:

We take backups once a week at night on our test system. We always get messages that tables are skipped because they are in the process of being loaded.... We have found that most of these tables are locked from load jobs being canceled (not a good practice I know ). Does anyone have any programs they may have written to check for locks and release prior to backups?

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)"


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference