#DateWhereItemComment
2930 Aug 2016 @ 10:17 PDTcarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerHi 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...
2830 Jun 2016 @ 03:55 PDTDatabaseSecurity Administration - Accessing the Teradata Database Through a Middle-tierHi, 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...
2730 Jun 2016 @ 09:01 PDTDatabaseSecurity Administration - Accessing the Teradata Database Through a Middle-tierI think, i figured it out, the double quotes in "samir.singh" is the problem here. Thanks anyway !!
2629 Jun 2016 @ 04:06 PDTDatabaseSecurity Administration - Accessing the Teradata Database Through a Middle-tierHi, 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...
2523 May 2016 @ 03:18 PDTcarrie's blogAMP Worker Task Resource Limits & Increased Load Limits for MLOADXHi 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 ...
2408 Jun 2015 @ 02:43 PDTViewpointTeradata 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 ...
2308 Jun 2015 @ 12:15 PDTViewpointTeradata Viewpoint 14.10 Release Hi Shrity, Did you get a chance to look into this. Thanks !
2206 Jun 2015 @ 07:02 PDTViewpointTeradata 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...
2112 Mar 2015 @ 06:10 PDTDatabaseIdentifying 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...
2011 Mar 2015 @ 09:03 PDTDatabaseIdentifying Used, Unused and Missing StatisticsHi 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...
1908 Jan 2015 @ 01:05 PSTViewpointTeradata 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...
1817 Dec 2014 @ 01:53 PSTÜber SQLNew StatsInfo query for TD14Hi 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...
1716 Dec 2014 @ 10:00 PSTÜber SQLNew StatsInfo query for TD14Basically 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...
1616 Dec 2014 @ 09:19 PSTÜber SQLNew 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...
1516 Dec 2014 @ 01:36 PSTViewpointWhat's New With Viewpoint 15.00 Shared Pagesthanks 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...
1401 Dec 2014 @ 10:11 PSTViewpointWhat's New With Viewpoint 15.00 Shared PagesHello, 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...
1302 Aug 2013 @ 10:05 PDTÜber SQLGlobal and session level parameters in SQLHi 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...
1209 Jul 2013 @ 08:18 PDTMarcio MouraWhen is the right time to refresh statistics? - Part IIHi 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...
1109 Jul 2013 @ 08:12 PDTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to another-Anybody ??
1009 Jul 2013 @ 08:10 PDTcarrie's blogTeradata 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...
902 Jul 2013 @ 01:49 PDTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to anotherHi, 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 ...
814 Jun 2013 @ 08:38 PDTÜber SQLHow to decode the binary statistics stored in dbc tablesHi 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...
709 May 2013 @ 08:08 PDTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to anotherGenrally 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
609 May 2013 @ 07:14 PDTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to anotherHi 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...
519 Feb 2013 @ 11:07 PSTToolsEasy Loader for Teradata Parallel TransporterI 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 ...

Pages