#DateForumTypeThreadPost
3013 Feb 2015 @ 08:18 PSTDatabaseReplyCLI error: MTDP: EM_GSSINITFAIL(235): call to gss_init failedWhat would be the corresponding location on a WS2008 R2 server?
2901 May 2013 @ 01:12 PDTDatabaseReplyAlgorithmic compression in DBQL History tablesJust reread my post.   I meant to say that I got an 80% compression with LZCOMPon the DBQLSQL table. 
2801 May 2013 @ 12:18 PDTDatabaseReplyAlgorithmic compression in DBQL History tablesALC seems to work just fine. It didn't do a whole lot on the DBQLog table but I saw a significant compression rate of 80% with LZCOMP. NTA3239 just surfaced. It concerns possible corruption wh...
2720 Mar 2013 @ 06:44 PDTDatabaseTopicAlgorithmic compression in DBQL History tablesI am considering the impementation of algorithmic compression within our 13.10 system's DBQL History tables. We have quite a long retention requirement for this data and the daily maintenance a...
2619 Mar 2012 @ 01:37 PDTConnectivityReplyJDBC Encryption So I basically just have to "trust" that the encryption is working? Thanks for the info on the LOG=DEBUG argument. I'll give that a shot. 
2519 Mar 2012 @ 07:04 PDTConnectivityTopicJDBC Encryption I have a couple application are are using ENCRYPTION=ON in their connection strings.  Is there any way to tell on the database side (DBQL, etc) so that I may verify that the encryption para...
2401 Feb 2012 @ 09:03 PSTDatabaseReplyParsing Engine is taking long time to parse a query !!! I'm seeing some of this as well especially as the number of sessions increase
2330 Jan 2012 @ 08:50 PSTConnectivityReplyBTEQ/Fastload CLI Data Transfer Encryption from the Security Administration manual... Password Encryption   When users log on to the database, the system transmits passwords in encrypted form, using the AES...
2230 Jan 2012 @ 07:41 PSTConnectivityTopicBTEQ/Fastload CLI Data Transfer Encryption Can anyone provide information as to the encrytion strength of BTEQ/Fastload/Multiload etc when DATAENCRYPTION is ON? I have not been able to find the specification in the Manuals. I have fo...
2105 May 2010 @ 02:02 PDTDatabaseReplyTable Design & PerformanceBy placing columns in the order described by the TD12 Database Design Manual p801+ (fixed,compressed, variable) would it save the system time/resources by avoiding an internal reorder of the columns?
2005 May 2010 @ 10:10 PDTDatabaseTopicTable Design & PerformanceWhen creating tables in Teradata is there an advantage to placing the column(s) that will be used for the Primary Index at the top of the column list? Also, when several columns in a table are...
1905 May 2010 @ 09:48 PDTDatabaseTopicTD Data Type ConsiderationsAre there any recommendations, from Teradata or otherwise, as to what data types to avoid or limit due to database overhead or performance considerations, etc? I understand that in DB2 and SQL s...
1815 Jan 2010 @ 07:23 PSTToolsReplySQL Assistant 12.0You can download the latest version from Teradata@YourService. (www.teradataatyourservice.com). Look for the small "Client Patches" link.
1707 Oct 2009 @ 05:39 PDTToolsTopicNetVault and Alert PolicyOur shop is having difficulty with our NetVault Backup failing due to what seems to be our alert policy through TASM killing "idle" sessions of the backup.Shortly after our upgrade to TD 12.0.2.20 ...
1623 Feb 2009 @ 11:08 PSTDatabaseTopicDemo/training database and usersWhere can I find the DDL to recreate the demo/training databases?I am looking for a way to recreate the training databases on my system that were preinstalled when we got the system new, specifical...
1519 Dec 2008 @ 03:35 PSTToolsTopicDBCMANAGER Logon/LogoffI was doing some quarterly analysis on our Production system and noticed that DBCMANAGER is doing a lot of logon/logoffs (About 30 times per minute). I was wondering if this is normal behavior or ...
1405 Nov 2008 @ 04:14 PSTToolsTopicMeta Data ServicesOur site recently purchased a new Node to replace our production system. Many users have spent their time entering MDS information for the old system. Since the new production system shares the sa...
1305 Nov 2008 @ 03:22 PSTToolsReplyTDWM 6.2 Period CreationFrom: fpluebel@jcpenney.com [mailto:fpluebel@jcpenney.com] Upgrade to latest efix level of TDWM Admin 6.2 (currently 6.2.0.5) and try again. There were some fixes in 6.2.0.4 that might be relevant ...
1231 Oct 2008 @ 02:46 PDTToolsTopicTDWM 6.2 Period CreationI am new to Teradata Workload Manager and am having difficulties setting up a Period for Business Hours for the production environment. I am on TDWM 6.2.0.1 on Windows XP on my local machine.When ...
1128 Oct 2008 @ 12:12 PDTToolsReplyimplement Teradata Dynamic workload managerI just went through this. Hope I'm not too late.If you rerun the Database Setup program from within Teradata Manager and use your current users/passwords it will ask you if you want to upgrade you...
1027 Aug 2008 @ 10:23 PDTDatabaseReplyTeradata AMP lock table overflowThanks for all the info guys!
921 Aug 2008 @ 05:00 PDTDatabaseReplyTeradata AMP lock table overflowWhy is that exactly? How do I avoid/remedy this situation?
814 Aug 2008 @ 09:25 PDTDatabaseReplyTeradata AMP lock table overflowYes. That is the error I get. I found the error description in the Messages User Guide. However, I'd like to see where the definition of each AMP having 2MB for locks is found. In what manual c...
705 Aug 2008 @ 05:24 PDTDatabaseReplyTeradata AMP lock table overflowIn what manual can I find this information?
604 Aug 2008 @ 02:47 PDTDatabaseTopicTeradata AMP lock table overflowOur system has experienced AMP lock table overflows a few times last week. We have had the programmers adjust their code to avoid so many locks, but we were wondering if there are any type of data...

Pages