#DateForumTypeThreadPost
819 Feb 2010 @ 01:13 PSTDatabaseTopicHow to kill Teradata user sesiionHi,Could someone help me to kill a particular Teradata user session, smiler to the below SQL in Oracle:ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;Thanks in advance
719 Feb 2010 @ 12:40 PSTDatabaseReplyHow to enable Session usage sampling in teradata 12.0I am new to Teradata.I am trying to run the below SQL:SEL UserName (TITLE 'Idle Users'), SessionNo (TITLE 'Session'), HostId (TITLE 'Host',FORMAT 'ZZZ9'), PartName (FORMAT 'X(8)')FROM TABL...
617 Feb 2010 @ 08:25 PSTDatabaseTopicHow to enable Session usage sampling in teradata 12.0Hi,Could someone provide me the information/steps to enable "Session usage sampling in Teradata 12.0". Kindly let me know what are the impact of enabling Session usage sampling.
528 Jan 2010 @ 04:41 PSTDatabaseReplyError -7423 while selectingI would like to reframe my sentence.Is it possible to avoid table level lock while performing insert/update. If yes, how to do the same and whether it can be done at database level setting or chang...
428 Jan 2010 @ 04:20 PSTDatabaseReplyError -7423 while selectingThanks a lot for your response.Is there any method to apply only row level lock in the insert statement or is it possible to have any setting at database level to avoid table level locking while pe...
328 Jan 2010 @ 02:53 PSTDatabaseReplyError -7423 while selectingBelow is the Object LOCK error message that we are facing while more than one session try to perform INSERT operation on the same table at same time. [NCR][ODBC Teradata][Teradata Database] Object ...
228 Jan 2010 @ 02:20 PSTDatabaseTopicError -7423 while selectingUsers1 is encountering error “7423” while selecting data from a table which has been locked by user2 at table level .User2 is performing insert/delete on the table. We believe that the User2 ha...
130 Nov 2009 @ 02:03 PSTDatabaseTopicFailure 3798: A column or character expression is larger than the max sizeHi All,I am trying to create a table on Terdata installed on UNIX machine. However, the table creation fails when the maximum size of VARCHAR datatype is set to more than 32000. Below is the error ...