#DateForumTypeThreadPost
5801 Jul 2013 @ 11:24 PDTDatabaseTopicCHECKTABLE Utility RunWhile running CHECKTABLE, it is skipping checking of unhashed tables,fastpath UDMs. What is a fastpath UDM ? Why CHECKTABLE is skipping these(unhashed tables/fastpath UDMs)?
5728 Jun 2013 @ 09:24 PDTViewpointTopicAborted Session Info in ViewPointIn View Point, DBAs abort sessions of queries that are badly performing and overally impacting the System performance(because of improper query, stale stats, etc.).Is there any system table or quer...
5628 Jun 2013 @ 08:55 PDTDatabaseTopicSession Blocked by another idle sessionIn View Point , I am observing an IDLE session is blocking an ACTIVE session.On further investigating, I found the blocker session is holding a Read Lock on one of the tables that the blocked sessi...
5528 Jun 2013 @ 07:42 PDTDatabaseReplyAborting SessionCancelling the roll back will render the object unusable. Is there any other way out?
5428 Jun 2013 @ 07:39 PDTDatabaseTopicMR and MS access rightsWhat is the use of MONRESOURCE (MR) and MONSESSION (MS) access rights? Whare are they used?
5320 Jun 2013 @ 03:01 PDTDatabaseTopicAborting SessionIn View Point, a session is in ABORTING state for more than 8 days now. Whats the reason the session is taking so long to abort? Is there any way to get rid of this aborting session, to clean up ...
5213 Jun 2013 @ 11:52 PDTDatabaseTopicResponding Session: CPU Use and Impact CPUI am observing a session thru View Point , which is in responding state for the past 10 days The CPU Use is 0 but the Impact CPU is 33.7 Similary I/O is 0 but I/O skew is 55%. Could anyone expla...
5113 Jun 2013 @ 10:15 PDTDatabaseTopicHUT LockWhat is the command to see the tables that are locked by HUT (Host Utility) locks on a Teradata database?
5009 Jun 2013 @ 11:06 PDTDatabaseTopicTeradata Query DirectorIn a dual active system, how does Teradata Query Director handle the routing of user sessions from primary to secondary during load balancing or production failover scenario if the user passwords a...
4905 May 2013 @ 07:51 PDTDatabaseReplySession PoolingThanks for the info. Correction: The reference manual reffered above is Teradata Director Program Reference
4805 May 2013 @ 07:48 PDTDatabaseTopicTracking Time When Last AccessedWhich DBC table(s) can be used to know when an database object (table/view/store proc/macro) was last accesed (for sel/insert/update etc.)  ? I can use the DBCLogTbl for that purpose to see t...
4703 May 2013 @ 04:52 PDTDatabaseTopicSession Pooling  A session pool is a whole bunch of sessions that are logged on to Teradata using the same logon string.   A session pool is started by a START POOL command and this command ...
4617 Dec 2012 @ 08:23 PSTDatabaseTopicSkewness of SPs in TeradataWhat is the skewness of a stored procedure in Teradata? I am getting the Skew factor close to 100 (~99) for SPs in Teradata.  The database only contains SPs.Is it that SPs are stored AMP loc...
4526 Sep 2012 @ 01:47 PDTDatabaseTopicDBC.ClearAccounting macro        To reset counters for ALL rows or selected rows , we use the DBC.ClearAccounting macro.       The macro is defined as follows in TD 13.00:   &...
4427 Jun 2012 @ 09:41 PDTDatabaseTopicCharacter to Date Conversion I have a character column which stores date ,as in, 20120310(yyyymmdd) format. There is requirement of dispalying this as 10-Mar-2012. How can this conversion be made?   Thanks,...
4316 May 2012 @ 06:16 PDTDatabaseTopicPseudo Table Locking   The pseudo table mechanism is a way to serially queue all table level locks through the use  of an internal pseudo tabe.In this table the database locks the row hash of ...
4202 Apr 2012 @ 08:02 PDTDatabaseTopiccollect stats There is an Orders table which which is a PPI table with partition on order_date column. If we need to collect stats ,which will be better and why? COLLECT STATISTICS ON orders COLUMN PA...
4111 Mar 2012 @ 04:56 PDTDatabaseTopicNUSI space utilization How can we know the space used by an NUSI?
4026 Dec 2011 @ 09:55 PSTDatabaseTopicPrimary Key Implementation How is primary key concept implemented in teradata?(like primary index is implemented using hash algorithm).  
3909 Dec 2011 @ 08:48 PSTDatabaseTopicPrimary key   Hi,   We can define primary key on a table in teradata.It can be a different column from the primary index in teradata.   How does primary key concept implem...
3819 Nov 2011 @ 11:38 PSTGeneralTopicTPT Reference guide Hi, Wanted to know any good study guide or ref. material,with sample scripts  available for gaining knowledge on Teradata Parallel Transport?   Thanks, Kishore
3711 Nov 2011 @ 01:45 PSTDatabaseTopicSET and MULTSET table table1 ia a multiset table.Using table1 , 2 tables are created using the following syntax:   1- CT table2 as (select * from table1) with no data; 2- CT table3 as table1 with no ...
3614 Sep 2011 @ 05:59 PDTDatabaseReplyUnique secondary index violation error The primary is a composite one ,i.e,(col1,col2,col3) combination should be unique,not a single column. So, when col2 is defined as secondary index, does it treat this as unique?
3513 Sep 2011 @ 07:29 PDTDatabaseTopicUnique secondary index violation error Hi, There is a table with the following definition: Create table Table1 ( col1 SMALLINT, col2 INTEGER, col3 CHAR(5), col4 INTEGER, ..., ..., col...
3429 Aug 2011 @ 08:08 PDTDatabaseTopicFORMAT symbol Hi, I  want to use the FORMAT attribute to display the data in a specified format. Could anybody tell what do the the following format symbols means: 1) (I) 2) N 3) G

Pages