db2wspm

Lynne Davis

db2wspm
Has anyone had any luck using the "Actual Costs" feature in Stored Procedure Builder?

We would like to use it but are getting the following error: SQL0440N no function by name 'DSNWSPM' having compatible arguments was found in the function path

We have created procedure DSNWSPM in our OS/390 development subsystem and have bound and activated it. We have granted execute on DSNWSPM to public and have granted execute on the plan and package to public.

thanks in advance for any advice,



Lynne Davis
Database Services
LL Bean, Inc.
(207) 552-2307
[login to unmask email]



Myron Miller

Re: db2wspm
(in response to Lynne Davis)
I've gotten it to work. But I didn't and still don't trust the "actual costs"
numbers produced so we don't use it at all. We tested it and that was as far
as we went with it.
--- Lynne Davis <[login to unmask email]> wrote:
> Has anyone had any luck using the "Actual Costs" feature in Stored Procedure
> Builder?
>
> We would like to use it but are getting the following error: SQL0440N no
> function by name 'DSNWSPM' having compatible arguments was found in the
> function path
>
> We have created procedure DSNWSPM in our OS/390 development subsystem and
> have bound and activated it. We have granted execute on DSNWSPM to public
> and have granted execute on the plan and package to public.
>
> thanks in advance for any advice,
>
>
>
> Lynne Davis
> Database Services
> LL Bean, Inc.
> (207) 552-2307
> [login to unmask email]
>
>
>
> http://listserv.ylassoc.com. The owners of the list can be reached at
[login to unmask email]


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com