Archives of the TeradataForum

Message Posted: Thu, 03 Feb 2011 @ 12:13:20 GMT

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

Hello,

Not sure if exactly this is the reason

Releasing Application Locks

The IN APPLY option of the RELEASE MLOAD statement releases the application locks on the target tables that satisfy one of the following conditions:

- No changes have been made to the table . The table is empty and has no permanent journals . The table has no fallback, no NUSIs and no permanent journals If none of these conditions is true, and the table has no permanent journals, then the MultiLoad utility changes the application lock to a restoration lock that prevents the MultiLoad utility from restarting and allows the following table accesses:

- DELETE ALL

- DROP FALLBACK

- DROP INDEX

- DROP TABLE

- SELECT with access lock

Is the lock Waiting for Perm/Temp journals to complete (Not sure a guess)

Thanks

Machha

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