IBM Support

JR32605: OLEDB DRIVER RETURNS CLI0100E ON WINDOWS 64-BIT PLATFORM

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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.
    

Local fix

  • 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.
    

Problem summary

  • Users Affected:  DB2 OLE DB users running on Windows 64-bit
    Problem Description:  OLE DB applications receiving CLI0100E
     errors on Windows 64-bit platforms.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, Fixpak 5
    

Temporary fix

  • see LOCAL FIX
    

Comments

APAR Information

  • APAR number

    JR32605

  • Reported component name

    DB2 CUE WINDOWS

  • Reported component ID

    5724B6201

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-03

  • Closed date

    2009-12-21

  • Last modified date

    2010-03-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC61965 IC61966 IC61967

Fix information

  • Fixed component name

    DB2 CUE WINDOWS

  • Fixed component ID

    5724B6201

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021