I have a before-update trigger a bit like
...
    REFERENCING OLD AS O NEW AS N
...

I have a user UCLDEV1 which is a part of staff and a
group(db2schemagrp1) to which i have not given any permissions.
The authorizations of that user are shown as
db2 => get authorizations

I want to grant only the connect, select, insert, update privileges on
all the tables of a  schema to a particular user/group
Initially, i had revoked all the privileges from public.
It seems that the privileges Select, Insert, Update can be given only

We have been migrating to DB2 and it has been the trend that the
application has become somewhat slow.
It could be because of the application problems or it could be because
i am not very aware of how to try to improve the performance of the

I understand in older versions of DB2/UDB this was not possible. The
following article explains how I might do this
http://www.ibm.com/developerworks/db2/library/techarticle/0207kline/0207kline.html
Is this still a restriction in version 9.x? I'd specifically like to