#DateForumTypeThreadPost
14603 Nov 2013 @ 10:22 PSTToolsReplyBTEQ login errorHi, Did you make change to this host file: C:\WINDOWS\system32\drivers\etc\hosts   and have these entries: 127.0.0.1 localhost cop1   127.0.0.1 localhost dbccop1  ...
14503 Nov 2013 @ 09:39 PSTViewpointReplyAWT Max LimitHi,   It can be in the Priority Distribution screen. I am not pretty sure. Cheers, Raja
14403 Nov 2013 @ 08:43 PSTUDAReplyARRAY Structure in Teradata Stored Procedure Hi,   It is very much there , distinct and structure.   After defining your type say x_udt, you can insert values ....like  insert into tab values(NEW x_udt()....
14303 Nov 2013 @ 08:30 PSTGeneralTopicPMPC subsystem Can anyone explain to me about PMPC subsystem? Where it resides? How to connect to it, to customize standard performance tools and reports? Please provide sample code.   Thanks ...
14203 Nov 2013 @ 08:27 PSTGeneralTopicpreprocessor2Hi, Is preprocessor2 sitting between CLI and MTDP? In which language it is written?   Thanks and regards, Raja
14103 Nov 2013 @ 05:40 PSTDatabaseReplyTrigger calling StoredProcedureDoes it hold true in TD 14.10 also? Thanks and regards, Raja
14002 Nov 2013 @ 07:47 PDTGeneralTopicDown Subtable Recovery Hi,   Upto what percentage can Teradata db isolate file system errors to spcific data or index subtable?     Thanks and regards, Raja
13902 Nov 2013 @ 02:29 PDTCloud ComputingTopiclogmech for cloudHi, Can anyone help me explaining  the  ways and means, login mechanisms to cloud using Teradata. Thanks and regards, Raja
13802 Nov 2013 @ 01:08 PDTViewpointReplyDSAHi Dieter, Thanks a lot. I wish I can attend presentation at Partners but I have no chance. Btw, I am curious about the features dsa can do and ARC cannot do.   Thanks and regards, R...
13701 Nov 2013 @ 10:20 PDTDatabaseReplyHow to simplify query that runs out of spool space?Hi, Why can't you post your explain here so that we can analyze , the demography, steps etc. Cheers, Raja  
13601 Nov 2013 @ 09:33 PDTViewpointTopicDSA Hi, Data stream architecture replaces ARC. Can DSA be connected to TD 13.10? What are the features dsa can do and ARC cannot do? Thanks and regards, Raja
13501 Nov 2013 @ 06:28 PDTToolsReplyMultiload with date in where conditionHi, Did you try casting  (date, format 'mm/dd/yyyy'). Cheers, Raja
13401 Nov 2013 @ 05:57 PDTDatabaseReplyPI for slowly changing data table Hi, It is purely driven by requirements:   My first thought is this way (But when you spell out the requirements more then we can drill further down):   I think you ne...
13301 Nov 2013 @ 05:14 PDTDatabaseReplyspool vs free cylinder in Ferret show space outputHi Dieter, What are the crietria that we propose that these many cylinders are needed say for extreme data appliance or DW appliance? Upto what extent cylinders can strecth to support spool, perm,...
13201 Nov 2013 @ 05:03 PDTGeneralTopicBackground tasksHi, In TD14.10, may I know what are the background tasks performed during idle CPU time? Thanks and regards, Raja
13101 Nov 2013 @ 01:42 PDTViewpointReplyTASM Portlets are temporarily Unavailable, how to get them back online?Hi, Can you check with data collect services?  Maybe this will help. dcs stop/start in /etc/init.d just my thought. Cheers, Raja
13031 Oct 2013 @ 09:25 PDTDatabaseReplyIdentifying HOTAMP / COLD AMPHi, I am not very sure how do we define hot or cold amp to be honest. I think you need to liase with you DBA also for this. However, I feel :  Teradata's smart mixed dynamic workload...
12931 Oct 2013 @ 08:19 PDTDatabaseReplySystem utilization/ System health queriesHi, I think you can get from these tables: DBC.DBQLogTbl -----Performance data of the query DBC.DBQLSqlTbl-----SQL text of the query DBC.DBQLObjTbl----- DB objects accessed by the quer...
12831 Oct 2013 @ 05:32 PDTDatabaseReplyhow to get maxmum/minimum number between multiple columns in a rowHi, You can take union all of all the fields so that they are in a row and then take min and max.   Note : Just an example ::::::::::::::select sjan from yy where id=1 union all..select sfe...
12730 Oct 2013 @ 12:12 PDTDatabaseReplyTotal number of AWTs I think this is what you are looking for   http://developer.teradata.com/blog/carrie/2011/10/reserving-amp-worker-tasks-don-t-let-the-parameters-confuse-you   In additi...
12629 Oct 2013 @ 01:02 PDTData ModelingTopicSliding/Single Window Merge JoinHi, May I know the corrective measures(modeling or technical solutions) for sliding/single Window Merge Join when there are many noneliminated combined partitions. Thanks and regards, Raja
12528 Oct 2013 @ 09:55 PDTDatabaseReplyRow-Key based merge join vs. RowHash Match Scan + Sliding Window joinHi, Can we conclude that sliding window joins  performs slower than a Merge Join or Rowkey-Based Merge Join when we have  many non-eliminated partitions ?   Thanks and regards, R...
12428 Oct 2013 @ 03:01 PDTGeneralTopicHTMemAlloc and SkewAllowanceHi, HTMemAlloc and SkewAllowance are made 2 and 75.What drives these numbers to optimize the HI performance? What happen if I put at the maximum?   Also  Thanks and regards, Raja
12325 Oct 2013 @ 11:28 PDTToolsReplyInsert select in Mload Hi,   I am trying to answer based on your question. In fact, there are various technical and business implications when you decide :).   It depends on the table structu...
12225 Oct 2013 @ 10:16 PDTData ModelingTopicrowkey vs hash-basedHi, I am at a loss for designing to choose, whether I should go for rowkey ....ie hash-based by partition or should I leave only hash-based. The reason, is that partition is taking extra 2 bytes. ...

Pages