Skip to content

Questions on Data Server Manager and Db2 Edition?

Data Server Manager or DSM has come a long way and is now the tool of choice for many companies for managing Db2. I get a lot of questions on how to get it and what Db2 editions are supported. Check out Peter Kohlman’s info here and you should find what you need. https://community.ibm.com/community/user/hybriddatamanagement/blogs/peter-kohlmann/2018/08/29/using-dsm-with-bundled-copies-of-db2?CommunityKey=e0967b49-f3c2-42c0-9cca-a415e3896fb3&Tab=

Db2 Version and OS Requirements

I have lots of clients running Db2 on Windows Server 2008 R2… End of Service for Windows 2008 R2 is 1/14/2020. Db2 11.1 and above requires Windows 2012 Standard Edition or above so if you are running a Db2 10.5 on Windows Server 2008 R2 you should be making plans to upgrade to Db2 11.1 and Windows Servers 2012 Standard Edition or preferably Windows Servers 2016 Standard Edition.. Get the details for all of this at the below links:

Db2 — http://www-01.ibm.com/support/docview.wss?uid=swg27038033#1111Work

Windows — https://www.microsoft.com/en-us/cloud-platform/windows-server-2008

Mid-Atlantic Db2 User Group May 7, 2019

Don’t miss Dale McInnis’s presentation on the Db2 logger and update from Dr. John Lind on Vnext!

Register today: https://conta.cc/2UAGYWa
9am-10:30 SESSION 1
Futures (vNext coming soon!) presented by Jon Lind

10:30-1045 BREAK

10:45-12:00 SESSION 2
IBM Streams presented by Roger Rea

12-12:45 – Networking Lunch

12:45-2:00 SESSION 3
Demystifying the Db2 Logger presented by Dale McInnis

2:00- 2:15 BREAK

2:15-2:30 IDUG Overview

Db2 11.1 Mod 4 Fix Pack 4

This fix pack was released on 27 Nov 2018 so it isn’t new but it has some enhancements worth moving to and exploiting. Reads on standby has been improved via reduction in replay window thru a the new  variable DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW.  The DB2_USE_ASYNC_FOR_MIRRORLOG variable can be used to improve mirror logpath performance by enabling log writing in parallel to the active and mirror log path.  The performance of online backups can be improved by using the new DB2_REDUCE_FLUSHING_DURING_BACKUP registry variable by reducing the amount of changed pages that have to be flushed from the bufferpool at online backup startup.

There are a bunch more of improvements, get all the details here: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.wn.doc/doc/c0061179.html#c0061179__MP4FP4

Db2 Continuing Support

I get a lot of questions regarding whether or not a clients Db2 version is supported or other questions on extending support. IBM announced the Db2 continuing support program quite some time ago. For a refresher, go to this page https://www-01.ibm.com/support/docview.wss?uid=swg22002945

Need more info on Db2 Backup?

If you set the DB2_BAR_STATS registry variable to ON additional info will be provided in the db2diag.log. You also get the size so you can track backup size. Nice little Redbook  on this and backup performance at http://www.redbooks.ibm.com/abstracts/tips1344.html?Open

Db2 JDBC Drivers and Versions

I get asked for this information all the time so I thought I would share the link with all of you….

http://www-01.ibm.com/support/docview.wss?uid=swg21363866