#DateForumTypeThreadPost
1002 Jul 2013 @ 04:35 PDTDatabaseReplyApplications configurationIf a node is down. Put the ip of the available nodes. You would be able to connect to the system.
930 Jun 2013 @ 03:39 PDTConnectivityReplyError 8017 - The UserId, Password or Account is invalidA user was unable to login. Even after changing the password. Then i check the table dbc.logonoff which showed it was locked. Released the user. It worked. 
826 Jun 2013 @ 08:25 PDTDatabaseReplyPartition EliminationHi,   I have a question. We have a table having column with timestamp data type. Partition is applied on the column by casting it to date data type. attached below. Col1 TIMESTAMP(0)) PR...
718 Jun 2013 @ 07:36 PDTDatabaseReplyCompression on Indexes Hi ,   Can we apply compression on a partitioning column that is not part of the PI.?   Thnx, Irfan
616 Jun 2013 @ 07:12 PDTDatabaseReplyCloning a user including access rightsHi , Is there any method to make a clone of a user. Different names but the access and privilage be the same? Thanx. Irfan
525 Sep 2012 @ 05:58 PDTUDAReplyconvert varchar to timestampHi,   I have a varchar column with values in the following format. 2012-09-25 00:49:59  I am trying to cast this value into timestamp using the above suggestions but was unsuccess...
408 Nov 2011 @ 04:04 PSTViewpointTopicViewpoint Delayed Sessions Hi ,  Last night we had some delayed sessions with rule type "object delayed query". The no. of sessions was around 4 which is very small to provoke TASM throttles to delay th...
330 Oct 2011 @ 12:08 PDTDatabaseReplyWhat is spool space in teradata? explain with examples. We have a rule i.e if a query takes more than one terabyte of spool we are supposed to abort it. My question is lets say the total spool is used by a query , what is the expected behavior of...
218 Oct 2011 @ 03:21 PDTViewpointReplyInfo on Viewpoint Database Hi ,   A few questions at ur service, i hope you ll answer them.in query monitor portlet ,i have observed sessions with no sql. what does it mean? also in another case the sql tab was s...
110 Sep 2011 @ 10:00 PDTDatabaseReplyStored Procedures, Dynamic SQL, Funky Range Scans, and GETINTRANGE Hi, I want to write a query which gives me count of all tables in a database. I tried to make a query but it only generetes sql for each table. Below is the query; sel 'sel' &quo...