Worked well, thank you all !!






"voorkey" <[Email address protected]
26/06/2006 04:21 PM

To
"Ness, Maxim @ CBRE Mgmt Svcs" <MAXIM.[Email address protected]
cc

Subject
Re: SQL0440N, problem listing Table Spaces






**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


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