#DateForumTypeThreadPost
1624 Apr 2012 @ 09:12 PDTViewpointReplyProblem deleting workloads Hi there, The issue is solved now and I am able to delete the workloads. There wasn't any other workloads being demoted into these workloads,and there were no "active" exceptio...
1524 Apr 2012 @ 04:31 PDTViewpointTopicProblem deleting workloads Hi there, I'm trying to delete some workloads that we have in our TASM ruleset. These workloads are not being used,have no classification criteria,and no exeption criteria.   ...
1414 Mar 2012 @ 09:25 PDTToolsReplyRowhash deadlock during BTEQ insert Hi Ulrich, Thanks for the help but I made some changes based on Deiter's advice above by only using 1 session if using PACK. The BTEQ insert ran successfully and was still very quick so ...
1314 Mar 2012 @ 07:29 PDTToolsReplyRowhash deadlock during BTEQ insert Hi Deiter, Yes I use ".PACK 250" in the script,and 5 sessions.   This is to speed up the insert and also to have fewer rows being logged in DBQL. If find it st...
1214 Mar 2012 @ 07:01 PDTToolsReplyRowhash deadlock during BTEQ insert Hi Ulrich, Thanks for the reply. The values in the text file are all unique. The ACC_ID_NO values are all 12 characters long. I have changed the BTEQ script to make this 12 too ...
1114 Mar 2012 @ 04:20 PDTToolsTopicRowhash deadlock during BTEQ insert Hi there, I am experiencing a deadlock situation while performing a simple insert using a BTEQ script,and am wondering if anyone else has experienced the same problem and knows of a workarou...
1014 Feb 2012 @ 02:26 PSTViewpointReplyampload utility in Viewpoint?? Thanks a lot Steve!
913 Feb 2012 @ 04:03 PSTViewpointTopicampload utility in Viewpoint?? Hi there, Quick question - Does anyone know where I can see the ampload utility(or the equivalent) in Viewpoint? We are moving from Teradata Manager to Viewpoint currently and I don't se...
813 Jul 2011 @ 04:12 PDTToolsReply<Internal Session> blocking users and causing deadlockHi there, We were not able to resolve this issue(as we were not aware of a patch to correct it,if there is one). We have dramatically reduced the occurances of the problem by: - ensuring that w...
721 Dec 2010 @ 04:09 PSTDatabaseTopicQuery table header info?Hi there, It may be wishful thinking but is there a proper way to find out table header information(such as DATABLOCKSIZE,FREESPACE etc) for all tables without having to do multiple 'Show Table......
607 Dec 2010 @ 03:05 PSTDatabaseReplyCreate table as..with data...with compression?Thanks very much for your help.
501 Dec 2010 @ 04:12 PSTDatabaseTopicCreate table as..with data...with compression?Hi there, I'm just wondering if this feature exists? Am looking at running 'Create table As....' script and would come in handy if I could specify some compression values in the process to save sp...
416 Sep 2010 @ 04:29 PDTDatabaseTopicCurrentPerm different after restoreHi there, I'm hoping this will be an easy answer for somebody but I just have a question about CurrentPerm differences before and after a restore. We are noticing instances where the CurrentPer...
324 Aug 2010 @ 08:33 PDTToolsReplySend email from Remote Console?Hi Carlos, Thanks for the response,we will give that a go. Cheers, Marcus
223 Aug 2010 @ 08:04 PDTToolsTopic<Internal Session> blocking users and causing deadlockHi there, We are having a problem here at our site for some time and we are wondering if anybody else has had a similiar problem. The problem is a locking issue we are having where the system dea...
123 Aug 2010 @ 06:21 PDTToolsTopicSend email from Remote Console?Hi there, I'm looking to run the SHOWLOCKS utility at regular intervals.For this I am using the Teradata Manager Scheduler,and have a recorded script called 'CHECK_TEST_LOCKS'. At the moment I ...