| 16 | 29 May 2015 @ 06:55 PDT | Database | Reply | Logonrules | we would like to see the logons information(granted/revoked) for all users. is there is any way we can get it?
|
| 15 | 29 May 2015 @ 03:28 PDT | Database | Topic | Logonrules | logonrules table is not showing logon details for all users. how can we identify whether logons are enabled/not for the other users.
|
| 14 | 28 May 2015 @ 08:02 PDT | Database | Reply | Connect Through Privilege | Thanks srini..
|
| 13 | 28 May 2015 @ 06:05 PDT | Database | Topic | Connect Through Privilege | How to list the users who have connect through privileges. any DBC table stores this information.
|
| 12 | 23 May 2015 @ 10:24 PDT | Database | Reply | VIEW CREATION QUERY | LOCKING ROW FOR ACCESS is not required for the second table.
if you can check the explain for SEL * FROM VDDVD.PRODUCT you can observe that access lock is placed on the table hence ano... |
| 11 | 19 May 2015 @ 08:56 PDT | Tools | Reply | Join on Non indexed columns | based on primary index we will identify the location of row in the disk. whenever we join two tables then join will be performed in spool based on PI column. if non PI column was choosed for join t... |
| 10 | 19 May 2015 @ 08:41 PDT | Database | Topic | Spool Space | What is the use of spool space for a database
|
| 9 | 19 May 2015 @ 07:34 PDT | Database | Reply | Does a volatile table remove duplicated rows? | if SET/MULTISET was not specified then by default
Multiset will be considered if it is ANSI mode
Set will be considered if it is Teradata mode.
CREATE VOLATILE TABLE "anil".tblname(a... |
| 8 | 28 Apr 2015 @ 08:47 PDT | General | Reply | AWT: Amp Worker Tasks used by Utilities | can any one clearly explain how each awt will be used in different phases for these utilities.
|
| 7 | 24 Apr 2015 @ 07:17 PDT | Database | Reply | wrong timestamp displayed | use the below query to convert the time to your own timezone
SELECT TO_TIMESTAMP ('03/26/2015 04:00:32', 'MM/dd/YYYY hh:MI:SS' ) AT TIME ZONE 'gmt+6' ;
|
| 6 | 14 Apr 2015 @ 11:19 PDT | Viewpoint | Topic | CPU Utilization | Some times we will see that CPU utilization was more than 99%. How this percent was decided and when its value become 100%.
|
| 5 | 14 Apr 2015 @ 11:14 PDT | Viewpoint | Topic | Impact CPU | Actual value of impact CPU and its value displayed in Viewpoint are always different. is there is any way to find out the actual value from viewpoint.
|
| 4 | 14 Apr 2015 @ 10:53 PDT | UDA | Reply | Teradata Express bteq logon issue |
Rathod,
Error code 2 occurs only if
1.we are not included the login statement in the script
2.submitting a request after logoff statement
it seems second cr... |
| 3 | 14 Apr 2015 @ 12:10 PDT | Database | Reply | Performance and view-on-view approach | usually end users will have only select access. if select access is provided on final table then there is a chance that end user access the table directly, it places read lock on the table, ex... |
| 2 | 31 Mar 2015 @ 10:13 PDT | Data Modeling | Reply | Deleting | Dan,
if duplicate ID is allowed then you can use RANDOM() function with BIGINT range.
CREATE VOLATILE TABLE tbl_name
( Adt_id BIGINT,time_stamp timestamp(6)) PRIMARY INDEX (adt_id) ON COMMI... |
| 1 | 21 Mar 2015 @ 01:46 PDT | Database | Reply | Access blocking for connection users | login to viewpoint as a admin user. then you can create filter for restricting perticular IP address
|