Archives of the TeradataForum

Message Posted: Mon, 22 Feb 2010 @ 22:40:25 GMT

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

Hi all,

I loaded a set of tables and rows via arcmain into a Teradata V13 DB system on Linux. The content of the arcmain files has been created on a V12 DB system.

So after arcmain finished the load arcmain recommends to execute a macro (which I successfully did) and to run a certain script:

     'post_data_restore.bteq' located
     in /opt/teradata/tdat/tdbms/13.00.00.00/etc/

Within this script there is one command which somehow got stucked:

     DIAGNOSTIC "BYPASS ACCESS RIGHTS" ON FOR SESSION;

I run the command individually also via SQL Assistant even on a V12 DB system with the same effect. SQL Assistant is executing this command for 2 1/2 h without any result. I can not even stop it anymore without restarting the DB manually.

What is wrong with this command? I thought since it is a part of a BTEQ script provided with the DB installation it should work well. Did you ever experience any kind of same behaving on this command?

Thanks

Joerg

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