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?
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 Posts
Re: How to eliminitate the call goes to IBM stored procedure DSNAPCOL?2009-09-27T10:53:12ZThis is the accepted answer. This is the accepted answer.Hi 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.