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?
This topic has been locked.
1 reply Latest Post - 2009-09-27T10:53:12Z by Sawan
Pinned topic How to eliminitate the call goes to IBM stored procedure DSNAPCOL?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-09-27T10:53:12Z at 2009-09-27T10:53:12Z by Sawan
Sawan 270000UTQ856 PostsACCEPTED ANSWER
Re: How to eliminitate the call goes to IBM stored procedure DSNAPCOL?2009-09-27T10:53:12Z in response to umakathirHi Uma
Could you please try setting the parameter in the connection string or set DB2CLINIPATH environment variable to the correct db2cli.ini location.
I suspect if the ini is being read or not. Otherwise you would have received CLI0150E when SQLDescribeParam was called.