473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DB2 UDB or Oracle (who's got better support)

Hi,
I almost read all of the "DB2 vs Oracle" thread...
The summary I got from that was all databases essentially do the same
things, the decision of which one you use primarily depends on available
skillsets, software vendor support, and customer/tech support.

I will be facing a decision on migrating our SAP Informix database to
either Oracle, DB2UDB, or Sqlserver. I don't think we are going to
SqlServer. I have some Oracle experience, I have no DB2 or DB2UDB
experience, I have lots of Informix experience.

What I would like to have discussed in this thread is the support and
quality of support available for DB2UDB (we would run on Sun) and Oracle.

The quality of the Informix support I have gotten through the years,
whether calling Lenexa(informix), SAP, or IBM has been outstanding.

In my short time with Oracle, the support does not match Informix.
Doesn't even come close. I do not know if perhaps I am just not hooked in
to the right support channels, or that's really all there is. (I use
Metalink and rarely have talked to a live Oracle support person).

I know nothing of the quality of DB2 UDB support.

I am aware the SAP & IBM recently tightened their relationship on the
DB2/DB2UDB side as informix will be fading out (as an SAP platform).
Oracle bought PeopleSoft and there are articles about oracle aiming for
some of SAP's business. Does that make IBM the database vendor of choice
for SAP?

I don't want to haggle about technical details of features/functionality
between IBM's DB2 UDB versus Oracle...

I want to hear about the non-technical, the touchy-feely human side of
support. When I am stuck between a rock and a hard place, I want to pick
up the phone and get help, i don't want the run-around.

Please enlighten me on the quality of DB2 UDB support, the frequency of
database patches needed, the frequency of maintenance outages (DBA
housekeeping and what housekeeping items are needed).
Same goes for Oracle...

I feel my bottom line decision will not be based on features/functionality,
but rather on quality of support.

thank you for your input,
Norma Jean

--
Message posted via http://www.dbmonster.com
Nov 12 '05 #1
5 3276
"NormaJean Sebastian via DBMonster.com" <fo***@DBMonster.com> wrote in
message news:9b******************************@DBMonster.co m...
Hi,
I almost read all of the "DB2 vs Oracle" thread...
The summary I got from that was all databases essentially do the same
things, the decision of which one you use primarily depends on available
skillsets, software vendor support, and customer/tech support.

I will be facing a decision on migrating our SAP Informix database to
either Oracle, DB2UDB, or Sqlserver. I don't think we are going to
SqlServer. I have some Oracle experience, I have no DB2 or DB2UDB
experience, I have lots of Informix experience.

What I would like to have discussed in this thread is the support and
quality of support available for DB2UDB (we would run on Sun) and Oracle.

The quality of the Informix support I have gotten through the years,
whether calling Lenexa(informix), SAP, or IBM has been outstanding.

In my short time with Oracle, the support does not match Informix.
Doesn't even come close. I do not know if perhaps I am just not hooked in
to the right support channels, or that's really all there is. (I use
Metalink and rarely have talked to a live Oracle support person).

I know nothing of the quality of DB2 UDB support.

I am aware the SAP & IBM recently tightened their relationship on the
DB2/DB2UDB side as informix will be fading out (as an SAP platform).
Oracle bought PeopleSoft and there are articles about oracle aiming for
some of SAP's business. Does that make IBM the database vendor of choice
for SAP?

I don't want to haggle about technical details of features/functionality
between IBM's DB2 UDB versus Oracle...

I want to hear about the non-technical, the touchy-feely human side of
support. When I am stuck between a rock and a hard place, I want to pick
up the phone and get help, i don't want the run-around.

Please enlighten me on the quality of DB2 UDB support, the frequency of
database patches needed, the frequency of maintenance outages (DBA
housekeeping and what housekeeping items are needed).
Same goes for Oracle...

I feel my bottom line decision will not be based on features/functionality, but rather on quality of support.

thank you for your input,
Norma Jean

--

I think you are asking two separate questions.

1. DB2 support in general
2. SAP support of DB2

