#DateForumTypeThreadPost
1305 Apr 2016 @ 08:32 PDTDatabaseReplyExclude databases from TARA job backupThanks a lot. It works!
1204 Apr 2016 @ 09:13 PDTDatabaseTopicExclude databases from TARA job backup I have a TARA job which backs up everything under dbc excluding dbc. The following is part of the arc script which works   . . . ARCHIVE DATA TABLES ("DBC...
1113 Jan 2016 @ 12:25 PSTDatabaseTopicRestore a backup taken with Teradata ABU on another serverHello,   I have a backup which was taken using ABU 14.10 that is consisted of 4 data files(4-node configuration) - size is about 1.5 TB. I want to restore this backup on another server which...
1012 Oct 2015 @ 10:44 PDTGeneralReplyHow to calculate the space of a database that data will be copied using arcmainIndeed the database was very small thus it required more space.    My database is 7MBs after decompressions but in order to restore(COPY) it back i needed a space 7MBs * 15.   I ...
912 Oct 2015 @ 09:29 PDTDatabaseReplyAccess rights of dropped DatabaseThanks both of you for clarifying the above.
804 Oct 2015 @ 08:34 PDTDatabaseTopicAccess rights of dropped Database  Hello     Let's say that i have  a database D1_DQ for which there are a number of roles with rights assigned on it like the ones below:  ...
701 Oct 2015 @ 07:35 PDTGeneralReplyHow to calculate the space of a database that data will be copied using arcmainHello again and thanks for aswering. SOrry I have made a mistake. The actual error i get is Failure 2843:No more room in database.  The no more spool space error is refering to the...
630 Sep 2015 @ 02:03 PDTGeneralTopicHow to calculate the space of a database that data will be copied using arcmainHello Guys   I have a Teradata 14.10 on a TD 2690 appliance with BLC enabled on all tables.   I am using the TD Appliance backup Utility to copy backed up data from backup files into ...
517 Sep 2015 @ 05:28 PDTDatabaseReplyTemporal usage classic scenerio Hello i tried this but is not working. It doesnt allow me to use this on my update stament. Any other suggestion?
416 Sep 2015 @ 01:58 PDTGeneralReplyHow to apply custom period of validity for valid time tables during the updatesHello there. I am facing the same problem. What do you mean you convert the data into a temporal result set? How can i do that? Thank you very much.
323 Jan 2015 @ 01:36 PSTDatabaseTopicDisk IOs in Teradata 14.10I am very concerned with the Disk IOs of my Teradata server. I have ran the following query SELECT SUM(CPUTIME), SUM(Diskio) FROM DBC.AMPusage WHERE AccountName='TEST_ACC' GROUP BY...
224 Nov 2014 @ 11:37 PSTDatabaseTopicDelete old records from a table after a period of timeThe problem: I have a log table that will have a large number of individual inserts or rows each day(about 500). I want to find a way to be able to delete all the lines that are for example more ...
130 Oct 2014 @ 03:35 PDTDatabaseTopicMemory usage on Teradata SLES linux serverFirst of all i am new to Teradata.   My question is related to the 'normal' memory consumbsion on a small TD server such as mine.  The sever in question is a 2 node machine(TD ...