#DateForumTypeThreadPost
23608 Sep 2016 @ 12:05 PDTDatabaseReplyRules for Multi value compression 1. Is MVC allowed on primary index ? - No this is not possible.  2. Having MVC on too many columns will create problem ? - No, the more columns you have compression on, the more savings you...
23507 Sep 2016 @ 01:18 PDTDatabaseReplyFind blocking sessions and tablesThanks Abhishek, it works.
23407 Sep 2016 @ 08:38 PDTDatabaseReplyFind blocking sessions and tablesCould anyone please help me on this ? --samir
23306 Sep 2016 @ 03:52 PDTDatabaseReplyFind blocking sessions and tablesI see the values as blk3objdbid = 1 and blk3objtid = 102, screenshot attached    
23206 Sep 2016 @ 03:42 PDTDatabaseTopicFind blocking sessions and tablesHi, In our environment, we have an application that runs queries and they block each other for some tables. I want to know which all sessions and which all tables are in blocked state with that ID...
23125 Aug 2016 @ 11:09 PDTDatabaseReplyWhen to use Join Index Hi, Different JI has different use. If you have a table and you want to join to another table on some other column (than current PI), then you should create a Single table JI on the column you joi...
23030 Jun 2016 @ 03:26 PDTConnectivityTopicError while setting up proxy user using BO Hi,   I am working to set up a proxy user to connect from BO to teradata. I am able to test this using sql assistant. Basically, i am executing two commands :    1...
22917 Jun 2016 @ 11:58 PDTDatabaseReplyInteger to date conversionHi Dieter, Thanks, this converts the interger date to DATE. What are the figures, 0001-01-01 amd 307 ? Do i need to change it according to my environment ? --samir
22816 Jun 2016 @ 01:45 PDTDatabaseTopicInteger to date conversionHi, I have date in dbc.oldpasswords which is 735960 and 736051. I want to convert it to a date field so that i can read it. The format of this column is - integer format '_,__,__,_9'. I ha...
22715 Jun 2016 @ 02:12 PDTDatabaseReplyAlter table on huge tableHi, I never delved much deeper in Alter, as in our installation, we generally use drop recreate rather than alter. --samir
22615 Jun 2016 @ 02:10 PDTDatabaseReplyDegraded Query performance while performing insertionFew of the basic things that you need to see are : 1. Run : Diagnostic helpstats on for session 2. Run the explain of the query, See if optimizer suggests you some stats. Plese collect the stats ...
22514 Jun 2016 @ 03:28 PDTDatabaseReplyDegraded Query performance while performing insertionHi Is the select exeucting fast ? if true, then is the insert taking time ? This is a Insert sel query with no PI defined for the select part, so the first column will be the PI. If that is skewed...
22414 Jun 2016 @ 03:20 PDTDatabaseReplyAlter table on huge tableHi, Whenever we have such a big table to alter, we dont use ALTER stmnt. We just drop and recreate it. Since the PI of source and target is same, it will be a fast path insert and would be fast. I...
22308 Jun 2016 @ 03:21 PDTExtensibilityReplyOracle functions in TD 14Got it, thanks !! --Samir
22208 Jun 2016 @ 02:27 PDTExtensibilityReplyOracle functions in TD 14Hi Dieter, With reference to your post above, do you mean we should not be using functions like deode,nvl etc as they might not perform good ? also, i could not understand the difference bet...
22126 May 2016 @ 03:57 PDTDatabaseReplycumulative count by date This works:   sel temp.myyearmonth,temp.mycount,sum(mycount) over(order by myyearmonth) from  (sel (extract(year from exec_dt) || extract(month from exec_dt)) as myyearmont...
22025 May 2016 @ 04:00 PDTDatabaseReplyto divide the data usinng modulusHi Dieter, I was testing this function and created a table with varchar(3) column(Col1) and inserted 'A'. when i run this - sel Col1   from mytab  where to_number(col1) is n...
21925 May 2016 @ 03:26 PDTDatabaseReplyMultiple rows into Single rowThis should work INSERT INTO TABLE A SELECT DISTINCT('XYZ') FROM TABLE A WHERE COL1 = 'ABC' OR COL1='DEF' -Samir
21820 May 2016 @ 10:55 PDTDatabaseReplyHelp tables shows truncated column namesOk, got it. Thanks Todd and Dieter !!
21719 May 2016 @ 04:10 PDTDatabaseTopicHelp tables shows truncated column names Hi, Whan i do a help table db.tab, the column , columnname,  shows column names truncated to 30 characters. The column - column dictionary name, however shows full name. Why is this so ...
21612 May 2016 @ 01:02 PDTDatabaseReplyTeradata performing fine tuningSomething to take with your tasm if this systemwide performance issue ? Can you check which of your workloads are taking how much cpu and then can start from there ? I am not an expert in tasm, but...
21511 May 2016 @ 03:32 PDTDatabaseReplySecurity - DBADMIN vs individual DBA accounts - tracing accountabilityas Fred pointed out, we have different stored procedures to perform different admin functions 
21411 May 2016 @ 12:44 PDTDatabaseReplyRestrict access to grant implicit rightsHi All, Any inputs on this ? Thanks 
21311 May 2016 @ 09:06 PDTDatabaseReplySecurity - DBADMIN vs individual DBA accounts - tracing accountabilityHi Chris, Initially we had a sysadmin id and all the DBAs used that to all admin/install activities. But, we had tracebility issues, so we created individual DBA ids as you did. But, we dont have ...
21211 May 2016 @ 08:48 PDTDatabaseReplyGetting permission error while in role No, i dont think so. When i run Sel role or select currentRole  from dbc.sessionInfo where username=user, i get "All". This is what i am supposed to have. You can also run a set r...

Pages