29 | 30 Aug 2016 @ 10:17 PDT | carrie's blog | How Resources are Shared in the SLES 11 Priority Scheduler | Hi Carrie,
We have two virtual partitions - prod and non prod. The prod has all prod IDs and non Prod has all UAT/Dev ids. In resource partition, i see that 85% is given to prod and 15% to non pro... |
28 | 30 Jun 2016 @ 03:55 PDT | Database | Security Administration - Accessing the Teradata Database Through a Middle-tier | Hi,
I have posted a question in the connectivity section realted to the same topic so that a broader audience can see it. Could you pleae see if that is something that you can help me with ? Below... |
27 | 30 Jun 2016 @ 09:01 PDT | Database | Security Administration - Accessing the Teradata Database Through a Middle-tier | I think, i figured it out, the double quotes in "samir.singh" is the problem here. Thanks anyway !!
|
26 | 29 Jun 2016 @ 04:06 PDT | Database | Security Administration - Accessing the Teradata Database Through a Middle-tier | Hi,
I am trying to test few scenarious using my id as a proxy user, but i get below error:
I ran - Grant connect through idw_bo_user to permanent "samir.singh" without role using dbc. i... |
25 | 23 May 2016 @ 03:18 PDT | carrie's blog | AMP Worker Task Resource Limits & Increased Load Limits for MLOADX | Hi Carrie,
As mentioned, in the 14.10/15.0 timeframe, MLOADX responds to workload management rules similarly to legacy MultiLoad, does it mean that its better to use this when we move to 15.10(we ... |
24 | 08 Jun 2015 @ 02:43 PDT | Viewpoint | Teradata Viewpoint 14.10 Release |
Hi Shrity,
Thanks for the reply. When I check the alert setup, i can see application ids listed in the include option.I can see all kind of application id - BO, ETL etc. Users schedule jobs ... |
23 | 08 Jun 2015 @ 12:15 PDT | Viewpoint | Teradata Viewpoint 14.10 Release | Hi Shrity,
Did you get a chance to look into this.
Thanks !
|
22 | 06 Jun 2015 @ 07:02 PDT | Viewpoint | Teradata Viewpoint 14.10 Release | Hi Shrity,
I have a requirement that a certain set of users would be running some queries using an application id on production box. Those queries would be analytical in nature and might be bad. I... |
21 | 12 Mar 2015 @ 06:10 PDT | Database | Identifying Used, Unused and Missing Statistics |
Hi RK,
For my test database , i have enabled this logging. I have 16 columns + 1 index + 4 stats(only 3 column stats and one stats with columname "*"(not sure what is th... |
20 | 11 Mar 2015 @ 09:03 PDT | Database | Identifying Used, Unused and Missing Statistics | Hi RK,
Thanks for such a wonderful info. I have one question here.
1. Is it not possible to enable this logging for a table in a DB. The reason why i am asking this because i want to use it in my... |
19 | 08 Jan 2015 @ 01:05 PST | Viewpoint | Teradata Viewpoint 14.10 Release | Hi Shrity,
I am currently setting up viewpoint on our new 14 system. I have one question regarding the table space. Typically what should be the value of perm space and % skew for dbc.transientjou... |
18 | 17 Dec 2014 @ 01:53 PST | Über SQL | New StatsInfo query for TD14 | Hi Diether,
I think i got it. I saw your post above regarding this. I just need to check the presence of that databasename and tablename in view dbc.StatsV. This view contains all the colu... |
17 | 16 Dec 2014 @ 10:00 PST | Über SQL | New StatsInfo query for TD14 | Basically i want to find tables having stats on them - single column, index or multicolumn. below query gives me the o/p , but i want to know if there is any view like in 13.10 (as we used in above... |
16 | 16 Dec 2014 @ 09:19 PST | Über SQL | New StatsInfo query for TD14 |
Hi Diether,
We have migrated to TD 14.10 few days back. Previously we had TD 13.10. In our collect stats architecure, we have the below query that fails now saying that DBC.M... |
15 | 16 Dec 2014 @ 01:36 PST | Viewpoint | What's New With Viewpoint 15.00 Shared Pages | thanks for the information wdarling. Just an update, for my above question. when i go to admin section in portlets tab in viewpoint for dba role as you suggested, the shared pages is enabled and as... |
14 | 01 Dec 2014 @ 10:11 PST | Viewpoint | What's New With Viewpoint 15.00 Shared Pages | Hello,
I am working as a Teradata DBA ad migrating to TD 14.10. I have created a shared page for the DBAs and published it.
Now when people in my team(DBAs) logon to viewpoint, they are able to s... |
13 | 02 Aug 2013 @ 10:05 PDT | Über SQL | Global and session level parameters in SQL | Hi Diether,
I found a reference to this link in a post : make use of ppi partition elimination without a hardcoded date.
However, i am not clear as to how the approach mentioned here solves th... |
12 | 09 Jul 2013 @ 08:18 PDT | Marcio Moura | When is the right time to refresh statistics? - Part II | Hi Marico,
We have a table with PPI on Col1 , which is a date column. We have a query running uses condition
Col1 >= DATE '2013-07-06'
AND Col1<= DATE '2013-07-08... |
11 | 09 Jul 2013 @ 08:12 PDT | Accomplishing tasks when you don't know where to start. | Using a named pipe archive to copy a database from one system to another | -Anybody ??
|
10 | 09 Jul 2013 @ 08:10 PDT | carrie's blog | Teradata 13.10 Statistics Collection Recommendations | Hi Carrie,
We have a table with PPI on Col1 , which is a date column. We have a query running uses condition
Col1 >= DATE '2013-07-06'
AND Col1<= DATE '2013... |
9 | 02 Jul 2013 @ 01:49 PDT | Accomplishing tasks when you don't know where to start. | Using a named pipe archive to copy a database from one system to another | Hi,
There is .RLG file created when do we an archive and restore. Is there a method to find how much can be size of the file depending on the table size being archived.
1. If i have to archive a ... |
8 | 14 Jun 2013 @ 08:38 PDT | Über SQL | How to decode the binary statistics stored in dbc tables | Hi Dnoeth,
I have few questions on the o/p of stats view :
1. What is the meaning of Col in status type column ?
2. If i have a index on col1 and col2 combination and my stats is on col1,col2 co... |
7 | 09 May 2013 @ 08:08 PDT | Accomplishing tasks when you don't know where to start. | Using a named pipe archive to copy a database from one system to another | Genrally how much is speed of arcmain ? I am trying to move 300 GB data, but it is running for more than 2 hours !
The archive is logged on to 4 sessions and restore also is logged on to 4 sessions
|
6 | 09 May 2013 @ 07:14 PDT | Accomplishing tasks when you don't know where to start. | Using a named pipe archive to copy a database from one system to another | Hi Jim,
I didn't submit it from command line as you mentioned. Instead , i created a small script (with the same instruction as yours)and then submitted. This was for both, the archive part an... |
5 | 19 Feb 2013 @ 11:07 PST | Tools | Easy Loader for Teradata Parallel Transporter | I heard there is one more tool by which you can move data from one prod server to another, say i want to move data from prod to dev server. TPT was used for that as well. Can this be used for this ... |