#DateForumTypeThreadPost
1629 May 2015 @ 06:55 PDTDatabaseReplyLogonruleswe would like to see the logons information(granted/revoked) for all users. is there is any way we can get it?
1529 May 2015 @ 03:28 PDTDatabaseTopicLogonruleslogonrules table is not showing logon details for all users. how can we identify whether logons are enabled/not for the other users. 
1428 May 2015 @ 08:02 PDTDatabaseReplyConnect Through PrivilegeThanks srini..
1328 May 2015 @ 06:05 PDTDatabaseTopicConnect Through PrivilegeHow to list the users who have connect through privileges. any DBC table stores this information. 
1223 May 2015 @ 10:24 PDTDatabaseReplyVIEW CREATION QUERYLOCKING 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...
1119 May 2015 @ 08:56 PDTToolsReplyJoin 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...
1019 May 2015 @ 08:41 PDTDatabaseTopicSpool SpaceWhat is the use of spool space for a database
919 May 2015 @ 07:34 PDTDatabaseReplyDoes 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...
828 Apr 2015 @ 08:47 PDTGeneralReplyAWT: Amp Worker Tasks used by Utilitiescan any one clearly explain how each awt will be used in different phases for these utilities.
724 Apr 2015 @ 07:17 PDTDatabaseReplywrong timestamp displayeduse 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' ;  
614 Apr 2015 @ 11:19 PDTViewpointTopicCPU UtilizationSome times we will see that CPU utilization was more than 99%. How this percent was decided and when its value become 100%.
514 Apr 2015 @ 11:14 PDTViewpointTopicImpact CPUActual 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.  
414 Apr 2015 @ 10:53 PDTUDAReplyTeradata 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...
314 Apr 2015 @ 12:10 PDTDatabaseReplyPerformance and view-on-view approachusually 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...
231 Mar 2015 @ 10:13 PDTData ModelingReplyDeleting 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...
121 Mar 2015 @ 01:46 PDTDatabaseReplyAccess blocking for connection userslogin to viewpoint as a admin user. then you can create filter for restricting perticular IP address