Archives of the TeradataForum

Message Posted: Fri, 19 Jun 2009 @ 08:17:16 GMT

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

Can you insert or update data in the tables? Can other people delete data from this database's tables? If not, then it is possible that dbc has backed up this database and forgot to release the archive lock.

Blocking your query is in fact the correct thing to do, even if you don't want it to be blocked.

Assuming I'm correct about the archive lock, you will need to get dbc to run an arcmain script containing the "release lock" command.

Example:

     Release lock (db_that_is_locked);

Teradata Corporation
Glenn McCall
Canberra Australia

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