The great Windows or Linux debate for DB2 LUW

04 May,2016 by Tom Collins

I manage large DB2 servers on Windows and Linux , so I’m confident both OS platforms can support installations with large data sets and high end throughput. But believing DB2 will perform exactly the same on both Windows and Linux  without some analysis is a recipe for problems.    There  are some considerations when planning switching or deciding between DB2 or Linux or Windows.

  1. Scriptability of DB2 on Linux versus Windows. If migrating from Linux – you may have a large shell script library which manage Linux and commit the flow control . There may be considerable work to adapt these scripts into a Windows supporting scripting language There are platform agnostic tactics – such as Perl DBI .On Windows you can use CMD (fairly limited), VBScript and Powershell. There is also the more exotic possibility of CLPPlus.

         Powershell has lots of cmdlets and is very powerful on the Windows platform. I use it for managing DB2 on Linux but only as a method to trigger and gather data from Linux servers. For example DB2 – How to pscp from the command line

         2.Historically DB2 on the Windows 32 bit was a headache – a fair degree of Windows trickery was required to extract. Since Windows 64 bit – life has become a lot easier for the DBA managing DB2 on Windows.

          3. Weigh up the full Total Cost of Ownership :

             - Backups  - Does the Enterprise backup platform support DB2 the same across both OS platforms? If you happen to be using TSM , than it's very well integrated into DB2 .

             - Monitoring

             - Active Directory Integration - There are plug ins on Linux but I've found AD and ADSI are easier to implement in Windows

            - Scheduling – Cron versus Winnows Scheduler versus other scheduler such as Autosys

            - Alerting via email or pagers

             - Different tuning configurables on Windows versus Linux . Linux and Windows are different OS software platforms. They both have specific configuration tuning considerations. Good quality Linux or Windows Administrators can assist greatly in architecting a reliable platform

Read More

Database Tuning – Five Basic Principles according to Shasha (DBA ...

Database Tuning overview – Hardware Tuning (DBA DB2)

Database Tuning overview –Storage Tuning (DBA DB2)

Author: Rambler(


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on The great Windows or Linux debate for DB2 LUW

Comments are moderated, and will not appear until the author has approved them. | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright