HIS 2010 DB2 Providers return errors when trying to connect to IBM DB2 for z/OS V7

  • Article

If you are using HIS 2010 and want to communicate with IBM DB2 for z/OS V7, you might encounter the following issues.

1) The sample query in the Data Access Tool (DAT) or Data Source Wizard (DSW) fails with the following error:

An internal network library error has occurred. The requested command included a parameter that is not recognized or is not supported by the target system. SQLSTATE: HY000, SQLCODE: –344

The same error occurs when using the BizTalk Adapter for DB2 in the Send Port configuration when trying to list the columns for an updategram.

The SQLSTATE: HY000, SQLCODE: –344 error indicates the following:

DB2 has detected an error while parsing a DDM command received from a local DB2. An instance variable, defined by DDM Level 3 as not valid for this command, has been received as a command parameter.

The error occurs when using the DB2 Adapter included with HIS 2010 because a new DDM code point was added that DB2 for z/OS V7 does not support. The new DDM code point is:

Query Instance Identifier (QRYINSID): This DDM code point was added to the DRDA V3 protocol to add a better mechanism to uniquely identify a query.

IBM added support for the QRYINSID DDM codepoint in IBM DB2 for z/OS V8.

This problem does not occur with the DB2 providers in HIS 2009 because they do not include support for this DDM code point.

2) The following error occurs when trying to create packages from the BizTalk 2010 Add Generated Items wizard:

An internal network library error has occurred. The requested command included a parameter value that is not recognized or is not supported by the target system. SQLSTATE: HY000, SQLCODE: –385

The SQLSTATE: HY000, SQLCODE: –385 error occurs when trying to create DB2 packages using the DB2 Adapter in HIS 2010 against DB2 for z/OS V7.

This error occurs in HIS 2010 because new DDM code points were added to the Create Package process within the DB2 Providers. For example, we added code points to keep prepared statements over commits, so that we could support OpenRowset with FastLoad for SSIS OLE DB Destinations.

IBM DB2 for z/OS V7 did not support these new DDM code points.

As with the first scenario, this problem does not occur with the DB2 providers in HIS 2009.
-----------------------------------------------------------------

HIS 2010 is supported with the following IBM DB2 versions":

Host System                                                                     Product and Version

Relational Database Management Systems                IBM DB2 for z/OS V8.1 and DB2 for z/OS V9.1

                                                                              IBM DB2 for i5/OS V5R4 and V6R1

                                                                                           IBM DB2 for Windows, AIX, HP-UX, Solaris, Linux
                                                                                           V9.1, V9.5, V9.7

The supported versions of IBM DB2 are based on the versions that IBM supports when a version of Host Integration Server is released. These are the DB2 versions supported when HIS 2010 was released.