Archives of the TeradataForum

Message Posted: Fri, 09 Oct 2015 @ 21:41:18 GMT


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

Subj:		Restore Error with ABUGUI

From:		Bakthavachalam, Roopalini

Hi Forum,

Below restore script fails with error "Stream file name improperly specified.". However I am specifying the right path where the backup streams are present. I tried all combinations of PATHs between STREAMNAME and DESTINATION PATH, however it keeps giving the same error. Any idea what's going wrong with this script?

All the backup streams are present in the path /var/abu_storage/BACKUPS

     JOB Tbackup_RB
     SESSIONS 16
     MULTISTREAM 8
     STREAM SMP001-2
     STREAM SMP001-3
     STREAM SMP001-4
     STREAM SMP001-5
     STREAM SMP001-6
     STREAM SMP001-7
     STREAM SMP002-2
     STREAM SMP002-3
     STREAMNAME DR_TABLE1_54b1cc9b00000174_DSTREAM0001
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0002
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0003
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0004
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0005
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0006
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0007
     STREAMNAME DR_ TABLE1_54b1cc9b00000174_DSTREAM0008
     COMMANDLINE
     CATALOG ON
     TDPID local
     USERID abubackupuser
     SOURCEUID 54b1cc9b00000174
     DESTINATIONPATH /var/abu_storage/BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS DESTINATIONPATH
/var/abu_storage/ BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS DESTINATIONPATH /var/abu_storage/
BACKUPS DESTINATIONPATH /var/abu_storage/ BACKUPS SCRIPT Restore LOGON $LOGON; SET QUERY_BAND='BLOCKCOMPRESSION=YES;';
     COPY DATA TABLES
             (DB1.TABLE1)(FROM(DB2.TABLE2)),
     RELEASE LOCK,
     FILE=ARCHIVE;

     LOGOFF;
     ENDSCRIPT


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

Attachments

Library

Quick Reference