105 | 24 May 2007 @ 04:32 PDT | Analytics | Reply | All virtual circuits are currently in use | Every PE can serve 120 sessions at the MAX. so when the sessions pile up, which is either due to too many users/connections or because some application is not doing a good job in cleaning up the co... |
104 | 24 May 2007 @ 03:08 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | in your SQL assistant, you run this command.diagnostic helpstats on for session;then you do an explain on your query (which is under scrutiny)EXPLAINSELECT COL1, COl2 FROM TABLE1WHERE COL3 BETWEEN ... |
103 | 23 May 2007 @ 11:57 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | Your new DDL has a lot fewer partitions than your original DDL. (check the ranges you have mentioned for both the original ends in 2100 and the new one ends in 2020)Can you post your explains ?Also... |
102 | 23 May 2007 @ 09:32 PDT | Database | Reply | Database information functions | You must get most of that information from the DD manual (actually you will have to query the corresponding views under DBC for most of the information).DBC.Columns has the data type info.you can a... |
101 | 23 May 2007 @ 09:26 PDT | Database | Reply | Help needed in diagnosing a Query!!! | The group by is an aggregation step and results in redistribution of the spool of the table B based on the columns grouped. So that might have impacted the join plan of the optimizer.May the optimi... |
100 | 23 May 2007 @ 09:11 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | I believe your original DDL was (as you first posted)PARTITION BY RANGE_N(PI_COLUMN between DATE '2000-01-01' AND '2100-01-01' EACH INTERVAL '1' MONTH )That's 1201 partitions ... I am not sure why ... |
99 | 23 May 2007 @ 07:39 PDT | Database | Reply | Difference between GTT and Volatile tables..!! | Quick notes ....GTT takes up space from Temporary space, so this kind of doesn't interfere with the spool required for your normal queries, also they survive TD system restarts, and since the DDL i... |
98 | 23 May 2007 @ 07:27 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | In your original DDL, you have about 1200 partitions (12 months * 100 yrs)where as in your modified DDL you have only about 121 partitions (12 months * 10 yrs + 1)that in itself is a big difference... |
97 | 23 May 2007 @ 05:11 PDT | Database | Reply | Physical Implemetation of the Tables - PPI | A few things to consider would be.Are there statistics collected on PARTITION (not the paritioning column, but the PARTITION itself) ?Does your query plan talk about DPE ? (in prod / test ).Empty p... |
96 | 21 May 2007 @ 02:26 PDT | Analytics | Reply | How to List Down Alternate Friday | mod is a mathematical function that gives you the remainder of a division operation. (same as % operator in normal programming languages like C/C++/JAVA etc)so3 MOD 4 = 35 MOD 4 = 18 MOD 4 = 0and s... |
95 | 21 May 2007 @ 12:37 PDT | Analytics | Reply | How to List Down Alternate Friday | add this condition to the where clause(day_of_calendar - 39226) MOD 14 = 0 |
94 | 18 May 2007 @ 08:27 PDT | Database | Reply | Dates In Decimal Format | I guess I ran into trouble because in your original post you mentioned " could be 105007 which is 1/5/2007 "I thought the format to be funny :-) How about this one ?SELECT ADD_MONTHS(('112207' (DA... |
93 | 18 May 2007 @ 12:42 PDT | Database | Reply | Dates In Decimal Format | This was the closest I could get :oSELECT MYDATE,((CASE WHEN (MYDATE / 10000 (NAMED DAYOFDATE1) ) MOD 10 (NAMED DAYOFDATE2) = 0 THEN DAYOFDATE1/10 ELSE DAYOFDATE1 END (FORMAT '99') ) ||(CASE WHEN ... |
92 | 18 May 2007 @ 12:04 PDT | UDA | Reply | Performance Queries... | In addition to what Barry suggested,You would also need to look into the skew factors. It could be either skew in the table as such or skew in the intermediate spool files generated as part of the ... |
91 | 16 May 2007 @ 11:36 PDT | Database | Reply | Testing the PPI waters | Yes, (I did some basic checking before selling you that :-) )That being said remember that you need to collect statistics on the special column PARTITION itself. |
90 | 16 May 2007 @ 02:03 PDT | Database | Reply | Testing the PPI waters | For your tables whose PI is not a subset of {ACCOUNTING_YEAR, ACCOUNTING_PERIOD} columns , you can have a range expression of the following kind ... would help you with deleting old data and addin... |
89 | 15 May 2007 @ 02:03 PDT | Jobs | Topic | Database Engineer required for Teradata R&D, Bangalore | Responsibilities Position Title: Database Engineer Job Req Number: 123023 Location: Bangalore Summary Description: This is an experienced Database Engineer position with a preferred emphasis in ... |
88 | 14 May 2007 @ 05:04 PDT | Tools | Reply | Where do the Log files get created? | Look in DBC.Users (profileName) and DBC.ProfileInfoX |
87 | 14 May 2007 @ 12:47 PDT | Tools | Reply | Fastload via MS-DOS batch file | my guess is that It may be because of the spaces in your command, so you might have to put things in double quotes. ie"C:\Program Files\NCR\Teradata Client\Bin\bteq" < "C:\Documents and Settings\In... |
86 | 14 May 2007 @ 12:43 PDT | Database | Reply | Cyclinder index vs Master Index | The master index and cylinder index together is used for lookup of records.Master index (memory resident) has an entry for each cylinder (Called cylinder index descriptor) which tells it what is th... |
85 | 14 May 2007 @ 12:22 PDT | Tools | Reply | Visual Notification | I thought it was one of the "windows" features which did the trick whenever an application was minimized and tried to request focus. |
84 | 11 May 2007 @ 02:18 PDT | Database | Reply | Is Mload better than Insert Statement? | I think there are times (especially with large amount of records and you have a Gigabit LAN so your extract/load times are quite high), when MLOAD would be a better approach because of the Transien... |
83 | 10 May 2007 @ 11:42 PDT | UDA | Reply | Count(*) | why don't you use a derived table in your query ?ie something like ...SELECT * FROMB,C,(SELECT COUNT(*) FROM A)ACNT(CNT)WHEREB.col1 = C.col1 |
82 | 10 May 2007 @ 11:38 PDT | Database | Reply | How I can tell Teradata is running on ANSI mode or teradata mode | You can use the parameter TMODE in the connection string. (can set it to values ANSI,TERADATA or DEFAULT).I haven't personally used ANSI mode in JDBC, but I think it would turn off the autoCommit f... |
81 | 10 May 2007 @ 09:45 PDT | Tools | Reply | Where do the Log files get created? | simple trick is to just login using the id and then do a SELECT DATABASE;otherwise lookin DBC.Users for defaultdatabasename (if that's null it's the same as user id) |