Maxim,
Hopefully you have also updated the instance using "db2iupt" after applying fixpak 10 and as listed underneath some of the fuctionalities in v8.2 fixpak 3 will not work without running db2updv8. Its a good to run db2updv8 after db2iupt with the fixpak installation as it gets the system catalogs and functions to the current level. Correction below v8.1 fixpak 7 is equivalent to version 8.2.

voorkey

-------------- Original message --------------
From: "voorkey" <db2udbdba-ezmlmshield-x84346476.[Email address protected]

> 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" >
> > 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
> >
>
>
> ---------------------------------------------------------------------
> 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