Thursday, April 14, 2005
Checking IBM DB2 Connect's Version Number
Preface: I work in the Windows world.
Checking the version number on an installed DB2 Connect seems like it would be a really easy task. Pull up the HELP screen in any of the programs that ship with IBM DB2 Connect and "Voila!" you have your version number.
Doesn't work that way. We get the primary version number on the HELP screens (e.g. 7, 8, etc.) but we don't get the full version number (e.g. 7.01.00.40) which is what we want when we are trying to duplicate our development environment here at work. IBM Db2 Connect is upgraded about twice a day so keeping accurate track of the version numbers is very important. We get a shipment of disks about every other month with a new version number (Version 7.01.00.03 becomes Version 7.01.00.04).
To get the full version number you must go to the Windows Control Panel on an XP box and pull up Administrative Tools. Then click on the Data Sources (ODBC) shortcut. This will pull up the ODBC Data Source Administrator and you can go to the Drivers tab and scroll until you find the IBM DB2 ODBC Driver. Here you can view the Version in its entirety. You can then match this Version number with the Version number on the mountain of disks you have from IBM.
