#DateForumTypeThreadPost
5622 Nov 2015 @ 09:01 PSTDatabaseReplyQuery concurrency data available in Metrics heatmap through DBQL dataHi Experts ,   I have come up with the query for query concurrency from DBQLLOGTBL_HST   LOCKING ROW FOR ACCESS SELECT cast(starttime as date), EXTRACT( HOUR FROM A.STARTTIME), ...
5521 Nov 2015 @ 10:13 PSTDatabaseReplyQuery concurrency data available in Metrics heatmap through DBQL dataHi ,   Kindly do help me in this regard if we can retrieve the query concurrency details from the DBQL instead of Viewpoint metrics heatmap.   regards Subramanian kaushik Gurumoorthy
5421 Nov 2015 @ 11:59 PSTDatabaseTopicQuery concurrency data available in Metrics heatmap through DBQL dataHi all,   I found that we have a portlet called "Metrics Heatmap" which presents the "Query concurrency" for a teradata system. Kindly do inform if there is any query to...
5326 Sep 2015 @ 10:44 PDTDatabaseReplyAlphabetical order Hi Satya   I dont think we have any pre built functions,we need to write a specific processing logic with the use of array data type or you can loop split and capture each letter to a colum...
5226 Sep 2015 @ 10:32 PDTDatabaseReplyResponseTimeMet in DBQLHi Kishore,   The above macro executes the below sql in background , have a check SELECT WDId (TITLE 'Workload//Definition//ID',FORMAT 'ZZZ9'), Completions (TIT...
5126 Sep 2015 @ 10:20 PDTDatabaseReplyHow to Calculate the total IO used by System for a particular weekHi Dnoeth/all,   I tried executing the below within resusagespma table and the IO is not matching with the values in viewpoint. SELECT THEDATE AS RUNDATE, CAST(CAST(CAST(THETIME AS FORMA...
5026 Sep 2015 @ 08:59 PDTDatabaseReplyResponseTimeMet in DBQLHi Kishore   Do login to primary node of Teradata and run option 2 DIPDEM. Which would create the requested objects in SYSLIB.    
4926 Sep 2015 @ 02:26 PDTViewpointReplyAbort sessions in responding phaseRecently I faced an issue of aborting the query through viewpoint 14.0 where there was a bug. The better way to do it is through PM/API or CNSTERM   Give session no within the below code &...
4826 Sep 2015 @ 02:19 PDTDatabaseReplyHow can we find the row size for columnar table?Hi HarshaKudumula There is a rougfh way of doing the same by calculating the ideal size of a row from the datatypes mentioned within DBC.COLUMNS
4726 Sep 2015 @ 02:16 PDTDatabaseReplySQL for Blocking SessionsHi Srinivas   We can find the blocking sessions by using SYSLIB functions as below   SEL USERNAME , SESSIONNO , HOSTID , IDENTIFYUSER(BLK1USERID) , BLK1SESSNO ...
4626 Sep 2015 @ 02:13 PDTDatabaseReplycatalog object DBCHi Salemelk   Kindly do refer to the below links regarding the way to get teh access count   http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/SQL_Reference/B035_1142_112A/ch02.135.2...
4526 Sep 2015 @ 01:57 PDTDatabaseReplyChecking Table Access Rights for Users Connected via LDAPHi p2mcdon1   All the users are recorded within DBC.USERS If you want to understand what are the role asssigned you can use DBC.Rolemembers   All the access rights for a role is...
4426 Sep 2015 @ 01:50 PDTDatabaseReplyResponseTimeMet in DBQLHi Kishore,   If you have the workload management implemented , if you have the SLA set up there you can find the same using the below procedure   exec syslib.WDSlg
4326 Sep 2015 @ 01:44 PDTDatabaseReplyIdentification of data that is not being used/Cold data using DBQL or other approachHi    To find thetable last access timestamp combine tablesize with tables, solution provided alrady by Dieter and Adarsh   https://forums.teradata.com/forum/database/tracking...
4226 Sep 2015 @ 01:33 PDTDatabaseReplyHow to optimize queries that have aggregation involving multiple fact tablesHi Sieger   Kindly do provide the conditons on all the three tables , can you alsio post the original query along with explain plan    
4126 Sep 2015 @ 01:28 PDTDatabaseReplySql to delete duplicates in TeradataHi   Why cant we create a SET table and insert the values within it. Which would automatically discard all the duplicate values
4026 Sep 2015 @ 01:25 PDTDatabaseReplyFind the list of active running queries through SQLHi Abhishek,   Thanks for your quick response,it is possible to combine both the queries together, as  MonitorSQLText        is allowing only constant values to be ...
3926 Sep 2015 @ 01:21 PDTDatabaseReplyAlphabetical order Hi SatyaY,   Can we more understnd on what you are trying to achieve , so would be able to help you ?  
3825 Sep 2015 @ 09:19 PDTDatabaseReplyFind the list of active running queries through SQLHi All,   Revisiting on my request. Thanks to Dieter to help me to get the list of active sessions.   SELECT * FROM TABLE (MonitorSession(-1,'*',0)) dt;   I want to ...
3725 Sep 2015 @ 08:51 PDTDatabaseReplyHow can I restore a database from .mdf file?Hi Jason,   I think .MDF is a MS access file, do you want to import the data from MS ACCESS to Teradata    
3625 Sep 2015 @ 03:57 PDTViewpointReplyHealth alerts - Any query to find the same without viewpointHi,   Anyone would be able to direct me on the above post. Thanks in advance    
3525 Sep 2015 @ 02:16 PDTViewpointTopicHealth alerts - Any query to find the same without viewpointHi all,   I am using Teradata 14.0 with viewpoint at the same version, Want to understand if we can query and retrieve the health alerts provided by viewpoint through data dictionary. &nbs...
3424 Sep 2015 @ 11:01 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi Fred ,   Thanks a lot for your response. Let me check with it , I suppose that the above fix is for SQLAw which connects through ODBC. Can we know if it applies for BTEQ too ?   ...
3323 Sep 2015 @ 04:20 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi    I could find the same working finde with  SELECT 'aaa'||cast(current_time as char(8)) But with the below query having the 5407 error. SELECT 'aaa'||cas...
3223 Sep 2015 @ 04:07 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi Dieter,   Thanks for your response. I have tried it now but it gives me the error "Invalid operation for Date time or interval"   SELECT 'aaa'||cast(A.RUNTIME ...

Pages