Maxim,
Version 8.1 fixpak 6a is equivalent to 8.2. Did you already execute db2updv8 as part of your migration. If not, force all apps off db2, deactivate database and issue "db2updv8 -d databasename". Activate the database and see if it fixes your issue. This command updates the system catalogs to support all changes made in fixpak 6a. Pretty sure this will fix your problem.

Voorkey

-------------- Original message --------------
From: "Maxim" <db2udbdba-ezmlmshield-x53498490.[Email address protected]

> Dear DBA's,
>
> Recently i have upgraded our development server from DB2 UDB 8.1 fixpak 6a
> to fixpak 10. As a part of upgrade i had to install fixpaks 7b and
> 7q(special fixpak from PeopleSoft), Windows 2000 server
>
> now i have a problem with listing tablespaces. I am getting following:
>
> [IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named
> "SNAP_GET_TBSP" of type "FUNCTION" having compatible arguments
> was found. SQLSTATE=42884
>
>
> Thank you !
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

DB2 & UDB email list listserv db2-l LazyDBA home page