Hi,

I would like to know if an application guy can run the stored procedure for runstats on his own schema and tables.Will he be able to run the SP if he has been granted CONTROL privilege on all the tables in his schema.I wanted to try this method so that he does not have to contact the DBA for a runstats on the tables.Is there also a SP for the runstats.

Thanks
Venky.

I have found the solution for this post. I just found the procedure CALL SYSPROC.ADMIN_CMD('runstats on table db2user.employee on key columns and indexes all') and it requires the application people to have any of the following authorizations :
sysadm
sysctrl
sysmaint
dbadm
CONTROL privilege on the table
LOAD authority

My other question is "Is there a built stored procedure for deleting data from a table without logging".

Thanks
Venky

Not one that I'm aware of ..

If the user has CONTROL priivelages on the table, you can create a stored stored procedure with the following stmts, which thay can use ;

alter table table1 activate not logged initially with empty table
commit