14 | 28 Apr 2016 @ 02:42 PDT | Database | Reply | Transient Journal | TJ's Skew has consistenly been above 90+
There are no sessions which are highly skewed,
Please suggest on where to start ?
|
13 | 26 Apr 2016 @ 06:25 PDT | Tools | Reply | DSA logs | Hi,
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/... |
12 | 24 Feb 2016 @ 12:11 PST | Database | Reply | Find 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... |
11 | 24 Sep 2015 @ 12:23 PDT | General | Topic | Minimum 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... |
10 | 28 Jul 2015 @ 12:10 PDT | Viewpoint | Reply | Not able to view SQL explain in Query monitor | Hi 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... |
9 | 15 Jul 2015 @ 11:21 PDT | Viewpoint | Reply | Not able to view SQL explain in Query monitor | Teradata 15.0
|
8 | 15 Jul 2015 @ 10:19 PDT | Viewpoint | Reply | SQL and Explain sometimes not visible in query monitor | Hi Gryback,Mahesh,Duri
I am facing this issue, can u let me know the if the above worked ?
|
7 | 15 Jul 2015 @ 06:14 PDT | Viewpoint | Reply | Not able to view SQL explain in Query monitor | Hi Abhishek
Yes in the set permissions option for query monitor, both 'VIew SQL' and 'View Explain' are checked.
|
6 | 14 Jul 2015 @ 06:15 PDT | Viewpoint | Reply | Not able to view SQL explain in Query monitor | Hi
Yes both
Session Collector and SQL explain Collector are enabled.
|
5 | 09 Jul 2015 @ 04:10 PDT | Viewpoint | Topic | Not able to view SQL explain in Query monitor | Hi 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... |
4 | 03 Mar 2015 @ 09:48 PST | Data Modeling | Reply | Calendar dimension | Hi Raja
Can you mail me the design and scripts for creating calendar dimension table please @varanasianup@gmail.com
Thanks in advance !
|
3 | 10 Feb 2015 @ 10:38 PST | Database | Topic | Functions in Join Conditions | Hi All
SELECT
TRIM(UPPER(ABC.HELLO) as HELLO1
FROM ABC
JOIN DEF
HELLO1=DEF.HELLO
SELECT
ABC.HELLO
FROM ABC
JOIN DEF
TRIM(UPPER... |
2 | 19 Jan 2015 @ 10:16 PST | General | Reply | Reg : Performance of Coalease in Select Statement | Thanks 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
|
1 | 19 Jan 2015 @ 02:40 PST | General | Topic | Reg : 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... |