Fixes are available
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
Closed as program error.
An OLE DB application using the IBMDADB2 provider on a Windows 64-bit platform may receive a CLI0100E - "Wrong Number of Parameters" errors if executing a statement with parameter markers. . This problem will happen despite the fact that the application properly bound a parameter marker to the statement. . Note: ----- This APAR does *not* fix this problem. A new APAR has been opened - APAR# IC65800, and should contain the final solution. The estimated target is v9.5 FP6.
Use either an ODBC datasource, or either the ODBC.NET or DB2.NET data provider if running a .NET application. This problem will not happen in a 32-bit environment. . The db2cli.ini keyword DEFERREDPREPARE=0 will also workaround the problem, but may cause a slight performance degradation. For stored procedure calls, local fix would be - DESCRIBECALL=1 inside db2cli.ini file.
Users Affected: DB2 OLE DB users running on Windows 64-bit Problem Description: OLE DB applications receiving CLI0100E errors on Windows 64-bit platforms.
First fixed in DB2 UDB Version 9.5, Fixpak 5
see LOCAL FIX
Reported component name
DB2 CUE WINDOWS
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
IC61965 IC61966 IC61967
Fixed component name
DB2 CUE WINDOWS
Fixed component ID
Applicable component levels
24 March 2010