#DateForumTypeThreadPost
57829 Jul 2009 @ 03:09 PDTDatabaseReplyThoughts on CPUBusy caclulations.Of course you're correct :-) CPUIdle + CPUIoWait = cpu idle CPUUServ + CPUUExec = cpu busy Dieter
57729 Jul 2009 @ 02:57 PDTDatabaseReplySample duration in DBQLSummaryTbl 10 minutes is just the default, it might be changed to a larger value using dbscontrol general field 33. DBQLFlushRate Dieter
57624 Jul 2009 @ 02:41 PDTDatabaseReplyCan anyone format the DelayTime from DBC.QryLogTDWMV?Hi Richard, your calculation can't be the correct one. Events in chronological order: 1. query arrives at the PE, optimization starts = StartTime 2. query actually starts = FirstStepTime 3. ...
57523 Jul 2009 @ 06:11 PDTUDAReplyDifficulty Inserting records into Large tableHi Paul,that's exactly the info i needed. Your data is totally skewed, up to 5698859 rows with the same value mean a LOT duplicate row checks.If you can't change the PI, you should definitely chang...
57423 Jul 2009 @ 03:32 PDTUDAReplyDifficulty Inserting records into Large tableHi Paul,do a help stats for the PI-columnHELP STATS tablename COLUMN Irmf_Pyee_Id;to get the details for the PI.4.5m rows in 10 hours is ridiculous, i can do that in a virtual machine on my laptop....
57323 Jul 2009 @ 03:01 PDTUDAReplyDifficulty Inserting records into Large tableHi Paul,i edited my previous reply, i don't know why it didn't show that HELP STATS statement, just tried to use a bold font...That skew sounds bad, it's probably causing that bad performance.Chang...
57223 Jul 2009 @ 02:31 PDTDatabaseReplyCan anyone format the DelayTime from DBC.QryLogTDWMV?Hi Richard, up to 72/201 hours of delay? This is very strange, almost unbelievable. Are you on TD12? There's a Tech Alert NTA 2025, according to that DelayTime is in hundreths of a second :-) ...
57123 Jul 2009 @ 12:32 PDTUDAReplyRankYou're looking for a DENSE_RANK, there are several ways to calculate it:http://www.teradata.com/teradataforum/Topic9590-9-1.aspxDieter
57023 Jul 2009 @ 12:28 PDTUDAReplyDifficulty Inserting records into Large tableHi Paul,this is approx. 33 rows per value in average, this should be ok (especially if it's in different years).But the maximum might be totally different, so please do a help stats only for the PI...
56923 Jul 2009 @ 10:20 PDTDatabaseReplyProcess with Queue TableHi Nirmalya,check the "CREATE TABLE (Queue Table Form)" in the SQL DDL manual for all the details.Dieter
56823 Jul 2009 @ 10:15 PDTDatabaseReplyPPIHi Santosh,this is true if the table is partitioned by date and your loading current data.Then all the data is for a single (and probably empty) partition.Dieter
56723 Jul 2009 @ 10:12 PDTUDAReplyWhat are the advantages of Teradata over KickfireHi Raja,Kickfire is a columnar DBMS, but i don't know much more than that.You'll find some more info at Curt Monash's blog: http://www.dbms2.com/Dieter
56623 Jul 2009 @ 09:51 PDTUDAReplyDifficulty Inserting records into Large tableHi Paul,do a HELP STATS on the PI-columns of that table and look for the Mode Frequency to check for duplicates.Could you post that plus PI + partitioning?Dieter
56523 Jul 2009 @ 06:29 PDTDatabaseReplyCan anyone format the DelayTime from DBC.QryLogTDWMV?The dataype of DelayTime is an integer, but no time. If you want to convert it to time: DelayTime * INTERVAL '0000:00:01' hour to second Dieter
56420 Jul 2009 @ 10:09 PDTDatabaseReplyDBCMNGR.UserCounts This is probably a bug in the manuals: A column UserCnt is found in dbcmngr.LogSystemActivity, which is well documented. Dieter
56320 Jul 2009 @ 09:55 PDTDatabaseReplySELECT TOP N - odd behaviour (v2r6)Hi Pierre, you should open an incident with your Teradata support. If it's a plain "select top 10 * from table;", without ORDER/JOIN/WHERE that RETRIEVE-step should not happen. Dieter
56217 Jul 2009 @ 06:21 PDTAnalyticsReplyWill MLOAD able to Insert data into Global Temporary Tables !!!MLoad/FastLoad don't support GTTs, as it would be totally useless to load into an empty table using a single session and then delete all the rows at logoff. Multiple session would be even worse mea...
56116 Jul 2009 @ 03:01 PDTDatabaseReplyUseful system viewsHi David,dbc.tables has just the wrong name, you'll find tables, views, procedures. triggers, just everything in it.Check the Data Dictionary manual for a description of all the dbc views.Dieter
56016 Jul 2009 @ 02:59 PDTDatabaseReplysub queriesIf i understand correctly then you need an OLAP function instead of an aggregate:SELECT USERID, CRTN_DTTM, COUNT(USERID) OVER (PARTITION BY USERID) AS TICKET_GENERATEDFROM VEMEDY_SYM_TICKETWHERE CR...
55916 Jul 2009 @ 02:56 PDTDatabaseReplyCreating TwentilesAll rows with the same value are supposed to be in the same quantile, so this is correct behaviour.If you don't care about that rule then just modify the QUANTILE formula(RANK() OVER (ORDER BY bala...
55816 Jul 2009 @ 08:44 PDTDatabaseReplyStrange ProblemHi Ansh,check the setting of Tools - Options - Query - Use Manual Commit Mode for ANSI Sessions, it should be unchecked (see help).Dieter
55716 Jul 2009 @ 08:41 PDTUDAReplyBehaviour of adding numeric valuesHi Karen,this is due to SQL Assistant:set Tools - Options - Answerset - Display Full Accuracy for BigInt and Decimal (16) and Above Dieter
55616 Jul 2009 @ 05:48 PDTDatabaseReplyTeradata Database fileTeradata uses it's own filesystem on raw devices -> no file, no extension Dieter
55514 Jul 2009 @ 11:19 PDTDatabaseReplyDelayTimePlease define "delay time".The column DelayTime is only set for queries delayed by TDWM, it's in seconds.I think you just want the difference between the StartTime (SQL arrives at the PE) and the F...
55414 Jul 2009 @ 10:48 PDTDatabaseReplyAccess ProblemHi Ansh,you should better double check:SELECT *FROM dbc.allrights WHERE accessright = 'CT'AND GrantAuthority = 'Y'AND DatabaseName = 'database where table will be created'AND UserName = 'database w...

Pages