tag:blogger.com,1999:blog-1347137045980388492.post7244449391038466656..comments2023-05-21T03:07:57.328-07:00Comments on db2 performance: 10 Things to have in DB2: which shall improve performance..Sameerhttp://www.blogger.com/profile/04380280581835257131noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1347137045980388492.post-39570478678224724682012-01-25T22:58:00.345-08:002012-01-25T22:58:00.345-08:00Why third party? Can't IBM provide the same as...Why third party? Can't IBM provide the same as a single bundle the way Microsoft does? Every time for each tool you need to individually pay IBM? Also I don't see Optim having all the functionalities at one place. It's always purchase 10 different tools for 10 different uses and with the memory usage for these tools any administrator's pc would surely die.<br />IBM, just a note "get started with more user friendly tools"Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1347137045980388492.post-89016112032151963552011-12-22T09:19:00.043-08:002011-12-22T09:19:00.043-08:00Well I do not agree completely... I agree Control ...Well I do not agree completely... I agree Control Center is not that good a tool but I do not think Optim is that bad... And well you can pay a visit to dbi Software http://www.dbisoftware.com/ for some Awesome third party tools...Sameerhttps://www.blogger.com/profile/04380280581835257131noreply@blogger.comtag:blogger.com,1999:blog-1347137045980388492.post-4932885512027692942011-12-22T06:18:39.171-08:002011-12-22T06:18:39.171-08:00I don't think DB2 is a pain. I think IBM is a ...I don't think DB2 is a pain. I think IBM is a pain. DB2 is a great database engine, extremely stable and feature rich. However, IBM does not market is well. They concentrate on bringing out different version levels. Many third party vendors don't support DB2 9.5 + . While Microsoft is brining SQL Server cheaper, IBM is raising the DB2 license cost. SQL Server comes with SSIS/SSRS/SSAS, but DB2 doesn't even come with a decent tool. Please don't say Control Center and the free optim is a tool !Rajuhttp://techsatwork.comnoreply@blogger.comtag:blogger.com,1999:blog-1347137045980388492.post-73659975381485990962011-10-27T20:32:34.473-07:002011-10-27T20:32:34.473-07:00Well it is just a matter of perspective... If you ...Well it is just a matter of perspective... If you have come from a Oracle world, you might find it so... I guess we can jott down 10 equally important points which should be there in SQLServer/Oracle but not there... Every product has its own history and own features, comparing two will be unfair towards people involved in development... What's good is db2 is going best to catchup with dev and dba requirements...Sameerhttps://www.blogger.com/profile/04380280581835257131noreply@blogger.comtag:blogger.com,1999:blog-1347137045980388492.post-24934764907764068252011-10-27T01:24:30.748-07:002011-10-27T01:24:30.748-07:00i do agree that using DB2 is a paini do agree that using DB2 is a painAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1347137045980388492.post-54559672043778608512011-09-14T10:18:52.794-07:002011-09-14T10:18:52.794-07:001) Agree... But adds an extra overhead of referesi...1) Agree... But adds an extra overhead of referesing MQT... MDC is quite interesting and would like to explore more on this..<br /><br />2) I have recently used oracle hierarchical and db2 recursive queries... I had to write a lot of correlated subqueries to ensure there is no cyclic relation which ends up in an infinite loop... Where as with oracle it was as simple as to use a NO CYCLE clause... As the record counts were not very huge so I could not compare much on performance, but there was a little dip when I used recursive query compared to hierarchical query... I also confirmed this trial on an Oracle 11g db which supports both...<br /><br />3) :)<br />4) :)<br />5) I meant the query optimizer (or may be preprocessor/compiler) should identify a range based on a row_number clause and accordingly append an OPTIMIZE for N rows to it before generating a plan... I will still write like <br /><br />select col1, col2 from (select col1, col2, row_number() over(order by idpk_column) rn from dummy_tab) temp where rn between 1 and 10 <br /><br />where as query fired will be:<br /><br />select col1, col2 from (select col1, col2, row_number() over(order by idpk_column) rn from dummy_tab) temp where rn between 1 and 10 OPTIMIZE for 10 ROWSSameerhttps://www.blogger.com/profile/04380280581835257131noreply@blogger.comtag:blogger.com,1999:blog-1347137045980388492.post-40503663636186491862011-09-13T20:29:06.053-07:002011-09-13T20:29:06.053-07:001) You could use an MQT or MDC
2) Don't unders...1) You could use an MQT or MDC<br />2) Don't understand the difference. Oracle hierarchical query is just an earlier, non-standard way to do same as recursive query. DB2 UDB has always supported the recursive SQL (ANSI) standard.<br />3) Agreed.<br />4) Reorg is required after a drop column rather than all alterations; agree this would be nice if could be avoided.<br />5) ORDER BY DESC FETCH FIRST 10 ROWS ONLY - select top 10 clause would *not* be nice, since it is non-standard SQL. You started this article by saying porting is a pain... adherence to standards by Microsoft etc. would help.<br /><br />Run out of time, but the locking was an interesting point...Anonymousnoreply@blogger.com