I did a dictionary archieve of a table and then did a restore
COPY dictionary tables
( db2.tab ) (from ( db1.tab)),
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
. 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.
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.