#DateForumTypeThreadPost
1428 Apr 2016 @ 02:42 PDTDatabaseReplyTransient JournalTJ's Skew has consistenly been above 90+ There are no sessions which are highly skewed,  Please suggest on where to start ?
1326 Apr 2016 @ 06:25 PDTToolsReplyDSA logsHi, My job also got failed in the post script phase, Error code :3523 which is rights/permissions issue, but have given all rights to ARC user. Also in the mentioned path /var/opt/teradata/...
1224 Feb 2016 @ 12:11 PSTDatabaseReplyFind table size and last access date All, ObjectUseCountCollectRate is enabled(>0), Usecount is also enabled, but still i could find LastAccesstimestamp= null for few tables in a DB. I observed if a table is defined on a NOPI, th...
1124 Sep 2015 @ 12:23 PDTGeneralTopicMinimum space needed for a database during Online Archiving Hi All,   Our Backup failed due to "no room in database" error, The offending database had max perm of 54 mb,.. and current perm of 10mb.. My question how much minimum space is r...
1028 Jul 2015 @ 12:10 PDTViewpointReplyNot able to view SQL explain in Query monitorHi I have submitted an incident, Teradata says due to large/complicated queries running all the time(yes there are few SPs which runs 24*7) viewpoint is unable to fetch the info ..and was throwin...
915 Jul 2015 @ 11:21 PDTViewpointReplyNot able to view SQL explain in Query monitorTeradata 15.0
815 Jul 2015 @ 10:19 PDTViewpointReplySQL and Explain sometimes not visible in query monitorHi Gryback,Mahesh,Duri   I am facing this issue, can u let me know the if the above worked ?
715 Jul 2015 @ 06:14 PDTViewpointReplyNot able to view SQL explain in Query monitorHi Abhishek Yes in the set permissions option for query monitor, both 'VIew SQL' and 'View Explain' are checked.    
614 Jul 2015 @ 06:15 PDTViewpointReplyNot able to view SQL explain in Query monitorHi    Yes both Session Collector and SQL explain Collector  are enabled.
509 Jul 2015 @ 04:10 PDTViewpointTopicNot able to view SQL explain in Query monitorHi All In the Data collectors setup : Enable SQL Explain collector is checked, And i could see the error as below : Unable to collect SQL and Explain for session xxxx . SQL error code :3296 &nb...
403 Mar 2015 @ 09:48 PSTData ModelingReplyCalendar dimensionHi Raja   Can you mail me the design and scripts for creating calendar dimension table please @varanasianup@gmail.com Thanks in advance !
310 Feb 2015 @ 10:38 PSTDatabaseTopicFunctions in Join ConditionsHi All   SELECT  TRIM(UPPER(ABC.HELLO) as HELLO1 FROM ABC JOIN DEF HELLO1=DEF.HELLO   SELECT  ABC.HELLO FROM ABC JOIN DEF TRIM(UPPER...
219 Jan 2015 @ 10:16 PSTGeneralReplyReg : Performance of Coalease in Select StatementThanks Raja for responding !   Can you also explain how coalesce function works internally in teradata ? And also how it works for the above scenario i posted 
119 Jan 2015 @ 02:40 PSTGeneralTopicReg : Performance of Coalease in Select Statement Source: Present in Teradata ( Extract- replicate by golden gate from source to teradata). Worktable :Present in teradata(Captures all the DML operations done by goldengate on the source tabl...