Eugene,

Have you considered doing this via Unix shell scripts and just
granting execute access to those users?

Chet

eugene@profitlogic.com (Eugene) wrote in message news:<9573e6b2.0408171056.5721565a@posting.google. com>...
> In a multi-database development (DB2V8.1.4/AIX) environment I want to
> enable regular non-DBA database users (i.e. developers) to execute
> some DBA commands including update some database configuration
> parameters affecting application performance, like DFT_QUERYOPT, sort
> heap size, etc, without giving them DBA logins. Is it poosible to
> implement that facility as an application (whether client side or
> stored procedure) using DB2 Administrative C API, bound by a DBA user,
> and then granting execute permissions on the stored routine or package
> to a regular users?
>
> Thanks,
> -Eugene