Problem after ARCMAIN import

UDA
Enthusiast

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.

Regards
Kondal
6 REPLIES
Teradata Employee

Re: Problem after ARCMAIN import

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

Try explicitly releasing the lock....

Re: Problem after ARCMAIN import

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 ...

regards
vikram
Junior Supporter

Re: Problem after ARCMAIN import

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.

Junior Supporter

Re: Problem after ARCMAIN import

Hi Everybody,

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

Junior Supporter

Re: Problem after ARCMAIN import

use this, this works..

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

Re: Problem after ARCMAIN import

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