Host Integration Server (HIS) DB2OLEDB Errors
This article was produced by the HIS product team prior to updating the documentation. Let us know if you have any feedback.
The Microsoft OLE DB Provider for DB2 (Data Provider) returns two types of errors in the form of SQLSTATE and SQLCODE formatted error strings, which administrators and developers can use to troubleshoot issues. The Data Provider returns DB2 server error strings in the form of standard SQLSTATE with SQLCODE as part of the OLE DB IErrorInfo interface that the SQL Server consumer returns to the end user. You can research the description of the DB2 server error, based on the SQLSTATE and SQLCODE, in the IBM DB2 Messages and Codes reference for the applicable DB2 platform and version.
The Data Provider returns provider-specific and DRDA protocol error strings in the form of standard SQLSTATE HY000 and 08S01with SQLCODE as part of the OLE DB IErrorInfo interface that the SQL Server consumer returns to the end user. Administrators and developers can research the description of the DRDA protocol error, based on the SQLCODE error string, in the Distributed Relational Database Architecture (DRDA) protocol documentation. This is published as an industry standard through Open Group (http://www.opengroup.org/). You can download DRDA V4 Vol. 3: Distributed Data Management Architecture, publication number C068, published 26 April 2007, from http://www.opengroup.org/bookstore/catalog/c068.htm.
This article contains the following sections:
· Host Integration Server (HIS) Features and Errors
http://social.technet.microsoft.com/wiki/contents/articles/host-integration-server-his-features-and-errors.aspx
· Distributed Data Management (DDM) Protocol Errors
http://social.technet.microsoft.com/wiki/contents/articles/distributed-data-management-ddm-protocol-errors.aspx
· Distributed Relational Database Architecture (DRDA) Protocol Errors
http://social.technet.microsoft.com/wiki/contents/articles/distributed-relational-database-architecture-drda-protocol-errors.aspx
· Record-Level Input/Output (RLIO) Protocol Errors
http://social.technet.microsoft.com/wiki/contents/articles/record-level-input-output-rlio-protocol-errors.aspx
· Data Queues (DTAQ) Protocol Errors
http://social.technet.microsoft.com/wiki/contents/articles/data-queues-dtaq-protocol-errors.aspx
· SNA Network Errors
http://social.technet.microsoft.com/wiki/contents/articles/sna-network-errors.aspx
· TCPIP Network Client Errors
http://social.technet.microsoft.com/wiki/contents/articles/tcpip-network-client-errors.aspx
· Sign-On Errors
http://social.technet.microsoft.com/wiki/contents/articles/sign-on-errors.aspx
· ** ** Transaction Errors
http://social.technet.microsoft.com/wiki/contents/articles/transaction-errors.aspx