9000 Operation not allowed: the target table is being online archived

Reason:

A request to restore/rollforward/rollback/archive the target table while it is currently in the middle of another online archive job.

 

SQL to check whether ONLINE ARCHIVE is enabled or not 

select CreateTimeStamp,

DatabaseName (VARCHAR(30)),

TVMName (VARCHAR(30))

from DBC.ArchiveLoggingObjsV;

 

Solution:

·       Verify that the restore/rollforward/rollback job is not submitted on the table that is in the middle of online archive job.

·        Verify that only 1 online archive job is running concurrently for a given table.

Comments