37 | 21 Jan 2016 @ 07:11 PST | Private Forum |
36 | 06 Apr 2015 @ 01:25 PDT | Database | Reply | LockDelay in XMLTextInfo of dbc.dbqlxmllocktbl | It is in centiseconds (not in milliseconds or just seconds).
|
35 | 06 Jan 2015 @ 09:21 PST | General | Reply | Unassigned Work Load Definition For properly Configured User in TASM !!!! | WDName is 'Unassigned' in PDCRINFO.DBQLOGTBL_HST when the WDID is NULL in DBC.DBQLOGTBL.
WDID is NULL for the TASM bypassed users by design. Generally in many client places, TDWM, D... |
34 | 23 Dec 2014 @ 12:51 PST | Viewpoint | Reply | CPU, CPU USE, CPU SKEW | I see, thank you.
I agree for Viewpoint server while calculating the CPU seconds no need to multiply by 2, but what about other systems like 6650, 5550 etc boxes.?
|
33 | 22 Dec 2014 @ 03:30 PST | Viewpoint | Reply | CPU, CPU USE, CPU SKEW | Thank you for the quick answer.
If i wanted to know exactly how many cpu cycles available for 1hr on PROD box with 6650C and 5555H cooexistence system, I think my below formula is corre... |
32 | 21 Dec 2014 @ 08:02 PST | Viewpoint | Reply | CPU, CPU USE, CPU SKEW | Steve,
I have a related question to calculate number CPU cycles a particular system can support. For ex: I have a 6700 production box. If i want to calculate the capacity of that box in terms of N... |
31 | 21 Dec 2014 @ 01:16 PST | Database | Reply | DBQL AMPCPUTime and TDWM Exception Abort | Rob,
I have a Prod like system where we are noticing too many exceptions on a specific user and many queries are getting aborted due to the exception defined on after N number CPU time (in ms). T... |
30 | 25 Jul 2014 @ 10:20 PDT | Database | Reply | Aborting Session | Vasu,
RCVManager is CNS subsystem utility. You cannot invoke them via queries. Rather you can use Viewpoint Remote Console Utility OR use Cnsterm 6.
> Cnsterm 6
start rcvmanager;
rcmanager... |
29 | 26 Jun 2014 @ 03:04 PDT | Database | Reply | Disable TD2 logon but allow LDAP for certain users | There is a way to do this by enabling the strong password profile settings.
Let me know if you need further details.
Geeta.
|
28 | 05 Jun 2014 @ 07:15 PDT | Viewpoint | Reply | What Teradata products would you like to see in Viewpoint? | Good to know this. Thank You Gary.
|
27 | 03 Jun 2014 @ 05:37 PDT | Database | Reply | ORPHAN ACCESS RIGHTS - HOW TO DELETE ? | Orphan rights not the similar to direct grants, those are the rows in dbc.accessrights be left behind after a drop table. I am not sure whether you are aware of the story behind how these orphan ro... |
26 | 03 Jun 2014 @ 03:39 PDT | Viewpoint | Reply | What Teradata products would you like to see in Viewpoint? | Gary,
I was wondering which version of VP can support the complete set of features of Workload Analyzer. Can you please confirm.
|
25 | 06 Jan 2014 @ 09:24 PST | Database | Reply | Resource Partition Weight for Default partition in Priority Scheduler in TASM. | Woody,
I am just asking this to know what is the worst case scenario it leads to if i keep one or couple of workload definitions in to RP0?
I heard many times that RP0 is strictly intende... |
24 | 06 Jan 2014 @ 09:21 PST | Database | Topic | Enabling MonSesCPUNormalization | Hi All,
I have a question on enabling MonSesCPUNormalization parameter. Currently we have appliance and enterprise platforms.
I know With MonSesCPUNormalization enabled, exception management wi... |
23 | 03 Jan 2014 @ 10:09 PST | Private Forum |
22 | 20 Dec 2013 @ 11:24 PST | General | Reply | MVC Tool | I personally likes Prise tool. It gives you the amount of gain on the list of tables that you selected. In our system, some of the tables are already compressed, so first i run my own query t... |
21 | 20 Dec 2013 @ 09:21 PST | Private Forum |
20 | 19 Dec 2013 @ 07:57 PST | Database | Reply | Account Strings - AG | Thanks for quick confirmation.
May be i will check with masters and Teradata.
|
19 | 19 Dec 2013 @ 07:28 PST | Database | Reply | Account Strings - AG | Hi Dieter,
Is there any limit on number account strings that need to be created for one system. Currently we are each one for individual user and databse (except, for DBA's Developer's... |
18 | 03 May 2013 @ 06:59 PDT | Viewpoint | Reply | Workload Designer and Viewpoint 14 with RDBMS 13.10 error | Hi Gary,
In my production TASM portlet, we are noticing the length of the WL Designer portlet is getting lengthier due to older version of rule sets under "Local" section. Its almo... |
17 | 22 Feb 2013 @ 05:08 PST | Private Forum |
16 | 04 Jan 2013 @ 05:04 PST | Private Forum |
15 | 03 Jan 2013 @ 06:00 PST | Private Forum |
14 | 14 Dec 2012 @ 09:58 PST | Private Forum |
13 | 11 Dec 2012 @ 10:30 PST | Private Forum |