#DateForumTypeThreadPost
1002 Aug 2012 @ 05:55 PDTExtensibilityReplyBLC Utility got it : http://forums.teradata.com/forum/database/linking-a-table-name-to-a-table-id giving select d.databasename, t.tvmname from dbc.tvm t, dbc.dbase d where HASHBUCKET(SUB...
902 Aug 2012 @ 05:32 PDTExtensibilityReplyBLC Utility very good.  Thanks. Next question. I have compressed datablocks for only 1 table, the showblocks command reports the table id as character 21 32762.  If I use the TABLID comman...
820 Jul 2012 @ 06:22 PDTExtensibilityReplyBLC Utility Follow up question.  Is there a way to identify all of the tables that are using BLC?
719 Jul 2012 @ 02:53 PDTExtensibilityTopicBLC Utility After downloading the utility, none of the scripts can be opened.  Any clues? cheers
608 Apr 2012 @ 02:17 PDTConnectivityReplyCan I switch between LDAP and Standard Authentication? A significant question is are you doing ldap authentication only, or authentication and authorisation.  Recommend authentication only as this requires an internal user that is implicitly ma...
506 Apr 2012 @ 03:06 PDTToolsTopicIdentify all tables on which there are failed utilities Hi   is there a quick way to regularly check whether there are any tables that are unavailable due to a failed utility.  It would also be useful to be able to link this with de...
430 Nov 2011 @ 06:13 PSTViewpointTopicResource Partition - Lock Can you explain what the lock does when the % of system is allocated to a workload?  I am seeing long running queries in a workload allocated 1.2% of the system only using 4% of the to...
303 Oct 2011 @ 05:44 PDTToolsTopicTPT SelectStmt I am trying to EXPORT the following SelectStmt    SelectStmt = 'SELECT 'GRANT '||rolename||' TO USERDAMIN WITH ADMIN OPTION;' FROM dbc.roleinfo;', this...
212 Jul 2011 @ 07:08 PDTDatabaseReplyQuery Logging NumResultRows column is always zeroThanks mnylin. I cannot find anything mentioned in the manual, but do you know if the number of records modified by a I/U/D staement is logged elsewhere? thanks
111 Jul 2011 @ 02:28 PDTDatabaseTopicQuery Logging NumResultRows column is always zeroWe are a new Tersdata site and I am investigating various auditing requirements. It would be useful to see who had changed data for which the NumResultRows column could be an effective filter, howe...