30 | 13 Feb 2015 @ 08:18 PST | Database | Reply | CLI error: MTDP: EM_GSSINITFAIL(235): call to gss_init failed | What would be the corresponding location on a WS2008 R2 server?
|
29 | 01 May 2013 @ 01:12 PDT | Database | Reply | Algorithmic compression in DBQL History tables | Just reread my post.
I meant to say that I got an 80% compression with LZCOMPon the DBQLSQL table.
|
28 | 01 May 2013 @ 12:18 PDT | Database | Reply | Algorithmic compression in DBQL History tables | ALC 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... |
27 | 20 Mar 2013 @ 06:44 PDT | Database | Topic | Algorithmic compression in DBQL History tables | I 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... |
26 | 19 Mar 2012 @ 01:37 PDT | Connectivity | Reply | JDBC 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.
|
25 | 19 Mar 2012 @ 07:04 PDT | Connectivity | Topic | JDBC 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... |
24 | 01 Feb 2012 @ 09:03 PST | Database | Reply | Parsing Engine is taking long time to parse a query !!! |
I'm seeing some of this as well especially as the number of sessions increase
|
23 | 30 Jan 2012 @ 08:50 PST | Connectivity | Reply | BTEQ/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... |
22 | 30 Jan 2012 @ 07:41 PST | Connectivity | Topic | BTEQ/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... |
21 | 05 May 2010 @ 02:02 PDT | Database | Reply | Table Design & Performance | By 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? |
20 | 05 May 2010 @ 10:10 PDT | Database | Topic | Table Design & Performance | When 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... |
19 | 05 May 2010 @ 09:48 PDT | Database | Topic | TD Data Type Considerations | Are 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... |
18 | 15 Jan 2010 @ 07:23 PST | Tools | Reply | SQL Assistant 12.0 | You can download the latest version from Teradata@YourService. (www.teradataatyourservice.com). Look for the small "Client Patches" link. |
17 | 07 Oct 2009 @ 05:39 PDT | Tools | Topic | NetVault and Alert Policy | Our 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 ... |
16 | 23 Feb 2009 @ 11:08 PST | Database | Topic | Demo/training database and users | Where 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... |
15 | 19 Dec 2008 @ 03:35 PST | Tools | Topic | DBCMANAGER Logon/Logoff | I 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 ... |
14 | 05 Nov 2008 @ 04:14 PST | Tools | Topic | Meta Data Services | Our 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... |
13 | 05 Nov 2008 @ 03:22 PST | Tools | Reply | TDWM 6.2 Period Creation | From: 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 ... |
12 | 31 Oct 2008 @ 02:46 PDT | Tools | Topic | TDWM 6.2 Period Creation | I 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 ... |
11 | 28 Oct 2008 @ 12:12 PDT | Tools | Reply | implement Teradata Dynamic workload manager | I 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... |
10 | 27 Aug 2008 @ 10:23 PDT | Database | Reply | Teradata AMP lock table overflow | Thanks for all the info guys! |
9 | 21 Aug 2008 @ 05:00 PDT | Database | Reply | Teradata AMP lock table overflow | Why is that exactly? How do I avoid/remedy this situation? |
8 | 14 Aug 2008 @ 09:25 PDT | Database | Reply | Teradata AMP lock table overflow | Yes. 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... |
7 | 05 Aug 2008 @ 05:24 PDT | Database | Reply | Teradata AMP lock table overflow | In what manual can I find this information? |
6 | 04 Aug 2008 @ 02:47 PDT | Database | Topic | Teradata AMP lock table overflow | Our 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... |