I think most would agree that DB2 support is currently at least as good as
Informix, and probably better if you are comparing Informix support after it
was bought by IBM (I don't know about before they were bought by IBM). I
have always found DB2 support to be excellent. But you may want to check to
make sure you know what kind of DB2 support contract you will be have.

Besides the fact that Oracle is a direct competitor with SAP in application
software, IBM is one of the largest (if not the largest) customers of SAP.
But I don't think that there would be any problem using Oracle with SAP,
anymore than there would be a problem using DB2 on SUN hardware.

I believe that there are only certain DB2 releases/fixpaks that you can use
with SAP, since SAP wants to thoroughly test their software with a specific
release/fixpak. In some cases, there may even be special DB2 releases that
must be used with SAP (this has happened in the past). I would contact SAP
for details on this, and also regarding required/suggested DB2 maintenance
procedures, that will depend on which release of DB2 is being used and also
depend on the application requirements (the benefits of a reorg, etc on a
specific table may be application dependent).

But in general, backups, reorgs, runstats, etc can be done on-line in DB2
version 8, while users have write access to the database.

Nov 12 '05 #2
NormaJean Sebastian via DBMonster.com wrote:
Hi,
I almost read all of the "DB2 vs Oracle" thread...
The summary I got from that was all databases essentially do the same
things, the decision of which one you use primarily depends on available
skillsets, software vendor support, and customer/tech support.

I will be facing a decision on migrating our SAP Informix database to
either Oracle, DB2UDB, or Sqlserver. I don't think we are going to
SqlServer. I have some Oracle experience, I have no DB2 or DB2UDB
experience, I have lots of Informix experience. "Will" can be a fair bit out. Don't let yourself be artificially pressured.
What I would like to have discussed in this thread is the support and
quality of support available for DB2UDB (we would run on Sun) and Oracle.

The quality of the Informix support I have gotten through the years,
whether calling Lenexa(informix), SAP, or IBM has been outstanding. Good to hear. IBM recognized Informix track record in support and the
overall DB2 IM support organization is run by the Informix exec.
In the last years a lot of cross-training has happened.
So when calling in for DB2 for LUW support you may well end up in Lenexa
talking to the same people you do now.
There are actually metrics where vendors are compared in service. Maybe
google turns something up...
In my short time with Oracle, the support does not match Informix.
Doesn't even come close. I do not know if perhaps I am just not hooked in
to the right support channels, or that's really all there is. (I use
Metalink and rarely have talked to a live Oracle support person).

I know nothing of the quality of DB2 UDB support.
I am aware the SAP & IBM recently tightened their relationship on the
DB2/DB2UDB side as informix will be fading out (as an SAP platform).
Oracle bought PeopleSoft and there are articles about oracle aiming for
some of SAP's business. Does that make IBM the database vendor of choice
for SAP? IBM is the preferred vendor for Linux and Unix platforms.
On Windows the message is less clear.
But you are correct that the Peoplesoft acquisition certainly has added
a renewed focus. You will see the first fruits of that very soon.
I don't want to haggle about technical details of features/functionality
between IBM's DB2 UDB versus Oracle...

I want to hear about the non-technical, the touchy-feely human side of
support. When I am stuck between a rock and a hard place, I want to pick
up the phone and get help, i don't want the run-around.

Please enlighten me on the quality of DB2 UDB support, the frequency of
database patches needed, the frequency of maintenance outages (DBA
housekeeping and what housekeeping items are needed).
Same goes for Oracle... DB2 ships more or less regular "Fixpacks" every 3 months.
Being on the receiving end of defects I can't comment on how many
patches teh average customer needs.. but that's why you post here :-)
I feel my bottom line decision will not be based on features/functionality,
but rather on quality of support. Wise.
thank you for your input,
Norma Jean


Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:38*************@individual.net...
DB2 ships more or less regular "Fixpacks" every 3 months.
Being on the receiving end of defects I can't comment on how many
patches teh average customer needs.. but that's why you post here :-)

Serge Rielau


Usually, SAP only certifies certain release/fixpak combinations, so DB2
upgrades are that often if you use SAP. Depends on which release of SAP one
is using, but obviously they stay behind the curve a little bit to avoid
surprises.
Nov 12 '05 #4
"Mark A" <no****@nowhere.com> wrote in message
news:Xb********************@comcast.com...
Usually, SAP only certifies certain release/fixpak combinations, so DB2
upgrades are that often if you use SAP. Depends on which release of SAP one is using, but obviously they stay behind the curve a little bit to avoid
surprises.

