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.