All Forums UDA
kondalmrao 8 posts Joined 02/05
23 Dec 2008
Problem after ARCMAIN import

Hello experts,We have received an arcmain dump(of only table definitions of all tables expect DBC) from one of our teradata servers. We have imported the same into our dev environment. For the first time, the import has failed as one of the databases has too little permanent space even to create empty tables. and later, once we allocated the space, we re-ran the job and it was successful. But, we are not able to access any table and we are getting the following error. "2654: Operation not allowed: is being restored."Below is one of the sample scripts that we have used. (we have imported around 10000+ objects with a similar query)LOGON dbc/userid,password;COPY DICTIONARY TABLE (database.tablename) (FROM (database.tablename)),RELEASE LOCK,FILE=BKP ;LOGOFF;Has anyone faced this issue before? Let me know what could be the potential problem. Appreciate your help in this and thanks in advance.RegardsKondal

lateshpant 16 posts Joined 01/08
24 Dec 2008

Probably there is a stale lock ( may be left over due to the copy failed the first time)Try explicitly releasing the lock....

vikram.kishore 2 posts Joined 12/08
25 Dec 2008

Hello Kondal ,you need to build the DB objects in order to access them.here is the sample build sript in arcmain.LOGON dbc/userid,password;BUILD DATA TABLE (database.tablename) ;Hope it works ...regardsvikram

teradatauser2 236 posts Joined 04/12
14 Oct 2012

Hi,
I did a dictionary archieve of a table and then did a restore
COPY dictionary tables
( db2.tab )   (from  ( db1.tab)),
RELEASE LOCK,
FILE=file;
 
I was able to do a show on the table.
When i do a sel * from db2.tab, i get error  : "2654: Operation not allowed: is being restored."
 
Then, i did a build table
BUILD DATA TABLE
(db2.tab);
. Now, when a do a show table or a sel * from db2.tab, the query goes for a toss, it just keeps on executing (then i abort it). Even a explain goes for a toss, keeps on executing and doesn;t show any result.
Other tables in db2 are accessible.
 

teradatauser2 236 posts Joined 04/12
15 Oct 2012

Hi Everybody,
Thre is no reply on this yet ..could anyone help me here

teradatauser2 236 posts Joined 04/12
18 Oct 2012

use this, this works..

BUILD DATA TABLE
(db2.tab),
release lock;

597536 2 posts Joined 12/13
19 Nov 2015

Hi Dear,
 
If you are running any ARCMAIN jobs and it gets failed/aborted, then you must have to release HUT(Host Utility) Lock . Please find the below systnax
RELEASE LOCK <DATABASENAME>, ALL,OVERRIDE;
Post releasing lock , please start copying data/dictionary. Hope this will help.
 
Thanks
Mohd Faizan

Thanks & Regards
Mohd Faizan Ahmad
Teradata Developer

You must sign in to leave a comment.