Question & Answer
Question
How can I connect to DB2 LUW 11.1 and SQL Server 2016 using Optim 11.3?
Cause
DB2 LUW 11.1 and SQL Server 2016 are not currently supported out of the box by Optim.
Answer
To enable Toleration mode support for DB2 LUW 11.1 and SQL Server 2016 follow the steps below to set the special registry entry IgnoreDBMSVerCheck to D:
Windows:
- Close Optim
- Bring up the Optim Configuration Program.
- Hold down the Ctrl and Shift keys, and at the same time click on
File->Import Registry data. - You will see a 'Start Special Task' window, which will ask you for a
key. Type in 'optim'. - Scroll down to find the 'IgnoreDBMSVerCheck' key. Change the
value from '0' to 'D' (no quotes). - Click OK, and exit out of the 'Start Special Task' window, and out
of Configuration.
Linux/Unix:
Update the zap section of both pstserv.cfg and pstlocal.cfg with the following update:
# zap
#
# Zaps should be entered only on advice from IBM Technical Support.
#
# format is:
#
# zap zap-name zap-value
#
# Windows counterpart: Configuration Program
zap IgnoreDBMSVerCheck D
[{"Product":{"code":"SSMLQ4","label":"IBM InfoSphere Optim Test Data Management Solution"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
08 July 2021
UID
swg21994549