#DateForumTypeThreadPost
1523 Mar 2011 @ 10:40 PDTDatabaseReplyThe size of Prepared Statement objectI think, yes (cause app server returns cached PreparedStatement objects). I need it to measure how much memory will be consumed by caches of different capacities.
1423 Mar 2011 @ 07:50 PDTDatabaseTopicThe size of Prepared Statement objectHello, I need in a little bit specific information - I need to know how much memory is consumed by statements prepared by Teradata database (in case of using Prepared Statements). I'm using app...
1317 Jun 2009 @ 01:04 PDTDatabaseReplyHow to speed up inserting data into volatile table ?Thanks, I'll try stored procedures....maybe its really will help :)
1217 Jun 2009 @ 01:02 PDTDatabaseReplyHow to speed up inserting data into volatile table ?I've tried with/without primary_keys/indexes - result is the same.
1117 Jun 2009 @ 12:47 PDTDatabaseReplyHow to speed up inserting data into volatile table ?Thanks for your answer!Testing workstation is not too fast themselves but it not in use at this time by anybody excepting me.I've tried to remove SET and add "NO BEFORE JOURNAL" and "NO AFTER JOURN...
1017 Jun 2009 @ 12:14 PDTDatabaseTopicHow to speed up inserting data into volatile table ?Hello!Is it any way to speed up inserting data into volatile table? I've tried to INSERT ~50.000 rows(selected from another table) and it was ~40 minutes.DDL is simple:CREATE SET VOLATILE TABLE v_t...
916 Jun 2009 @ 11:01 PDTDatabaseTopicSpool or CPU usageHi!Now I'm optimizing SQL queries and have a question - what is better: to decrease Spool Usage or to decrease CPU Usage(if they can not be decreased together) ?Some additional data:TotalCPUTime/Sp...
803 Oct 2007 @ 05:51 PDTConnectivityTopicjdbc error with two {escape '\'}Hello!I have SQL query which contains {escape '\'} function.If I use only one {escape '\'} function all works fine and ResultSet is returned.But if I insert two or more {escape '\'} JDBC driver thr...
702 Aug 2007 @ 05:03 PDTDatabaseTopicError: No more room in database DBCHello.I have some already created databases and want to add some table into them. But when I trying to create new tables teradata gives out to me message "No more room in database DBC".What does it...
619 Jul 2007 @ 01:39 PDTConnectivityTopicJDBC error: Error tdgss-stack-trace-beginI really don't know how to fix this problem because I don't know, what is the problem???Caused by: java.sql.SQLException: [NCR] [Teradata JDBC Driver] : TeraEncrypt: Error tdgss-stack-trace-begin>>...
518 Jul 2007 @ 04:01 PDTDatabaseReplyError while trying to connect to TeradataNow Teradata write:"com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : Access Logging step has failed. The transaction was aborted."Also don't know how to solve. Google can't help.
418 Jul 2007 @ 03:34 PDTDatabaseReplyError while trying to connect to TeradataThe problem is solved.Single Sign-On must be switched on:gtwcontrol -a on
318 Jul 2007 @ 01:22 PDTDatabaseTopicError while trying to connect to TeradataHello.I'm trying to start web application which use Teradata as database under WebSphere 6.1.Application must connect to db via DataSource(defined correctly, I think).When application try to open c...
220 Jun 2007 @ 05:21 PDTDatabaseReplyDoes Teradata have packagesThank you for your reply.
120 Jun 2007 @ 01:04 PDTDatabaseTopicDoes Teradata have packagesDoes Teradata have "packages" similar to Oracle packages ?I cant find any information about this in documentation.Thanks.Best Regards, Sergey.