Archives of the TeradataForum
Message Posted: Mon, 07 Apr 2003 @ 11:36:27 GMT
Does anyone do anything which will remove all blocks/locks prior to doing a backup? I have a couple occasions where someone has a lock on a table that the backup has hung.
Immediately prior to the backup, I run the following script. This doesn't seem to clear all locks though.
LOGON asfp/dbc, twobad;
I run my backups using asf2.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|