#DateForumTypeThreadPost
6205 Jan 2010 @ 07:20 PSTUDAReplyData SynchronizationGut, I think it may depend on what you are using the copy of he data for. Are you updating a contingency site, which is lights out, and ready to take over after a short delay. Are you updating...
6105 Jan 2010 @ 01:35 PSTGeneralReplyTeradata Server restarts due to a 3rd Party ETL Jobdid you get a resolution to this? Its quite a worrying post . did the ETL tool cause the issue?
6004 Dec 2009 @ 07:51 PSTDatabaseReplyTDWM configuration data - purging practicesI had not noticed that . Thanks for the warning. Perhaps disabling the user would be a better practice rather than removal, on the other hand you could find unauthorised users having the accounts...
5925 Nov 2009 @ 06:35 PSTDatabaseReplyTDWM configuration data - purging practicesI find the old definitions too useful to delete. If you do any sort of historic checks against PDRCINFO.DBQLLogTbl_Hst its useful to join the TDWM.WLCdefs so that I can get the Workload defin...
5812 Nov 2009 @ 02:16 PSTThird Party SoftwareReplySAS BIGINT issue?One workaround was to create views to cast the offending bigint to Decimal(31), but this has serious performance overheads. Especially when the bigint is part of the Primary Key! Your thought...
5712 Nov 2009 @ 02:13 PSTThird Party SoftwareTopicSAS BIGINT issue?There is an issue with SAS 9 accessing Teradata databases that use BIGINT. Error ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine. ...
5620 Oct 2009 @ 02:34 PDTDatabaseReplyAllowing access on DBC tables/view. How risky it is?I Agree with Jimm, Re reading my post, it’s confusing. "Granting access to the tables" should have read Granting access to these tables" i.e the performance tables. Create views of the per...
5519 Oct 2009 @ 03:11 PDTDatabaseReplyAllowing access on DBC tables/view. How risky it is?Hi, A couple of other thoughts on this, all random.... Think about locking issues. Users could cause issues in locking, creating views on the tables with the required access semantics and gr...
5414 Oct 2009 @ 06:18 PDTDatabaseReplyThoughts on CPUBusy caclulations.Monis, Leo, Thanks for your kind words. In answer to another question earlier in the thread that I overlooked from Monis. The different Node sizes are catered for because you will run more AMPs...
5313 Oct 2009 @ 04:38 PDTGeneralTopicEmail Notification of replies to posts?Will this be available? its unusual not to have this feature, unless its my browser not displaying the options again! Random
5213 Oct 2009 @ 03:46 PDTDatabaseReplyThoughts on CPUBusy caclulations.Leo. (1) You should check CPUUsAGE for queries in DBQL, one statement per record. its easier I think. (2) a) b) depends on the query. the intensity of reading data from the disk and the conc...
5109 Oct 2009 @ 01:41 PDTDatabaseReplyThoughts on CPUBusy caclulations.Which is more precise? I would imagine that both are as accurate as each other, but I use them for different purposes. Resusagepma is good for providing general graphs on AWT CPU utilisation monit...
5009 Oct 2009 @ 01:38 PDTDatabaseReplyThoughts on CPUBusy caclulations.That is an interesting question.. I believe that the AMPCPUtime is the total USER CPU by the statement ignore the system, wait and idle time. The DBQL records one record for each statement; s...
4905 Oct 2009 @ 01:51 PDTDatabaseReplyThoughts on CPUBusy caclulations.@monisiqbal. Not sure about this. My calculation works out a percentage based on the total. it includes all the CPU seconds available. Thus if you had low power nodes in your environment, they...
4823 Sep 2009 @ 01:53 PDTDatabaseReplyTASM issuesHi, i have solved this issue. TASM will check each job at the end of each step, or at the delaytime setting set in the TASM manager. Ours was set high, and only checking every 10 minutes. T...
4721 Sep 2009 @ 01:27 PDTDatabaseTopicTASM issuesHi, Query on TASM. If we configure a group to have a MAXIMUM CPU utilisation of 60 Seconds, we would expect the query to migrate over to the next group when it reaches 60 Seconds. Why then d...
4607 Sep 2009 @ 12:55 PDTDatabaseReplyThoughts on CPUBusy caclulations.Shaik, Hi, I'll post some more information in next couple of days. I've just got back into office after being away for a while. In brief though, CPU_SYS is the same as CPUSERV, and is the percen...
4510 Aug 2009 @ 07:00 PDTTeradata ApplicationsReplyExperience of TRSWhoops, it was MadMac (Aka Micheal MacIntire), not MadMax. One is a Distinguished Architect at Ebay, the other a troubled soul in a post-apocalyptic world. Random
4410 Aug 2009 @ 06:49 PDTTeradata ApplicationsReplyExperience of TRS@Tiggr, you other question regarding Multiple instances. Would this be possible? The RSG process that handles the communication with the TRS server, is probably the bottleneck in this setup, not ...
4310 Aug 2009 @ 01:25 PDTTeradata ApplicationsReplyExperience of TRSYep, bulk deletes is a major gotcha, although I would sto short of calling it a quirk or a bug. TRS needs to take the before image of a row and transfer it to the remote site, to facilitate the ro...
4210 Aug 2009 @ 01:15 PDTDatabaseReplyTeradata compressionDo the columns from the different tables have the same data? Did you copy one table to another to test compression? Or are the tables Parent and Child? with the column being a Primary/foreign k...
4104 Aug 2009 @ 02:45 PDTGeneralTopicError on home page of Developer.teradata.com?Do other people see the errors in the home page of developer.teradata.com? Is it because I am still using IE6? (It is a hard habit to kick....) Its in the Pink bit above the Welcome to Teradata? ...
4030 Jul 2009 @ 08:50 PDTDatabaseReplyCPU usage of PE and RSG?Dieter, looking at that table there are 50 or so columns for CPU utilised? some of the views that look at PE or AMP usage only select and sum certain ones. Do you know where to find informati...
3929 Jul 2009 @ 07:36 PDTDatabaseTopicCPU usage of PE and RSG?Can anyone provide any information on how I can monitor the CPUI usage of the PE and RSG Vprocs?
3829 Jul 2009 @ 03:53 PDTDatabaseReplyIOWAIT on Teradata systemsOn our system , today for instance, we average WAITIO of24% with an average BUSY of 44%. At somepoints as overall usage goes up, all the IDLE time is effectively IOWAIT. Does this seem overley hi...

Pages