 | |
#11
 
| |||
| |||
|
Re: DB2 on Non-Windows OS -
08-06-2012
, 09:40 AM
|
simon4rum (AT) gmail (DOT) com writes: Hi All: I've been working with DB2 on Windows for 6 years now and I think i get tired of it due to a number of reasons. I often hear other non-Windows DB2 DBAs talking about how solid DB2 is in other environments (Linux, AIX, etc.). I would appreciate if some of you could make recommendations, share your experiences (good/bad), and guide me to a reliable platform so I could start experimenting with it, with a possibility of moving off from the Windows platform. I'll play devil's advocate here. What issues are you having with DB2 on Windows? When properly configured, I've had very good luck with it - even in scenarios using Microsoft Cluster or even (gasp) DPF. I've found that it's often a better platform choice for customers who have a lot of Windows admin experience and little Linux / AIX admin experience. One of the biggest advantages is that when the Windows server is part of an Active Directory environment it makes managing users a LOT easier. (I know that you can do this on Linux/AIX, but if you've ever spent time integrating Linux or AIX + DB2 into Active Directory you'll know what I mean). --- Posted via news://freenews.netfront.net/ - Complaints to news (AT) netfront (DOT) net --- |
I've had a whole different kinds of issues, most of them I can live with, but for some, I'm always bothered with. One issue is the HADR setup and maintenance. Since DB2 9.7, setting up HADR isn't a straight forward process anymore, there are always tricks and twists to do to get it working. And thenin each fix pak, there are issues with HADR, it's caused the instances to crash, or to hold up the transactions. Fix paks seem fixing those issues, but usually cause different issues, etc.
Another thing to mention is the tools used to administer DB2. The CC doesn't seem to work when I need to resolve an issue (but it works sometimes whenI don't need it). I guess that's why the CC is going away. And IBM Data Studio isn't that easy to use yet. So, I guess some of you would suggest to stick with DB2 CLP
So it's a bit frustrated and that makes me wanted to try something new to see how different other platforms are...
Saying that, I still prefer to stay with Windows for different of reasons, one of those are as you mentioned previously. Also, you sounded like you have DB2 running on Microsoft Cluster Services. Would you be kind enought to show me your tricks? I have SQL Server running on two-node cluster and I pretty like it. It works like a charm!
Simon
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.