#DateForumTypeThreadPost
3310 Aug 2016 @ 06:10 PDTPrivate Forum
3209 Aug 2016 @ 12:31 PDTPrivate Forum
3106 Jul 2016 @ 11:17 PDTDatabaseTopicCan't free up small amounts of spaceHi 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...
3027 Apr 2016 @ 06:08 PDTDatabaseReplyDBQL dataHi 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...
2926 Apr 2016 @ 05:13 PDTDatabaseReplyDBQL dataHi 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...
2811 Apr 2016 @ 05:21 PDTDatabaseReplyIdentity column question - increment behaviourEach 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. 
2717 Jan 2016 @ 02:32 PSTCloud ComputingReplyTeradata Express VMWare 15.10.0.7 with ViewpointHi 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...
2603 Jan 2016 @ 04:52 PSTViewpointReplyQuery Monitor portlet refresh rateHi 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...
2516 Dec 2015 @ 08:37 PSTViewpointTopicQuery Monitor portlet refresh rateHi 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...
2416 Sep 2015 @ 11:44 PDTCloud ComputingReplyViewpoint performance in VMHi 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...
2315 Sep 2015 @ 11:16 PDTCloud ComputingTopicViewpoint performance in VMHi 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...
2231 Aug 2015 @ 04:33 PDTDatabaseReplyTop resource consuming queryHi pdcr reports have a top x report you can run to show the highest cpu resourced queries. Cheers Steven    
2120 Jan 2015 @ 08:04 PSTDatabaseTopicCapture Query transfer volumeHi 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...
2007 Sep 2014 @ 10:35 PDTExtensibilityReplyREGEXP_SUBSTR in Teradata 13.10Hi 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...
1907 Sep 2014 @ 07:35 PDTExtensibilityTopicREGEXP_SUBSTR in Teradata 13.10Hi 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...
1803 Sep 2014 @ 06:01 PDTViewpointTopicHow to determine users logged onto the Viewpoint serverHi 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. ...
1717 Aug 2014 @ 05:06 PDTDatabaseReplyDetermine new table skew for a different PIThanks everybody for your replies. Steven
1614 Aug 2014 @ 10:02 PDTDatabaseTopicDetermine new table skew for a different PIHi 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...
1512 Aug 2014 @ 10:39 PDTViewpointReplyPortlet refresh rateYep good point, have modified. Cheers
1411 Aug 2014 @ 06:56 PDTViewpointReplyPortlet refresh rateThanks 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...
1311 Aug 2014 @ 04:07 PDTViewpointReplyPortlet refresh rateHi 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 ...
1210 Aug 2014 @ 06:16 PDTViewpointTopicPortlet refresh rateHi 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.  ...
1106 Aug 2014 @ 06:20 PDTToolsReplyTTU 15.0Hi 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 ...
1003 Jun 2014 @ 06:11 PDTDatabaseTopicDisable TD2 logon but allow LDAP for certain usersHi 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...
917 Oct 2013 @ 06:31 PDTConnectivityReplyF5 versus DNSThanks 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...

Pages