All forum activity

#DateUserForumTypeThreadPost
41701 Mar 2006 @ 09:42 PSTBarry-1604AnalyticsReplyhow to convert a period of D+30, D+60 etc to exact day and monthYou can do quite a bit with the dates without using SysCalendar. For instance, to add or subtract months, you can use the ADD_MONTHS feature:SELECT ADD_MONTHS(date_col, 2) /* this will add two mo...
41601 Mar 2006 @ 09:28 PSTBarry-1604UDAReplyfind out the number of nodes in a teradata architectureAssuming that all of your nodes were functioning yesterday and you have resusage data being captured (and you have access to resusage data), the following query would tell you the number of nodes:s...
41501 Mar 2006 @ 09:11 PSTvinod_sugurDatabaseReplySecondary Indexif the query which we fire reminas the same always with only where clause equlaity changes so still we need to collect the statistics.Regards,Vinod
41401 Mar 2006 @ 07:26 PSTBarry-1604DatabaseReplyLocking modifer for a MSRThe two statements are equivalent only because BTEQ understands the semicolon with additional syntax behind it to be a multi-statement request AND the statement is a DML command (as opposed to a DD...
41301 Mar 2006 @ 01:01 PSTANGELDatabaseTopicSecondary IndexHI,can anyone tell me why do we need Secondary Index when we already have PI. Cite some example where we we use both PI and SIThanks
41201 Mar 2006 @ 12:40 PSTANGELDatabaseReplySecondary IndexHi,It is of the utmost importance to collect statistics on all NUSIs. Statistics might impact whether or not the optimizer chooses to use a secondary index, which could result in substantial differ...
41128 Feb 2006 @ 11:12 PSTvinod_sugurDatabaseTopicSecondary IndexIS it necessary to always collect statistics on NUSI? At my end the table is frequently accessed and due to some reason we can't collect statitics so does this means that the NUSI on the table will...
41028 Feb 2006 @ 10:29 PSTSDDatabaseReplyLocking modifer for a MSRThanks for your reply, Jim. Can you please elaborate on why the two are equivalent?I have a user interface that accepts the query for a view definition and optionally a locking modifier statement f...
40928 Feb 2006 @ 06:16 PSTPhoenix TechJobsTopicTeradata DBA needed in Phoenix, AZTeradata DBA needed immediately in Phoenix, AZ. If interested, please contact Jonathan Heldele at jonathan@phoenixstaff.com with current status and a resume. Follow up will be immediate.Candidate...
40828 Feb 2006 @ 12:36 PSTTDUser-781ToolsReplyFast ExportI don't know... Are you using cast on every field and on the "global concat field"? could you please post your final script?Bye, TDUser
40728 Feb 2006 @ 12:20 PSTJim ChapmanToolsReplyPartitioned tables: multiload vs JDBCPartitioning has no effect on locking granularity, so concurrency is the same. There is no partition level locking.Multiload always locks the entire table. Single row inserts and updates (assumi...
40628 Feb 2006 @ 12:09 PSTJim ChapmanDatabaseReplyLocking modifer for a MSRThe two requests are equivalent, so the execution plans are identical as shown by the explains. What difference were you expecting?
40528 Feb 2006 @ 11:01 PSTSDUDAReplyfind out the number of nodes in a teradata architectureAssuming it is a MPRAS installation, run -# cat /ntos/mpplistwill show you the list of nodes for the Teradata DBS and also which node is the PDN.
40428 Feb 2006 @ 10:48 PSTSDToolsTopicPartitioned tables: multiload vs JDBCI would like to know if partitioned tables permit concurrent inserts/updates to multiple partitions of the same table when using multiload only or any other client as well.Put differently, my quest...
40328 Feb 2006 @ 10:39 PSTSDDatabaseTopicLocking modifer for a MSRI am trying to understand the locking modifier. Referring to the following two explains, I am not clear why the explains are the same though the locking modifier is applied differently in both case...
40228 Feb 2006 @ 09:28 PSTTSToolsReplyFast ExportYes, thnx a lot!But there's a small query again, on running that script, the output / txt file which is being created is as follows: H 1362500|0000000013625002| 100|1995-12-04| ...
40128 Feb 2006 @ 09:17 PSTTDUser-781ToolsReplyFast ExportI don't really know if casting every field of the select is necessary when exporting a readable output.When you use a FXP - let me say - in the "standard way" (that is you export a file in fastload...
40028 Feb 2006 @ 08:41 PSTstami27-2406DatabaseReplyTrial Teradata-DWH-CDI've found it!http://www.teradata.com/t/page/44749/index.html
39928 Feb 2006 @ 08:32 PSTTSToolsReplymultiloadHi,While a multiload job is running in batch mode, u can view its status in the log file which is being created. Similarly the status of abended jobs can also be seen in the log file created.Hope i...
39828 Feb 2006 @ 08:22 PSTstami27-2406DatabaseTopicTrial Teradata-DWH-CDHi,does anyone knows if or where can I get a trial Teradata-DWH-CD for Windows/XP? Best Regardsstami27
39728 Feb 2006 @ 08:15 PSTleleraToolsTopicmultiloadGood Day,How do you monitor the status of your jobs on multiload, and how do you check for the jobs that abended. Is there a scheduler tool you can use to accomplish this? e.g. Unicenter
39628 Feb 2006 @ 08:00 PSTstami27-2406DatabaseReplydoesn't have access to create a stored procedureHi varun,ask your DBA to give you the create/update/execute rights or if you are the sysdba make that yourself with the Teradata Administrator.Best regardsstami27
39528 Feb 2006 @ 07:40 PSTTSToolsReplyFast ExportThanks a lot!It worked.Could u pls tell, is it necessary to cast the fields while doing a fast export?Regards,TS.
39428 Feb 2006 @ 07:20 PSTTDUser-781ToolsReplyFast ExportHi,in order to have a readable output you have to cast as char and concat all the fields you are exporting.Like this:SELECT cast((cast(cust_id as char(xx))||cast(acct_nbr as char(xx))||cast(minimum...
39328 Feb 2006 @ 06:16 PSTTSToolsReplyFast ExportThe following is the code which is being executed, still the output is not in the correct format..LOGTABLE db.datastore_log ;.logon;.BEGIN EXPORT SESSIONS 20 TENACITY 5 SLEEP 1;.EXPORT OUTFILE c:\O...

Pages