33 | 10 Aug 2016 @ 06:10 PDT | Private Forum |
32 | 09 Aug 2016 @ 12:31 PDT | Private Forum |
31 | 06 Jul 2016 @ 11:17 PDT | Database | Topic | Can't free up small amounts of space | Hi
I'm trying to free up space in some parent databases that have no objects. In some cases, a small amount of space is left behind (e.g. 136 bytes, other DBs leave behind less than... |
30 | 27 Apr 2016 @ 06:08 PDT | Database | Reply | DBQL data | Hi
Most likely you don't have object logging enabled (no Object data), you could try an outer join to confirm, or try your original query with the logdate where clause in place of your lo... |
29 | 26 Apr 2016 @ 05:13 PDT | Database | Reply | DBQL data | Hi
The DBQL history tables through PDCR have a PPI on LOGDATE, so if you use LOGDATE in your where clause you will only access the partitions for the year in question.
In regards to tables not us... |
28 | 11 Apr 2016 @ 05:21 PDT | Database | Reply | Identity column question - increment behaviour | Each AMP is assigned a pool of numbers in the range you specify, therefore depending on which AMP the row is written to, determines which numbers are actually used.
|
27 | 17 Jan 2016 @ 02:32 PST | Cloud Computing | Reply | Teradata Express VMWare 15.10.0.7 with Viewpoint | Hi Padhia
When you see the message "Cannot connect to this Teradata database system", I believe the problem maybe that the "system config" collector has not run to be... |
26 | 03 Jan 2016 @ 04:52 PST | Viewpoint | Reply | Query Monitor portlet refresh rate | Hi
Just a clarification, we discovered after the production upgrade, that the query monitor refresh rate changed from 10 seconds to 1 minute after the database was upgraded to 15.00 and still unde... |
25 | 16 Dec 2015 @ 08:37 PST | Viewpoint | Topic | Query Monitor portlet refresh rate | Hi
We have a system running Viewpoint 15.00 and Teradata 15.00 with SLES 11.
Prior to upgrading to SLES 11, so the Teradata and Viewpoint were both 15.00, we had configured the Query Monitor... |
24 | 16 Sep 2015 @ 11:44 PDT | Cloud Computing | Reply | Viewpoint performance in VM | Hi
If I disable DCS on VP it seems to work a lot better, however that depends on what I'm doing in VP if I need data from the data collectors, in which case I can try and reduce collection rat... |
23 | 15 Sep 2015 @ 11:16 PDT | Cloud Computing | Topic | Viewpoint performance in VM | Hi
I have installed the TD 14.10 sles10 1TB express version with Viewpoint on my Windows 7 machine which has 8 Gig of RAM. I have assigned 4 GB of RAM to the VM, however I either can... |
22 | 31 Aug 2015 @ 04:33 PDT | Database | Reply | Top resource consuming query | Hi
pdcr reports have a top x report you can run to show the highest cpu resourced queries.
Cheers
Steven
|
21 | 20 Jan 2015 @ 08:04 PST | Database | Topic | Capture Query transfer volume | Hi
Is there anywhere that captures the volume (i.e. MB, GB) of data prodcued by a query, that is then sent back to the client. In the query logs we can see the query execution time... |
20 | 07 Sep 2014 @ 10:35 PDT | Extensibility | Reply | REGEXP_SUBSTR in Teradata 13.10 | Hi Raja
The oracle functions list contain functions like oreplace, translate, rtrim, ... but not the regular expression functions.
The second link you provided has the function REGEXP_INSTR... |
19 | 07 Sep 2014 @ 07:35 PDT | Extensibility | Topic | REGEXP_SUBSTR in Teradata 13.10 | Hi
I was wondering if anybody had the regexp_substr UDF for Teradata 13.10 or the C code that can be used to create the UDF. I realise that regular expression functions are available as part... |
18 | 03 Sep 2014 @ 06:01 PDT | Viewpoint | Topic | How to determine users logged onto the Viewpoint server | Hi
Can anybody please advise the best way to determine users currently logged onto viewpoint (not the database), as I would like to check before stopping and starting viewpoint services. ... |
17 | 17 Aug 2014 @ 05:06 PDT | Database | Reply | Determine new table skew for a different PI | Thanks everybody for your replies.
Steven
|
16 | 14 Aug 2014 @ 10:02 PDT | Database | Topic | Determine new table skew for a different PI | Hi
I was wondering if there was a way to calculate the skew of an existing table with a different choice of PI. I am aware of the hashing functions, such that the following query will show t... |
15 | 12 Aug 2014 @ 10:39 PDT | Viewpoint | Reply | Portlet refresh rate | Yep good point, have modified.
Cheers
|
14 | 11 Aug 2014 @ 06:56 PDT | Viewpoint | Reply | Portlet refresh rate | Thanks Stever
I have updated our data collectors for Disk space and Database space to the minimum of 15 minutes (900 seconds). I have also modified the sessions collector from 30 secon... |
13 | 11 Aug 2014 @ 04:07 PDT | Viewpoint | Reply | Portlet refresh rate | Hi Glass
Thanks for that, yes it is set to 60 seconds. Is that the same for all portlets, as the SYSTEM HEALTH portlet has in the past taken longer to refresh after an issue like DBC out of ... |
12 | 10 Aug 2014 @ 06:16 PDT | Viewpoint | Topic | Portlet refresh rate | Hi
Is there a way we can change the portlet refresh rate. I know we can manually do a refresh, but wondering if we change certain data collectors if this will update the refresh rate. ... |
11 | 06 Aug 2014 @ 06:20 PDT | Tools | Reply | TTU 15.0 | Hi Raj
Is the problem connecting to the database, or loading SQLA. If the later, then can be due to the size of the history table, so can reduce this size in the filter options, the history ... |
10 | 03 Jun 2014 @ 06:11 PDT | Database | Topic | Disable TD2 logon but allow LDAP for certain users | Hi
We have LDAP authentication at Customer site for users, but also use TD2 connection for internal accounts such as SYSDBA.
When the end user accounts are created, they have a default password a... |
9 | 17 Oct 2013 @ 06:31 PDT | Connectivity | Reply | F5 versus DNS | Thanks for the feedback, it was the LCC that I was referring to when I mentioned that DNS was a bit smarter, but thanks for advising the F5 also makes use of LCC
Are there any issues with large da... |