Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Unanswered: How to eliminitate the call goes to IBM stored procedure DSNAPCOL?

    I have my application written in Visual basic and calling DB2 stored procedures through ODBC connection. We came to know through our DBA that Metadata IBM stored procedure DSNAPCOL (returns stored procedure parameters to program) is now being invoked and consumes more CPU.

    We made the changes in ini file to set DESCRIBEPARAM=0. But that does not help us to eliminate the call goes to DSNAPCOL.

    Can anyone help me?

    -Uma Kathir

  2. #2
    Join Date
    Dec 2009
    Hello, I have the same problem since I have migrated from DB2 V7 to V8.
    I am searching the solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts