Pages
![]() |
Can anyone please help?
14 Aug 2016
| 2 comments
,
|
![]() |
Hi Everyone,
29 Jun 2016
| 1 comment
,
|
![]() |
My instance shows it is started but it is still taking a long time for the connection to the database
31 Mar 2016
| 1 comment
,
|
![]() |
Is there any easy way to find out any DELETES happened on a table or not with out parsing the qrylog table.
10 Mar 2016
| 1 comment
,
|
![]() |
Hi all, I have a particular question regarding how the data are stored inside ResUsageSAWT.
04 Mar 2016
| 1 comment
,
|
![]() |
Aster is an analytic discovery application that lets you perform exploratory queries across your data regardless if it is structured or not.
22 Dec 2015
,
|
![]() |
You may want to skip over this posting. Unless you’re curious about some of the more obscure workload classification conventions used by TASM and TIWM.
13 Nov 2015
| 3 comments
,
|
![]() |
Hi all,
20 Oct 2015
,
|
![]() |
We have the column defined as below
25 Aug 2015
| 2 comments
,
|
![]() |
This “Teradata Basics” posting describes the current dimensions of parallelism in the Teradata Database, and how they work together.
10 Aug 2015
| 6 comments
,
|
![]() |
Hi All,
I am measuring the performance of a query execution in a test environment and i have a following scenario..... This test environment has data volume equivalent to production environment, but its hardware is downsized compared to production environment, i.e., its 40% or 50% of production environment or configuration.
29 Jul 2015
,
|
![]() |
|
![]() |
If you've worked with Oracle for years and now find yourself the DBA for a Teradata Data Warehouse, you'll want to get productive as soon as possible.
10 Jun 2015
,
|
![]() |
Today's analytic environments incorporate multiple technologies and systems. Getting value from these systems often requires that they work together to address business needs.
01 Jun 2015
,
|
![]() |
hi.
12 May 2015
| 1 comment
,
|
![]() |
This in-depth presentation covers the basic functionality of the SLES 11 Teradata Priority Scheduler.
01 May 2015
,
|
![]() |
Hi Everyone,
27 Mar 2015
| 2 comments
,
|
![]() |
This session explores the new options available for setting hard limits at different levels in the SLES11 priority hierarchy.
16 Mar 2015
,
|
![]() |
I've created a Java Function and imported it in TeraData
04 Feb 2015
,
|
![]() |
Good day!
02 Feb 2015
| 1 comment
,
|
![]() |
As of Teradata Database 14.10.05 and 15.00.03, a simplified approach to determining which workload will support session management and parsing has been adopted This posting describes this more straightforward approach which will be used starting in these 14.10 and 15.0 releases, and going forward in all future releases. An earlier posting titled: “A Closer Look at How to Setup a Parsing-Only Workload” explains how session and parsing workload assignment takes place prior to this more simplified approach. If you are on an earlier release, please see that posting from December 2014.
19 Jan 2015
| 13 comments
,
|
![]() |
QueryGrid provides access to multiple data sources within UDA for Tera
29 Dec 2014
,
|
![]() |
Hi,
28 Dec 2014
| 3 comments
,
|
![]() |
Hi,
24 Dec 2014
| 3 comments
,
|
![]() |
Hi Guys,
10 Dec 2014
| 2 comments
,
|
![]() |
This session focuses on statistics enhancements in Teradata Database 14.10, particularly the new threshold functionality, skipping statistics, and downgrade to sampling.
04 Dec 2014
,
|
![]() |
Hi is it possible to use modify user statement in the prepared statement as like below.If it is wrong plz correct it....
14 Nov 2014
| 3 comments
,
|
![]() |
Hi,
07 Oct 2014
| 5 comments
,
|
![]() |
Hi ,
26 Sep 2014
| 4 comments
,
|
![]() |
Is it possible to move data from between different DBC's on teradata ? I have a database 'A', which contains a table 'B' on DBC "C" Can i move the table 'B' in to DBC "D" ??
25 Sep 2014
| 2 comments
,
|
![]() |
Hi,
23 Sep 2014
| 13 comments
,
|
![]() |
Statistical information is vital for the optimizer when it builds query plans. But collecting statistics can involve time and resources. By understanding and combining several different statistics gathering techniques, users of Teradata can find the correct balance between good query plans and the time required to ensure adequate statistical information is always available. This recently-updated compilation of statistics collection recommendations are intended for sites that are on any of the Teradata Database 14.10, 15.0, or 15.10 software release levels. Some of these recommendations apply to releases earlier than Teradata Database 14.10 and some rely on new features available starting in Teradata Database 14.10. Statistics collection functionality in the Teradata Database works the same in 14.10, 15.0 and 15.10 releases. For greater detail on collecting statistics for Teradata Database 14.10, see the orange book titled: Teradata Database 14.10 Statistics Enhancements by Rama Krishna Korlapati. Contributors: Carrie Ballinger, Rama Krishna Korlapati, Paul Sinclair, September 11, 2014
11 Sep 2014
| 43 comments
,
|
![]() |
Can any one answer my Question...How can we connect (Different Oracle, Teradata) multiple database servers to join the tables from both DB's
08 Sep 2014
| 1 comment
,
|
![]() |
Hi. I am receiving the above error when trying to perform a password change via a third party password reset tool. We are using Windows Server 2012 R2 and the password software requires the 32 bit version of the ODBC driver. We are using 15. We have confirmed that the ODBC connection is working.
25 Aug 2014
,
|
![]() |
Hi
23 Jul 2014
| 3 comments
,
|
![]() |
Hi Forum,
I have a table created as SET table using IDENTITY column as UPI and it has data in it. Now, the user wants us to change it to MULTISET, but, as the PI is on Identity column how can I do this?
26 Jun 2014
,
|
![]() |
Hi Dieter / All
I would like to know one thing.
There is one table T. A view V is created with LOCKING ROW FOR ACCESS. Now, 3 different users (in 3 different sessions) are trying in parallel to INSERT using V (view).
16 Jun 2014
| 4 comments
,
|
![]() |
Hi All
If a table is defined as MLPPI the constraint can be checked either from DBC.PartitioningConstraintsV or from DBC.IndexConstraintsV. There the ConstraintText feild holds the explanation in a certain format such as
/* nn bb cc */ partition_expression_i /* i d+a */
Where,
05 Jun 2014
| 1 comment
,
|
![]() |
If I told you there was a way you might be able to speed up parsing time for your queries, would you be interested? In Teradata Database 14.10.02 there is a new capability that allows you to expedite express requests, and I’d like to explain how that works, describe when it can help you, and make some suggestions about how you can use it to get the best performance you can from parsing when the system is under stress. But first a little background.
03 Jun 2014
| 28 comments
,
|
![]() |
Hi
31 May 2014
,
|
![]() |
Hi all,
14 Apr 2014
| 2 comments
,
|
![]() |
The SLES 11 priority scheduler implements priorities and assigns resources to workloads based on a tree structure. The priority administrator defines workloads in Viewpoint Workload Designer and places the workloads on one of several different available levels in this hierarchy. On some levels the admin assigns an allocation percent to the workloads, on other levels not. How does the administrator influence who gets what? How does tier level and the presence of other workloads are on the same tier impact what resources are actually allocated? What happens when some workloads are idle and others are not? This posting gives you a simple explanation of how resources are shared in SLES 11 priority scheduler and what happens when one or more workloads are unable to consume what they have been allocated.
07 Mar 2014
| 31 comments
,
|
![]() |
We are using the below query to modify the transaction ID on the table and this transaction ID is primary index on the table through ETL job.
25 Feb 2014
| 3 comments
,
|
![]() |
Join this in-depth presentation that covers the basics of the New Teradata Priority Scheduler available with Linux SLES 11 operating system.
17 Feb 2014
,
|
![]() |
When trying to migrate my data from MS SQL to mySQL, essentially converting one database to another I get the following error:
14 Feb 2014
| 2 comments
,
|
![]() |
Hi
I am using Teradata Parallel Transporter v13.10. I have few questions in this regard.
1. In MLOAD LAYOUT we can define .FILLER, which will not be sent to database. Can we define anything similar in TPT UPDATE also?
2. Running the following DDL step.
STEP DDL_STEP3
03 Feb 2014
| 3 comments
,
|
![]() |
Hi
I am using Teradata Parallel Transporter v13.10. I have few questions in this regard.
1. In MLOAD LAYOUT we can define .FILLER, which will not be sent to database. Can we define anything similar in TPT UPDATE also?
2. Running the following DDL step.
STEP DDL_STEP3
03 Feb 2014
,
|
![]() |
Admin,
25 Jan 2014
| 3 comments
,
|
![]() |
Most Teradata systems support different processing windows, each which has a somewhat different set of business priorities. From 8 AM to 12 noon the most important work may be the Dashboard application queries. But from 12 noon to 6 PM it could be the ad hoc business users. At night maybe it’s the batch loads and reporting. Planned Environments function within the TASM state matrix to support the ability to automatically manage changes to workload management setup during those different windows of time.
20 Jan 2014
| 7 comments
,
|
![]() |
Hi,
01 Jan 2014
| 6 comments
,
|