#DateForumTypeThreadPost
37821 Oct 2008 @ 09:11 PDTToolsReplyImproving Loading Mechanism using Fastload"- (n) fastload target table will consist column name FIELD1, ..., FIELD235 where their type are varchar(200)."1. Are those fields really 200 byte each or is it just "i don't know/care about the ac...
37720 Oct 2008 @ 12:43 PDTDatabaseReplyConverting Timestamp to Date - Translation from Oracle Syntaxtrunc -> cast as datenvl -> coalescecoalesce(cast(a11.AUTHORIZED_DATE as date), DATE '4712-12-31')Dieter
37620 Oct 2008 @ 12:41 PDTAnalyticsReplyAbout PESQL Reference: Functions and OperatorsChapter 12: Hash-Related FunctionsHASHAMPExample 1If you call HASHAMP without an argument, it returns one less than the maximum number ofAMPs on the system.SEL...
37518 Oct 2008 @ 07:25 PDTToolsReplyImproving Loading Mechanism using Fastload"2. fastload to target(n) table where the target is not partitioned and no index (since i can determine the index, but is it possible to have NUPI in fastload?)."Each and every table in Teradata al...
37415 Oct 2008 @ 12:18 PDTToolsReplyImproving Loading Mechanism using Fastload40.000*40.000 = 1.600.000.000 rows/dayThat's a lot for a small 32 AMP system: 50.000.000/AMP/dayHopefully "summarizing" reduces that number significantly, otherwise you run out of space within a fe...
37315 Oct 2008 @ 11:48 PDTAnalyticsReplyAMPCHECKAs long as there's no AMP down, there will be no difference.But if an AMP is down and the job continues it will be slower, of course.Dieter
37215 Oct 2008 @ 11:39 PDTDatabaseReplyCompression In TeradataTeradata uses a "Dictionary Compression" storing a list of compressed values within the table header and just a bit combination indicating the actual value within each row.You'll find all the detai...
37115 Oct 2008 @ 11:34 PDTDatabaseReplyrowkeyJoe is right.rowhash + uniqeness value -> ROWID (pre-V2R5)partition# + rowhash + uniqeness value -> ROWKEY (V2R5+)But usually everyone is still using the term ROWID instead of ROWKEY :-)Dieter
37014 Oct 2008 @ 04:12 PDTToolsReplyTpump performanceEach and every table in Teradata always has a Primary Index and an Insert is always using it.Dieter
36914 Oct 2008 @ 04:04 PDTDatabaseReplyService not starting for 12.0 DBCheck if there's an old version of terasso.dll (wincli32.dll/tdusr32.dll) within \windows\system32 instead of \Program Files\NCR\Teradata Client\cliv2Dieter
36814 Oct 2008 @ 03:56 PDTDatabaseReply"DBS CRASHED OR SESSIONS RESET." error when using bteq on SolarisBased on DNS/hosts "dsserver" might resolve to a different (invalid) ip-address.Try to "ping dsservercop1" to check if it's the correct ip-address.Dieter
36714 Oct 2008 @ 03:52 PDTConnectivityReplyInstall Teradata SQL AssistantYou didn't specify on which OS you tried to install it. If it's on a 64-bit Windows, then the error is self-explaining.Else ...Btw, 7.1 is a quite old version, try 12 from the demo version instead ...
36614 Oct 2008 @ 03:38 PDTUDAReplyTimestamp with a value of "2008-07-07 16:41:60"The built-in function TIME is a FLOAT which is just formatted to look like a time. As a float it's following rounding rules, thus a value greater than xx:xx:59.50 will be rounded to xx:xx:60It's no...
36513 Oct 2008 @ 01:44 PDTDatabaseReplyService not starting for 12.0 DBOf course it's running, why don't you simply try to logon?Dieter
36411 Oct 2008 @ 09:43 PDTDatabaseReplyService not starting for 12.0 DBHi Rajesh,this looks ok, there should be some events following immediately with a source "Teradata" and they will tell you, if it started successfully or failed to start. But as already mentioned, ...
36310 Oct 2008 @ 01:37 PDTDatabaseReplyService not starting for 12.0 DBHi Rajesh,the recond service is just kicking off the start of Teradata and then stops.So your Teradata is probably already running, AFAIR there's a small tool to start/stop Teradata within the menu...
36210 Oct 2008 @ 01:33 PDTUDAReplyVolatile table in MainframeA volatile table is always created within the user, as the error message implies.If you check the Messages manual you'll find:Explanation: Volatile tables are associated with thelogin user. This er...
36109 Oct 2008 @ 05:00 PDTDatabaseReplyelementary questionWhy didn't you just try your Oracle query?ROW_NUMBER is Standard SQL and available in Teradata since several years. There's even an extension for filtering the result of the OLAP-function, similar ...
36002 Oct 2008 @ 03:53 PDTDatabaseReplyseeking Teredata DB paging solutionSQL Server introduced ROW_NUMBER in SS2005, but Teradata did it some years earlier in V2R4.Dieter
35902 Oct 2008 @ 03:49 PDTDatabaseReplyQuery Tuning1. Replace the NOT IN with a NOT EXISTS, because one of the columns is NULLable:AND p.prod_id not in (select prod_id from dp_dedw_rep.RepTbl_RecurProducts)-> AND NOT EXISTS (select * from dp_ded...
35820 Sep 2008 @ 04:10 PDTDatabaseReplyraw disks and error messagesOf course a new AMP must initialize it's filesystem. It's done through vprocmanager's initvproc (for a single AMP) or a sysinit (for all AMPs).I don't know what you're actually trying to achieve (h...
35719 Sep 2008 @ 03:48 PDTDatabaseReplyLinking a Table name to a table IdI don't know if it's possible to change showblocks output, but you can change the hex tableid to a decimal: HASHBUCKET(SUBSTRING(tableid FROM 2 FOR 1) || SUBSTRING(tableid FROM 1 FOR 1) (BYTE(4)))...
35618 Sep 2008 @ 05:25 PDTDatabaseReplyLinking a Table name to a table IdYou can change Ferret's default output format using the RADIX command:RADIX OUTPUT HEXDieter
35518 Sep 2008 @ 05:15 PDTDatabaseReplyraw disks and error messagesIt must be a unformatted primary partition without assigned drive letter.Dieter
35418 Sep 2008 @ 05:09 PDTDatabaseReplyCOLLECT STATS on combination of columns than single columnHi Siree,submit a "diagnostic helpstats on for session" and explain the query. At the end of the explain there will be the recommendation of the optimizer.Dieter

Pages