According to the V8.2 Information Center, you need execute on the db2expln,
db2exsrv and db2exdyn packages
to run the explain tools. Because those packages are not there! by those
names, we just bind the .bnd plans of those names under
$INSTHOME/sqllib/bnd, which seems to work. Watch out for the secondary
authentication 'feature' on the bind statement, you need to add the OWNER
keyword, e.g.

-- the db2expln program connects and uses the db2expln.bnd, db2exsrv.bnd,
and db2exdyn.bnd files
-- to bind itself to a database the first time the database is accessed.

bind /usr/opt/db2_08_01/bnd/db2exdyn.bnd insert buf blocking all grant
public owner db2inst1;
bind /usr/opt/db2_08_01/bnd/db2exfmt.bnd insert buf blocking all grant
public owner db2inst1;
bind /usr/opt/db2_08_01/bnd/db2expln.bnd insert buf blocking all grant
public owner db2inst1;
bind /usr/opt/db2_08_01/bnd/db2exsrv.bnd insert buf blocking all grant
public owner db2inst1;

Regards
Alex Levy
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x74407161.[Email address protected]
Sent: 27 May 2005 12:59
To: LazyDBA Discussion
Subject: Re: can ' not grant execute to db2expln to users






Go to the directory with the db2expln.bnd file (sqllib/bnd)

and do a db2bfd -b db2expln.bnd and look at the package name
NULLID.SQLNAE01.

(or something like that )







"ighiurea "

<db2udbdba-ezmlms

hield-x47930307.x
To
[Email Address Removed] "LazyDBA Discussion"

a.com> <[Email address
protected]

cc
05/26/2005 02:59

PM
Subject
can ' not grant execute
to db2expln
to users

















Hi,
I'm trying to grant execute to db2expln , db2exsrv and db2 exdyn to
regular user.
I can run tis packes no problme, but when I do:
db2 grant execute to package db2expln to user usera , get the message
"nullid.db2expln" is undefined name ....I try
db2inst1.db2expln same thing
!
I checked syscat.packages table , but db2expln is not there , only
db2advis & db2look ...BUT I can run db2expln no problem .
I'm using DB2 UDB V8.2.6



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



******************************************************
The information in this E-mail and in any attachment is
confidential and is intended solely for the addressee.
Access, copying, disclosure or use of such information
by anyone else is unauthorised. If you are not the
intended recipient please contact [Email address protected]
While reasonable efforts are made to ensure these files are free
of virus infection and offensive materials, if something of this
nature is inadvertently sent to you, please destroy it, accept
our apologies and contact [Email address protected] with
details of the sender. We will ensure that action is taken
immediately to prevent any recurrence. Debenhams accept no
responsibility for any views expressed by the originator of this email.


Debenhams Retail plc (reg. no. 83395) Registered in England and Wales.
Registered office: 1 Welbeck Street, London W1G 0AA.

http://www.debenhams.com

******************************************************


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