#DateForumTypeThreadPost
4316 Sep 2013 @ 11:50 PDTViewpointTopicTASM getting deactivatedHello Guys,   Iam finding a strange problem at my site.. We have enabled TASM and at times it automatically gets deactivated. When this happens i have go and re acvtivate our current rule se...
4216 Jan 2010 @ 03:41 PSTDatabaseTopichow to search text like ' "suffer patron"%'Guys,need one help. I have value ("suffer patron") in one of the column.if i need to search the string as whole "suffer patron" how do i do that.regards
4116 Jan 2010 @ 03:22 PSTDatabaseReplyCollect stats on GTTHi ,Please note u can still collect stats on muticol of GTT but then these Multicol should be a part of PI only.when u create GTT it DDL is stored in dict tables hence i think stats for the columns...
4016 Jan 2010 @ 03:18 PSTDatabaseReplyPerformance Tuning - Report for analysisRAJA,when oracle can give you that then why not TEARDATA. :)well i dont know how gud is your understanding on teradata but then answer to your question:You can make use of DBQL,AMPUSAGE to understa...
3916 Jan 2010 @ 03:02 PSTDatabaseReplyIdle sessions blocking Production JobsNICK,I would suggest you to do one thing.. If you plan to query any table then Always make a practice of usingLocking table for accesssel .....fromtablename;Sql assistant has that option i doubt...
3816 Jan 2010 @ 02:51 PSTDatabaseReplyNUSI Vs. FTSDear TD aspirant,A FTS is an all amp scan where teradata scans the entire base table. When you create a NUSI teradata creates NUSI subtable and this would be created in each of the amp. Now what th...
3716 Jan 2010 @ 02:35 PSTDatabaseReplyHow to find blocksize of a able in teradata?Hi Vishwa,Blocksize in teradata is defined in terms of sectors in dbs control parameter.I think it is Permdballocation ( just refer to the dbs control portion in the doc). for example if u see the ...
3628 Nov 2009 @ 04:02 PSTDatabaseReplyHow to find the associated tables or view in teradata?Guys,lets understand Teradata is more user friendly since its more of GUI..i have worked on Oracle database before where most of it is command line.so wasy way in teradata to find would be log into...
3516 Nov 2009 @ 07:12 PSTDatabaseTopichow to abort rollbackGurusLets say thers a update happening to a billion + row table and all of a sudden because i see that wrong column has been updated i abort the he session and i see from schmon -m that rollback i...
3416 Nov 2009 @ 07:04 PSTDatabaseTopicSpool Space issueHello Guys,We recently upgraded from 6.2 to 12 version. One of the queries which was running well in 6.2 has hit out with spool space issue.As a first measure i have already collected stats . Stil...
3326 Jun 2009 @ 05:26 PDTDatabaseTopicTDWMGuru's without GUI how do I see what is the entire setting done via TDWM? actually I tried logging into prod node and as root I typed tdwmdmp –a…. its giving “no such…..”. how do I fin...
3223 Jun 2009 @ 02:24 PDTDatabaseTopicPEJust wanted to know if PE is a problem the from where should i collect the first hand info about PE and what in particlular should we look for?regardsTD_DBA
3122 Jun 2009 @ 08:12 PDTDatabaseTopicPuma -pGuru's,i execurted puma -p on my dev system and o/p is as follows:/var/adm # puma -pRproc Vproc Size PerProcp 0 16384 21248 0x9c3dc8 1 0 21248 0x9c4dd8 2 1 21248 0x9c5de8 ...
3019 Jun 2009 @ 05:58 PDTDatabaseTopicDBC.SOFTWARE_EVENT_LOGFolks,iam currently running V2R6.1 demo on my system. i have all my resource usage tables enabled. I wanted to try exec some of the systemfe macros. i started of with the macro allrestarts. when i ...
2918 Jun 2009 @ 09:13 PDTDatabaseTopicFLOAD Not initializingHi Guru's i recently came across this particular problem:Problem:======a developor started an informatica job which reads the source file and inserts the data into Target STG table using fastload. ...
2811 Jun 2009 @ 04:10 PDTToolsReplyInsufficient memory to parse request during Optimizer phase.ifact one of our developr faced the same error.it has got something to do with maxparsetreeseg. what is the current value that is set in your system? i suggest you ask ur dba to increase it to 400...
2711 Jun 2009 @ 04:05 PDTDatabaseTopicARCMAINGurus,The requirement is to forklift the whole database from Test machine to Dev machine.lets assume ther's a user Db called "XYZ" in test and it dosent exists in DEV machine.i want the user XYZ in...
2603 Jun 2009 @ 06:35 PDTDatabaseTopicQuery about Backupgurus,i have a spool reserve DB( no objects with in it) which is 3 TB in size. So when i use Arcmain to do all amp backup, will the spool reserve also come in?regardsTDDBA
2502 Jun 2009 @ 07:41 PDTDatabaseTopichow to backupguys,i need to see my whole TDWM settings and PSF settings from the command line. wha would be the command for it.how to backup TDWM, DBScontrol, XCTL and PSF settings.
2402 Jun 2009 @ 07:36 PDTDatabaseReplyQuery Neededthanks...
2301 Jun 2009 @ 07:39 PDTDatabaseTopicQuery NeededHi Gurus,as a part of Capacity Planningthe task is to : Write a couple of queries and pivot reports to identify the 10 largest tables and the 10 tables with the largest growth over last week. Devel...
2201 Jun 2009 @ 07:29 PDTDatabaseReplyTeradata I/O'sa logical I/O indicates that one of the table is in the memory . Most imp during a Product join always thersa duplication of either one of the table.to read the the rows of the table from the memor...
2125 May 2009 @ 12:25 PDTDatabaseReplyDATABASE BACKUPHi,yes first and foremost if u wanna a particular database to be restored on to a new Teradata Box normally people make use of GUI tool1. TARA GUI/Netbackup 2.Net vaultApart from this GUI's one can...
2015 May 2009 @ 01:04 PDTDatabaseReplyAdvantage of not Collecting the statsSubhash,if its a mid sized table then u got to collect stats completely . If its a BIG BIG EdW then for those tables in GB's( example 50 GB Table) which u think data has changed more than 10% its...
1914 May 2009 @ 08:37 PDTDatabaseReplyRegarding Performance issue while increasing the no of Concurrent usersHi ,Do you have Dynamic workload manager or TASM enabled.if it is then i think there might be some filter condition for concurrent sessions....which would put those queries in the delayed queue.wel...

Pages