Correction:

Usually, SAP only certifies certain release/fixpak combinations, so DB2
upgrades are NOT that often if you use SAP.
Nov 12 '05 #5
Norma Jean,
I have DBAs working for me who support all four of the major databases
(Oracle, Sybase, MSSQL, UDB) on open systems, plus M/F. No Informix.

Both Oracle and UDB have really strong on-line support networks. You
open a critical problem, you get a call back. Both are very similar.
Sybase too, but I use it less frequently.

We have Aliance support with Sybase, so we go to a specific person
with all our problems, or his backup ot manager. In a local office. I
can't really talk about MSSQL support, I'm not on the coverage letters,
so I have to go through an interal person who is.
I recently dealt with critical system outage problems in Oracle and
UDB. We had issues getting Oracle to escalate to the duty manager to
get a level two person onto the problem. It was our communications
failure in the TAR, not using the correct words. IBM seemed to get us
to level two (that was the call back person for out ticket) more
quickly when we put the PMR in as a SEV1. No wording issues. With IBM
we can get to level three people too. I have never seen that happen
with Oracle. But it might be that we have a bigger relationship with
IBM than we have with Oracle.
Patches come out way to frequently. We are behind before we start,
with all of the DBMSes. Try patching 30 Oracle or 50 UDB instances.
Just the application testing alone can take a patch cycle. You never
catch up. Just doing the Security ones is hard.
All three, Sybase, Oracle, UDB, have issues with fixing problems when
they are difficult. Wait for the next EBF, they say. In reality you don't
want special builds either, but you do want the vendors to commit to
fixing a bug in the version you are on (91) rather than wait for the next
version (10g). Their fix lists are impossible to understand. Lots of
words, but you never know if your problem is fixed unless you can reproduce
it and test it. I have generally waited longer for Sybase and Oracle to
fix something than UDB. Most stuff in UDB gets turned around to the
next or the follow on fixpack (depends on the fix pack generation cycle).
Sybase fixes it in one spot but not others, Oracle says to wait for a new
version and then in stealth mode fixes it at the next point release.

NV> Please enlighten me on the quality of DB2 UDB support, the frequency of
NV> database patches needed, the frequency of maintenance outages (DBA
NV> housekeeping and what housekeeping items are needed).
NV> Same goes for Oracle...

NV> I feel my bottom line decision will not be based on features/functionality,
NV> but rather on quality of support.

Edward Lipson via Relaynet.org Moondog
ed***********@moondog.com el*****@bankofny.com
---
þ MM 1.1 #0361 þ
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: michael newport | last post by:
Oracle opens arms to Mozilla By Stephen Shankland and Alorie Gilbert, CNET News.com Oracle wants its applications to integrate better with Mozilla's open-source desktop software Oracle is...
10
by: michael newport | last post by:
Dear friends of database(s), After 13 years of Ingres, I am now using Oracle. But is Oracle technically better than Ingres. I would be much obliged if anyone could shed some light on the...
63
by: Nick Palmer | last post by:
Hi all, Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two DB2 databases and I need to get access to the tables in one from the other. In Oracle I would just create a DB...
11
by: Mark A | last post by:
Here is Mark Townsend's (Oracle Product Manager) explanation and justification for posting in the DB2 newsgroup, as posted on the Oracle newsgroup, and my response: "Mark Townsend"...
10
by: Andrea M. Segovia | last post by:
Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access...
13
by: BigDaDDY | last post by:
Um yeah....In case you haven't figured it out, Microsoft sucks. I'm going to be kicked back in my chair eating popcorn and watching football 10 years from now, while all you clowns are scrambling...
22
by: Rob R. Ainscough | last post by:
Sorry to hear about the job cuts and Oracle now out sourcing to India. Rob.
56
by: Ashish Patankar | last post by:
I want to migrate my Oracle 10g database to Db2. I want some documentation for the comparision between these to databases. I also want to know which features of Oracle 10g are supported by Db2 and...
5
by: jonceramic | last post by:
Hi All, I started developing in Access, and people took notice and so we're starting to migrate into our corporate's bigger Oracle system. I'll still be using my developed Access front ends,...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.