470,625 Members | 2,021 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,625 developers. It's quick & easy.

db2look privileges?

Hi, I executed the following db2look statement but got an 'Execute'
privilege error.
What privileges do I need to execute the 'db2look' utility?

/home# db2look -d dbname -e -o sql.txt
-- No userid was specified, db2look tries to use Environment variable
USER
-- USER is: SAPSAS
-- Creating DDL for table(s)
-- Output is sent to file: sql.txt
--An error has occured during Binding

Error Message =
SQL0551N "SAPSAS" does not have the privilege to perform operation
"EXECUTE" on object "NULLID.DB2LOOK ". SQLSTATE=42501
SQLCA
Size = 136
SQLCODE = -551
Tokens = SAPSAS ■ EXECUTE ■ NULLID.DB2LOOK
RDS fn = SQLRAEAC
RC = 0x8012006D = -2146303891
Reason = 0x0000 = 0
Reason2 = 0x0000 = 0
Warning flags =

Cheers,
San.

May 22 '06 #1
2 11626
San,

Try to rebind the db2look utility as dba. When binding you can control
access to such utilities; you can grant 'execute' to user, group or
public.

cd ~/sqllib/bnd
db2 connect to yourdb user db2admin
db2 bind db2look.bnd blocking all grant public
db2 bind db2lkfun.bnd blocking all grant public

PS. If you receive such errors you can search for related 'bnd' files
in the ../bnd directory and bind them with desired grants.
-- Artur Wronski

May 22 '06 #2
hi,

Think you have to specify user name and password to get the DDl

db2look -d databasename -e -z schemaname -i username -w password
-m -o db2look.sql

raInDeeR

May 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by dbtoo_dbtoo | last post: by
6 posts views Thread by Lennart Jonsson | last post: by
1 post views Thread by Lyn Duong | last post: by
1 post views Thread by db2group88 | last post: by
8 posts views Thread by db2sysc | last post: by
1 post views Thread by Gregor Kova─Ź | last post: by
2 posts views Thread by Justin | last post: by
1 post views Thread by blaisestephen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.