Arcmain question : Operation not allowed: table is being restored

Database

Arcmain question : Operation not allowed: table is being restored

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.

2 REPLIES
N/A

Re: Arcmain question : Operation not allowed: table is being restored

ARCHIVE DICTIONARY TABLES includes metadata only, i.e. DDL, but no data. 

I'm not shure, but IIRC a restore only inserts into the system tables, but doesn't create the table header.

It should be followed by a RESTORE DATA before the BUILD.

Of course this still doesn't explain why the select won't finish or fail.

Dieter

Re: Arcmain question : Operation not allowed: table is being restored

Hi Diether, thanks for reply. The problem was that my table was locked, I didnt use a release lock after Restore. The final code should be.

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