question about explicit access rights
Hi All
What I want oto know
Iam intrested to know all the explicit access rights on a given table covering individual and role privileges.
Say for eg - UserA and RoleA have insert rights on Table1.
Then what should I query to get the resultset showing UserA and RoleA with their access.
W...
by Karam
17 hours 11 min ago
|
20 views
|
3 replies,
from 1 hour ago
|
TDWM configuration data - purging practices
Is TDWM configuration data e.g. WlcDefs, RuleDefs, SysCons etc. ever purged?
I've noticed that whenever some modification is made in TDWM the old configuration data is kept in the table with the field RemoveDate, RemoveTime.
Is this data purged after some configured duration? or is it a common ...
by monisiqbal
1 day 14 hours ago
|
28 views
|
0 replies
|
Problems with SP compilation
I have problems to compile any sp with Teradata 13 Express and VS Express 2008 sp1. Compilation of a trivial procedure
Replace procedure RETAIL.sp_T()
begin
declare job char(12);
end;
fails with *** Failure 5547 Internal Error: Can not find mt.exe
The routine exists in Windows S...
by jvycpalek@csob.cz
1 week 3 days ago
|
153 views
|
4 replies,
from 2 days ago
|
Column usage history
Hi Friends
In order to understand PI choice , one criteria is to know the frequency of column access in joins and in WHERE clause.
Iam looking out for a script which can give a historical column usage for a table, i.e. for ex. in last 1 month how many times a particular column is used in join...
by Karam
2 weeks 13 hours ago
|
71 views
|
1 reply,
from 1 week ago
|
how to abort session without PEMON or TDManager ?
Dear All
Have the other ways to aborts session ?
How do I abort session by sql syntax?
,i really wanna know -*-
Br,
mnstr
by mnstr
3 weeks 1 day ago
|
126 views
|
2 replies,
from 2 weeks ago
|
Where is the documentation?
Hello Everyone,
I downloaded the teradata 13 VPC. I start teradata server and it started successfully.
Now I want to read and try out the new product, but I don't see any documentation on the VPC.
Can you please tell me where should I start reading up? I have many years of experience on ...
by abhishes
3 weeks 20 hours ago
|
95 views
|
1 reply,
from 3 weeks ago
|
Skew issue
Hi Friends...
CT dbname.tablename as sel * from dbname1.tablename1 with data;
tablename1 is 70 gb ,and dbname has 110 available space. Query retuned with spool space error, during MERGE step of EXPLAIN.
I have checked row distrubution of source table using HASH function query and found th...
by Karam
3 weeks 4 days ago
|
133 views
|
5 replies,
from 3 weeks ago
|
Possible values representing 'types' of 'ExceptionValue' column in DBQLogTbl
For TDWM, DBQLogTbl has a column 'ExceptionValue' which is documented in Teradata 13 as:
"Specifies what type of Teradata DWM exception occurred."
While in Teradata 12, it is documented as:
"Specifies what type of Teradata DWM exception occurred. The value
indicates that one of the foll...
by monisiqbal
3 weeks 3 days ago
|
67 views
|
2 replies,
from 3 weeks ago
|
Allowing access on DBC tables/view. How risky it is?
Hi Friends
I wanted to know ,wheather DBC tables/views should be accessable to all the DB users ?
What are the risks of exposing the DBC objects to ALL users? What can be a alternative if any?
by Karam
5 weeks 11 hours ago
|
203 views
|
6 replies,
from 3 weeks ago
|
select * from database_name.table_name
Hi ,
I am able to access tables only with the database_name.table_name .
select * from database_name.table_name ;
not able to access table directly .
But online examples , I have seen table names direclty using .Is there a way.
Can I create synonymns??
Regards.
by tutika_shilpa@yahoo.com
6 weeks 4 days ago
|
175 views
|
3 replies,
from 4 weeks ago
|
Thoughts on CPUBusy caclulations.
A few people in our organization are slightly disbelieving of the CPU utilisation charts I produce, they always focus on the CPU utilization charts, as if it is the only metric to be interested in.(But thats a different post)
We use Linux based TD nodes, and I use the DBC.ResUsagespma table to...
by Random_Thought
16 weeks 3 days ago
|
544 views
|
17 replies,
from 5 weeks ago
|
DBQLObjTbl
Hi,
I've enabled all DBQLogTbl, DBQLSQLTbl, DBQLObjTbl, DBQLStepTbl and data is being logged into all the tables but only not in DBQLObjTbl.
Any idea?
We have databases created within DBC which we access like A.Table and querying against this table also doesn't log anything in DBQLObjTbl.
...
by monisiqbal
7 weeks 4 days ago
|
86 views
|
2 replies,
from 6 weeks ago
|
DBQLSQLTbl's logging time
DBQLSQLTbl works in conjunction with DBQLogTbl and logs SQL Text, however the CollectTimeStamp field in this table does not relate to the CollectTimeStamp field in DBQLogTbl nor the FirstRespTime and StartTime in this table.
Most probably DBQLSQL has it's own buffer and data is logged when the...
by monisiqbal
12 weeks 4 days ago
|
208 views
|
5 replies,
from 6 weeks ago
|
Volitile and Global Temp Tables and the Transient Journal
Is transient journal overhead incurred on inserts/updates/deletes on volitile and global temp tables.? Thanks in advance.
by jonesj2
7 weeks 2 days ago
|
161 views
|
3 replies,
from 7 weeks ago
|
Stats collection frequency
Is there an ideal frequency at which stats should be collected? Or is it on a case by case basis where in if needed, daily stats collection should also be done?
Inputs appreciated.
Thanks,
ShyGuy
by shyguy
11 weeks 1 day ago
|
140 views
|
3 replies,
from 7 weeks ago
|
Invalid session mode for procedure execution
Am facing this error- 'Invalid session mode for procedure execution' while calling a proc through Java/JDBC. I am guessing that this error has something to do with the db layer.
Solution/Fix?
by shyguy
8 weeks 1 day ago
|
179 views
|
2 replies,
from 8 weeks ago
|
SQL doesn't work - syntax or teradata issue?
Hi,
I have a query that was suggested to me on an ANSI-SQL forum. When I tried it in Teradata (V2R5 or R6) it didn't run. The error I received was "3706: Syntax error: Expected something between '(' and the 'SELECT' keyword." I can't find any problem with the syntax so I was wondering if there...
by kbtrumptmp
8 weeks 1 day ago
|
422 views
|
2 replies,
from 8 weeks ago
|
Tricky grouping question
Hi,
I have a dataset similar to the following:
Patient_ID Unit Start_Time End_time
1234 3C 5/2/09 12:00 5/5/09 13:00
1234 3FE 5/5/09 13:00 5/5/09 14:00
1234 3FE 5/5/09 14:00 5/7/09 18:00
1234 ICU 5/7/09 18:00 5/1...
by kbtrumptmp
12 weeks 4 days ago
|
271 views
|
5 replies,
from 8 weeks ago
|
TASM issues
Hi,
Query on TASM. If we configure a group to have a MAXIMUM CPU utilisation of 60 Seconds, we would expect the query to migrate over to the next group when it reaches 60 Seconds.
Why then do we see queries running and consuming more than 60 seconds (sometimes up to 1 hours worth of CPUTIM...
by Random_Thought
8 weeks 5 days ago
|
106 views
|
1 reply,
from 8 weeks ago
|
ERROR IN AMP
Hello my friends,
I'm having problems in my bteq when I try to insert data into a table. happens the error below:
** Failure 2642 AMP Down: the request can not TB_PESSOA against nonfallback
be done.
What should I do to solve this problem?
Thank´s for helping me
by gsvalino
9 weeks 13 hours ago
|
138 views
|
2 replies,
from 8 weeks ago
|
Sql to delete duplicates in Teradata
Hi ,
Is there a single SQL statement to delete duplicate records from a table in Teradata.
Note , I don't want to use any intermediate table , like inserting into an intermediate set table.
Thanks in Advance.
by Naveen_K
15 weeks 7 hours ago
|
627 views
|
5 replies,
from 9 weeks ago
|
Lock Info
Hi,
Is there any SQL which wil fetch information like which table is lock, what kind of lock is there is on table and which user is locking the table.
I do ve DBA priviledge. I know this can be seen thru Teradata Manager but i am looking an SQL to find this info.
Please help with your ex...
by Manish Jain
16 weeks 21 hours ago
|
283 views
|
2 replies,
from 10 weeks ago
|
"2642: Amp Down. The Request against nonfallback CONTRACT cannot be done"
Hello all, I'm completely new to Teradata, coming in from a developer's background. I installed Teradata 12 express recently and opened Teradata Administrator, expanded the Samples Database and tried to Browse the CONTRACT table, which generated the message in the subject line.
Does this indi...
by tscoccol
11 weeks 8 hours ago
|
201 views
|
2 replies,
from 10 weeks ago
|
Subquery Issue
Hello Friends
Can anybody educate on the proper subquery functionality.I have a subquery which goes into Product Join in Explain plan.
I have remodelled it and there is no more Product join on it..but want to double sure if the logic is same.Also I wolud like to know the reason for Product Jo...
by Karam
12 weeks 2 days ago
|
345 views
|
3 replies,
from 11 weeks ago
|
Macros vs Stored Procedures
We currently have multiple macros being used via one transaction call that potentially makes it dead lock prone. Would it be better to convert those macros into 1 SP?
On these lines, any advantages that SPs have over Macros or vice versa appreciated.
Thanks,
ShyGuy
by shyguy
12 weeks 1 day ago
|
308 views
|
3 replies,
from 11 weeks ago
|
