Archives of the TeradataForum

Message Posted: Wed, 23 Jul 2003 @ 21:12:48 GMT

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

When ARCMAIN is running you cannot create or drop tables in the database. Inside the ARCMAIN command or script, there should be a "RELEASE LOCK" line, which once the ARCMAIN job is completed, lifts the restrictions on running DDL.

I haven't observed this via PMON as of yet but if you are using WinDDI or Teradata Administrator, any DDL statements will hang (wait) with the stopwatch running. You will not get any error message indicating a reason for the wait.

Boyan

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