#DateForumTypeThreadPost
21604 Dec 2015 @ 03:21 PSTPrivate Forum
21503 Dec 2015 @ 12:10 PSTPrivate Forum
21403 Dec 2015 @ 04:36 PSTDatabaseReplyTeradata DBQL logging setup and maintanence document for TD 15DIPPDCR is a script which is part of the install/upgrade process for the Teradata database.    The upgrade process should be rechecked and make sure this script gets executed. 
21302 Dec 2015 @ 03:02 PSTDatabaseReplyTeradata DBQL logging setup and maintanence document for TD 15PDCR is part of the product as of TD15 and later. But DIPPDCR must be run to install the tables, macros,...
21202 Dec 2015 @ 02:37 PSTPrivate Forum
21130 Nov 2015 @ 11:32 PSTDatabaseReplyParameterization of Layout fileRe the original post: If there is that large a difference in performance, it sounds like the ODBC method is being used rather than the TPT LOAD or TPT UPDATE methods. Datastage is capable of using ...
21030 Nov 2015 @ 06:15 PSTDatabaseReplyAvoiding Duplication on All AmpsThe alternative plan is to redistribute TableA which appears to be a fairly wide table, lots of bytes to redistribute. Are there lots of nulls in columnx in TableA? Are there lots of duplicate valu...
20925 Nov 2015 @ 01:06 PSTGeneralReplyUnassigned Work Load Definition For properly Configured User in TASM !!!!Observations: - all the unassigned ones are on the 24th, the ones with a WD are on the 23rd. Did a change to TASM settings occur? - all the unassigned ones have 0 cpu time and 0 execution time. T...
20825 Nov 2015 @ 05:14 PSTDatabaseReplyCopy data from one database to another on the same server The two statements, delete and insert select, should be executed as separate statements with commit after each one. If they are executed in the same multi statement request or in the same transacti...
20723 Nov 2015 @ 02:08 PSTDatabaseReplyPartitions on Character fields in 14.10If what is requested is to be able to specify an interval on the data ranges specified above, eg to get single month partitions, then that is not possible. There is no way to define math on charact...
20622 Nov 2015 @ 12:36 PSTDatabaseReplyLeft Outer Join EfficiencyNeed explain plans to understand what is happening with the query. Also need to understand how breaking it up helps with the efficiency issue - queries and explains. 
20522 Nov 2015 @ 12:23 PSTDatabaseReplyDerived table efficiencyA derived table does not have a primary index. It is a spool file and it's distribution will be chosen by the optimizer based on future elements of the plan - eg the join columns.   ...
20413 Nov 2015 @ 03:46 PSTToolsReplyError 9128 : Transaction exceeds max. number of Row Hash locksIf you use BTEQ import, each row will be inserted as a separate SQL insert statement. This is quite useful for small to moderate volumes but very inefficient for larger volumes like your example. F...
20313 Nov 2015 @ 02:18 PSTToolsReplyBTEQ TPTBack to the original question...   It is much easier, quicker and more efficient to INSERT SELECT inside the database on Teradata than to unload the result and load it back. The INSERT ...
20229 Oct 2015 @ 12:55 PDTDatabaseReplyQuery runs for 5 hoursIt is not clear exactly what the question is for the subquery but I note that it is a correlated subquery which does a self join between two instances of DB1.WHSL_A_TBL by specifying a jo...
20118 Oct 2015 @ 09:59 PDTDatabaseReplyProduct Join in Teradata 15There is not a way to cause this behavior to change and issue an error instead.   If the product join is large, it is possible to catch it with a TASM filter and error it because of the comb...
20018 Oct 2015 @ 09:20 PDTDatabaseReplyProduct Join in Teradata 15Since the early days of Teradata, the grammar has not required the FROM clause. early on this was viewed as an ease of use feature. The parser looks through the query finding all database and table...
19909 Oct 2015 @ 02:40 PDTDatabaseReplyLOG file for Stored Procedure in Teradata. Define your log as a table and do SQL INSERTs of whatever data you want into your log table.
19807 Oct 2015 @ 01:16 PDTGeneralReplyDropping PI from a tableIn the original post it sounds as if there is an impression that adding the PI after the data is loaded would improve load performance or perhaps that the index build would be cheaper if done after...
19707 Oct 2015 @ 08:23 PDTDatabaseReplyALTER TABLE - Adding already existing columnsInteresting. You will have to test then to see if it recognizes that there is no work to do and optimizes it to a no-action ALTER.
19606 Oct 2015 @ 10:25 PDTGeneralReplyHow to calculate the space of a database that data will be copied using arcmainThe files shown in your log sample are all very small. If the space you have allocated is also small and close to the size of the data of the tables, then you could get this error due to havin...
19505 Oct 2015 @ 01:37 PDTDatabaseReplySHOW Statistics - Meaning of AvgRowsPerBlock You could do the division yourself. It would be close enough. avgblocksize/avgrowsize
19405 Oct 2015 @ 01:24 PDTDatabaseReplyALTER TABLE - Adding already existing columnsI expect you will get an error saying that you cannot add another column with the same name if you try to ALTER and add a column which already exists.
19305 Oct 2015 @ 12:15 PDTGeneralReplyIs dropping/creating tables over and over an ok or should you leave the table structure in place?All attributes of the table go away when the table is dropped. BLC is an attribute of the table and needs to be specified if it is desired to be an attribute of the new table.
19205 Oct 2015 @ 12:10 PDTDatabaseReplyAccess rights of dropped DatabaseIf you use DROP and DELETE DATABASE the rights will always be dropped from the dictionary as well. Orphan rights occur when dictionary restores are done but some of the objects are not restored.

Pages