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.
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
CONTROL privilege on the table
My other question is "Is there a built stored procedure for deleting data from a table without logging".