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.

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

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