Archives of the TeradataForum

Message Posted: Wed, 24 Jun 2015 @ 21:56:46 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Forum -

I am trying to copy the DDLs only using ARCMAIN (actually from ABUGUI). The script completes with warning, which I guess should be OK. However when I am trying to access the tables, it's throwing the error -

2654: Operation not allowed: Table is being restored.

I understand when you are doing a multi stream DATA restore, you will need to BUILD the table after the restoring each stream and you get this error, if you try to access the table before running the BUILD. But here, I am only trying to copy the DDLs. Here is my COPY script. Am I missing to do anything here? I also tried to release the locks thinking the database could be locked, but that was not the case.

     JOB DR_DDL_RES_JUL
     SESSIONS 30
     MULTISTREAM 1
     STREAM SMP001-8
     STREAMNAME WK_DDL_5581a0c40000002e_DSTREAM0001
     COMMANDLINE VBMASK=8199 NOTHREAD
     TDPID local
     USERID abubackupuser
     SOURCEUID 5581a0c40000002e
     DESTINATIONPATH /var/abu_storage/BACKUPS SCRIPT Restore LOGON $LOGON; COPY DICTIONARY TABLES
         (DATABASE1)(FROM(DATABASE1)),
     RELEASE LOCK,
     FILE=ARCHIVE;
     LOGOFF;
     ENDSCRIPT

Thanks

Roopalini

	<Prev	Next>		<<First	<Prev	Next>	Last>>