Difference between DB2 and DB6

My daily work requires me to monitor and analyze various customer SAP landscapes and make recommendations so as to improve the performance of their system. This means I have to focus on both, the application server and the database server along with the operating system that is used.

On several occasions, I have come across landscapes running IBMs DB2 database. But when analyzing from within SAP, the database shows up sometimes as DB2 or DB4 or DB6. This is a confusing situation and there is little(in fact none that I could find) documentation for this on the SAP side of things. As expected, IBM talks only in terms of DB2. After searching a bit online, I came across an excellent post which clarifies things. It also talks about the serious repercussions of not making sure whether you are running DB2 or DB6! I urge you to go through it.

I quote:

IBM uses the name DB2 for their product. But on the SAP side, the name actually changes depending on the operating system platform.

  • DB2 – Mainframe
  • DB4 – iSeries
  • DB6 – Linux / Unix / Windows

This affects how you perform search queries for solutions, which OSS notes to apply, and how parameters are set. If you get this wrong once, you might find yourself hunting for a needle in a haystack. And yes, I’m saying that from experience.

I would be interested in knowing why SAP started a virtual fragmentation of DB2 database. From my humble experience too, it is a pain to figure out the right parameter settings for the DB2/4/6 database using an OSS Note search.

Comments

14 comments on “Difference between DB2 and DB6”
  1. Baerbel says:

    Just happened upon this and found a saved version of the page via wayback machine: http://web.archive.org/web/20121217000158/http://sapdb2workbench.blogetery.com/2010/11/08/difference-between-db2-and-db6/ . Not sure what happened to the website itself, so links from the archived page might no longer properly work.

  2. Kilian says:

    A late reply, but the reason for the distinction of DB2, DB4 and DB6 is, that these are three totally different databases which (I guess) share no common code, understand a totally different SQL syntax and have a very different feature set. The difference between two DB2’s in ony domain may be larger than between DB6 and, say, Oracle.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s