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.
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.