#DateForumTypeThreadPost
704 Apr 2016 @ 06:33 PDTDatabaseReplyConvert MINUS query to OUTER JOINThanks Dieter, both Tables are having different PIs. I checked the performance of both queries and see that outer join query taking less CPU with around 2B rows.   Other than that, I added...
627 Mar 2016 @ 08:27 PDTDatabaseReplyConvert MINUS query to OUTER JOINHey insac, Thank you very much for the help! this is working as expected :)
525 Mar 2016 @ 09:38 PDTDatabaseTopicConvert MINUS query to OUTER JOINHi, I have a requirement to avoid exclusion join for a query using MINUS set operator. Query is something like this: sel t1.col1,t1.col2 from t1 MINUS sel t2.col1,t2.col2 from t2; In this ca...
422 Mar 2016 @ 10:26 PDTConnectivityReplyProblem with Reconnect using .NET and ODBC driversOnce aborted a .NET session (via viewpoint or DBS restart), SQLA does not ask for connection information again when I try to execute another qurey from same window. It just reconnect another sessio...
330 Jul 2015 @ 11:31 PDTViewpointReplySession CPU,IO SkewHow Heatmap portlet calcultes AMPCPUSkew and AMPIOSkew ? I would like to get similar information from Resusage table. I could figure out that viewpoint is fetching data from ResusageSVPR, but coul...
225 Jan 2015 @ 07:20 PSTViewpointTopicCan we restrict/filter sessions based on session mode ?Hi, Is there any way to restrict ANSI sessions using viewpoint/TASM ? I don't want to allow ANSI sessions into system. How can I achieve this via viewpoint or TASM or any other method ? Kin...
114 Sep 2014 @ 06:50 PDTViewpointReplyAlerting from ViewpointHi, We have setup SNMP trap alerts but wanted to know what message is being sent to linux server. Is there any place where viewpoint stores messages being sent ? I understand that we can see the...