Archives of the TeradataForum
Message Posted: Wed, 24 Jun 2015 @ 21:56:46 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|