Archives of the TeradataForum
Message Posted: Mon, 22 Feb 2010 @ 22:40:25 GMT
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?
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023