#DateForumTypeThreadPost
10524 May 2007 @ 04:32 PDTAnalyticsReplyAll virtual circuits are currently in useEvery 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...
10424 May 2007 @ 03:08 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIin 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 ...
10323 May 2007 @ 11:57 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIYour 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...
10223 May 2007 @ 09:32 PDTDatabaseReplyDatabase information functionsYou 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...
10123 May 2007 @ 09:26 PDTDatabaseReplyHelp 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...
10023 May 2007 @ 09:11 PDTDatabaseReplyPhysical Implemetation of the Tables - PPII 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 ...
9923 May 2007 @ 07:39 PDTDatabaseReplyDifference 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...
9823 May 2007 @ 07:27 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIIn 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...
9723 May 2007 @ 05:11 PDTDatabaseReplyPhysical Implemetation of the Tables - PPIA 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...
9621 May 2007 @ 02:26 PDTAnalyticsReplyHow to List Down Alternate Fridaymod 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...
9521 May 2007 @ 12:37 PDTAnalyticsReplyHow to List Down Alternate Fridayadd this condition to the where clause(day_of_calendar - 39226) MOD 14 = 0
9418 May 2007 @ 08:27 PDTDatabaseReplyDates In Decimal FormatI 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...
9318 May 2007 @ 12:42 PDTDatabaseReplyDates In Decimal FormatThis 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 ...
9218 May 2007 @ 12:04 PDTUDAReplyPerformance 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 ...
9116 May 2007 @ 11:36 PDTDatabaseReplyTesting the PPI watersYes, (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.
9016 May 2007 @ 02:03 PDTDatabaseReplyTesting the PPI watersFor 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...
8915 May 2007 @ 02:03 PDTJobsTopicDatabase 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 ...
8814 May 2007 @ 05:04 PDTToolsReplyWhere do the Log files get created?Look in DBC.Users (profileName) and DBC.ProfileInfoX
8714 May 2007 @ 12:47 PDTToolsReplyFastload via MS-DOS batch filemy 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...
8614 May 2007 @ 12:43 PDTDatabaseReplyCyclinder index vs Master IndexThe 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...
8514 May 2007 @ 12:22 PDTToolsReplyVisual NotificationI thought it was one of the "windows" features which did the trick whenever an application was minimized and tried to request focus.
8411 May 2007 @ 02:18 PDTDatabaseReplyIs 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...
8310 May 2007 @ 11:42 PDTUDAReplyCount(*)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
8210 May 2007 @ 11:38 PDTDatabaseReplyHow I can tell Teradata is running on ANSI mode or teradata modeYou 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...
8110 May 2007 @ 09:45 PDTToolsReplyWhere 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)

Pages