#DateForumTypeThreadPost
1711 May 2014 @ 08:56 PDTDatabaseReplyhow UPI gives even distributionHi, Yes, they would, but for small tables it would not cause any issues and for tables with every additional record the probability of that is decreasing. Probability of having 10 rows on the same...
1629 Apr 2013 @ 04:59 PDTViewpointReplySQL and Explain sometimes not visible in query monitorHello again Gary, I think I have figured it out (partially). We do not see this information for the queries, no matter what they consume in case they run from a stored procedure. I did this litt...
1529 Apr 2013 @ 02:13 PDTViewpointReplySQL and Explain sometimes not visible in query monitorHello Gary, thanks for explaining the relations of the tresholds. However, we often have a bad queries running for long time, consuming high cpu and we do not see thier SQLs and Explain plans. For...
1424 Apr 2013 @ 06:23 PDTViewpointTopicSQL and Explain sometimes not visible in query monitorHello VP experts, We have noticed a weird behaviour after VP and DB upgrade to version 14. Our VP is now V14.00.00.05-b49 and DBs are on 14.00.02.05 and 14.00.03.03. The problem is that sql and e...
1304 Mar 2013 @ 04:33 PSTDatabaseReplyDBSControl Internal flag DISABLECARHi, so if anyone will read this and was wondering. This can disable Column Access Rights.
1211 Jan 2013 @ 05:12 PSTDatabaseTopicDBSControl Internal flag DISABLECARHello, does anyone know what does internal DBSControl flag called DISABLECAR do? Thanks, GLHF, Yuri
1127 Dec 2012 @ 04:33 PSTDatabaseReplyHow to install external UDF libraries on Hot Standby Node (HSN)?So we have learned there is an internal dbscontrol flag to copy udflib files to the HSN node whenever a UDF is (re)compiled. This is useful in our 1+1 configuration (1 working node and 1 HSN). This...
1005 Dec 2012 @ 07:45 PSTDatabaseReplyHow to install external UDF libraries on Hot Standby Node (HSN)?Thanks for the posts, somehow I suspect that the HSN did not work properly, because there was a kernel panic situation on the active node (our system has 2 NODEs, one of them is HSN), we will test ...
904 Dec 2012 @ 12:41 PSTDatabaseReplyHow to install external UDF libraries on Hot Standby Node (HSN)?Hello Fred, no, we install the UDFs with the create/replace SQL command from BTEQ. My assumption is that it only compiles the shared objects on the active nodes, not the HSN. Similar to the docume...
829 Nov 2012 @ 09:15 PSTDatabaseReplySQL ErrorIf you have DBQL enabled, you can troubleshoot it yourself, look into dbc.dbqlogtbl, dbc.dbqlexplaintbl and dbc.dbqlsteptbl and search for your query. From the explain and steptbl you can determine...
729 Nov 2012 @ 08:55 PSTDatabaseReplyhow to logon to bteqNormally, you want to use: .logon <ip_address or name>/dbc pw is dbc if i remember it right, anyways 13.10 is a better version than 13.0, you have to make sure that the port 1025 is open if...
629 Nov 2012 @ 04:56 PSTDatabaseTopicHow to install external UDF libraries on Hot Standby Node (HSN)?Hello, Recently we had a db crash on TD14 and our HSN took over but did not take over the operation because it was missing libraries for the external (C/C++) UDFs. Any ideas how to identify what ...
517 Jul 2012 @ 11:04 PDTConnectivityReplyQuery retry on deadlock in JDBC Hello Tomnolan, Thanks for the answer.
417 Jul 2012 @ 08:36 PDTConnectivityTopicQuery retry on deadlock in JDBC Hello, I have gone through JDBC documentation, but I have not found a property or any other way, how to tell jdbc to retry a query that was aborted due to a deadlock. We are running a lo...
324 Apr 2012 @ 05:24 PDTDatabaseTopicTeradata[27383]: INFO: Teradata: 3160 #3160: DBQL or TDWM Cache invalid or size exceeded. Dear community, I would like to have any opinions from you, who experienced simmilar issues. I have been chcecking the messages on the SUSE Linux 10 hosing our Teradata DB 13.10 and spotted ...
220 Mar 2012 @ 03:19 PDTConnectivityReplyJDBC driver pagination support Thanks for explanation ^_^
116 Mar 2012 @ 08:23 PDTConnectivityTopicJDBC driver pagination support Hi, Developers have asked us how to implement pagination in JDBC, seems like Teradata Dialect of Hibernate does not have the support implemented. However, I have seen this working on view...