New Microsoft OLE DB Provider for DB2 error messages

This article describes the new Microsoft OLE DB Provider for DB2 error messages that are not documented in the Microsoft Host Integration Server 2004 documentation.

Error messages that are new to Host Integration Server 2004

The following HY000 (transport layer) error messages are new to Host Integration Server 2004:

�	1000 Explanation: The user does not have the authority to access the host resource. Action: Check your authentication credentials, or contact the system administrator.
�	1001 Explanation: The user does not have the authority to access the host resource. The password has expired. Action: Manually log on to the host resource, and change the password to prevent this error.
�	1002 Explanation: The new authentication credentials are not valid. Action: Check your authentication credentials, or contact the system administrator.
�	1003 Explanation: Password change management (PCM) is not supported by the remote system. Action: Stop using PCM, or contact the system administrator for help.
�	1004 Explanation: The authentication method that is used is not supported by the remote system. Action: Configure the IBM DB2 database for the correct security option. OLE DB Provider for DB2 that is included with Host Integration Server 2004 and with Microsoft SQL Server 2005 currently requires SERVER security. The DB2 database may be configured for CLIENT security, for KERBEROS security, or for DATA_ENCRYPT security. These security options are not supported.
�	1500 Explanation: The maximum number of statements (128) has been reached for the current connection. Action: Limit the number of concurrent SQL statements to less than 128. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 891520 FIX: OLE DB Provider for DB2 incorrectly returns the "SQLSTATE 58003, SQLCODE -144" error message when an application tries to open more than 128 SQL statements at the same time in Host Integration Server 2004
�	1501 Explanation: The user account does not have permission to create the necessary DB2 packages that are used to execute queries. Action: Use the Data Access Tool and an account that has the required permissions to create the packages.

Error messages that are new to OLE DB Provider for DB2 that is included with SQL Server 2005

The following HY000 (transport layer) error messages are new to OLE DB Provider for DB2 that is included with SQL Server 2005:

�	1100 Explanation: OLE DB Provider for DB2 only supports TCP/IP, not Advanced Program-to-Program Communications (APPC). Action: Reconfigure the universal data link (UDL) properties for TCP/IP instead of APPC.
�	1101 Explanation: Distributed unit of work (DUW) is not supported. Action: Reconfigure the UDL properties for remote unit of work (RUW).

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.