#DateForumTypeThreadPost
35520 Feb 2008 @ 07:52 PSTToolsReplyMload Vs Insert/Select on a BIG table with PPIit looks like fastload to a staging table followed by an insert/select would work well for you ....
35420 Feb 2008 @ 07:50 PSTDatabaseReplyPartitioning with several columnswith 24 months of data , and some estimated grow per month on this 20 million, you would reach a point in 2 yrs that your table at any point would have about half a billion records. And there could...
35320 Feb 2008 @ 07:44 PSTUDAReplyStop Teradata services from command promptyou can shutdown the database bytpareset -x -y "stopping teradata"
35220 Feb 2008 @ 07:41 PSTUDAReplyCollect Stats n Refresh Statsdiagnostic helpstats is used to understand the optimizer recommendations of what stats it thinks might be useful in making a (probably) better query execution plan.you can do it by typing the follo...
35119 Feb 2008 @ 10:06 PSTConnectivityReplyJDBC Primary IndexAre you sure getIndexInfo() didn't work for you ?I recall my development team using something like that in the past to retrieve this information.Another way is to select from dbc.indices (make us...
35019 Feb 2008 @ 04:37 PSTAnalyticsReplyReg different error codes and Return codes in Teradatahttp://www.teradataforum.com/teradata_pdf/b035-1096-096a.pdf
34918 Feb 2008 @ 10:00 PSTDatabaseReplyDelete ALL taking too long(A) Check if this session is actually blocked (bug your DBA)If not (A) then start looking for skew, too much of indexes, triggers (who knows ?) etc .....
34818 Feb 2008 @ 09:58 PSTDatabaseReplyALTER TABLE and transient journalRenaming a column impacts only the dbc dictionary records so you shouldn't have any issues.
34713 Feb 2008 @ 10:42 PSTDatabaseReplyPartitioning with several columnsYou can't have a multi level partitioning unless you are in TD12.0...well you can derive an expression from two columns and partition on it say something like (mnth MOD 12)*100 + (model mod 100) +...
34611 Feb 2008 @ 08:49 PSTUDAReplyWHAT DOES DBC MEANS IN TERADATA?Actually it stands for Database Computer.The first teradata system was DBC/1012 where 1012 is nothing but 1 Terabyte (10 to the power of 12)
34511 Feb 2008 @ 08:03 PSTDatabaseReplyTeradata For Tranasactional applicationsIt's very critical that you take into consideration the concurrent aspects of the application for each and every query. TD (I guess it's more to do with the way parallel architecture RDBMS work wit...
34408 Feb 2008 @ 08:13 PSTDatabaseReplyWant to take back up at run timeMacros doesn't allow you to use "dynamic" sqls (which includes generating a tablename/columnname/where clause etc at run time), you can only pass parameters where it expects a constant valueie like...
34306 Feb 2008 @ 09:37 PSTUDAReplyCheck newline character in a text columnthat's only a bit of googling awayhere's one ......http://www.asciitable.com/
34206 Feb 2008 @ 09:48 PSTUDAReplyCheck newline character in a text columnThat's correct, it's the same as the ASCII value for newline in hex.
34105 Feb 2008 @ 09:26 PSTDatabaseReplyconverting from oracle to teradataTry rewriting the logic to something like this. (This may not be very accurate as I am not sure what those oracle functions do, but this should be a good starting point for you if you are stuck !)A...
34005 Feb 2008 @ 09:04 PSTUDAReplyCheck newline character in a text columnSELECT * FROM MyTableWHERE MyCharCol LIKE '%' || x'0A' || '%';
33905 Feb 2008 @ 10:43 PSTDatabaseReplyQuotation(') in Data to be quariedcan you try this .......select NAMEfrom TABLE_NAMEwhere NAME LIKE '%''%';
33830 Jan 2008 @ 06:13 PSTUDAReplyDisappearing Access RightsI faintly recall there was a teradata bug with similar symptoms... Did you check with GSC ?
33729 Jan 2008 @ 09:44 PSTDatabaseReplyHow we can find the No of AMP'S for the teradata DatabaseYou can do a SELECT HASHAMP()+1 to get the total number of Amps in the system.The number of Amps in the system are governed by various factors like your system capacity, number of nodes etc.... in ...
33625 Jan 2008 @ 11:59 PSTToolsReplyMload a COMP field from mainframelooks like you need to define an appropriate format...we had a similar discussion sometime back, see if this thread interests you.http://www.teradata.com/teradataForum/Topic10290-10-1.aspx
33524 Jan 2008 @ 06:40 PSTDatabaseReplyOracle to Teradata MigrationTeradata V2r6.x doesn't support ANSI merge, it's supported only from TD12.0......As far as logs as concerned, most of the shops I have worked, uses a stored proc to insert into some "log tables" (s...
33423 Jan 2008 @ 06:46 PSTDatabaseReplyCan PE distribute tasks to AMPs on another node (not in clique)It's irrelevant as to which node a PE is or AMPs are.... that's because they all talk to each other irrespective of their "node" boundaries what amps a PE would communicate with is dependent on eac...
33321 Jan 2008 @ 04:02 PSTToolsReplyFastexport outputCan you try explicitly casting your final column list to CHAR(n) types..ie likeSelect (substring(cast(cus_idr as char(10)) from 1 for 10)||',') (CHAR(11)),cast(count(*) as char(3))from d_eiadb.dqrs...
33221 Jan 2008 @ 11:14 PSTToolsReplyFastexport outputcan u post ur table DDL, the new fast export script and a sample output of your sql run from queryman...
33121 Jan 2008 @ 10:36 PSTToolsReplyFastexport outputDid you specify MODE RECORD in your EXPORT statement ? By default it's INDICATOR MODE and would show up as control characters.

Pages