Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Upgrade data from V12 to V13 via arcmain
 
From:   Joerg Mutsch

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016