I am running db2audit with SYSADMIN on a DB2 version 9 database under Solaris 10, with Veritas Cluster Services (VCS). I notice that db2set is being run every 10 seconds. It is my guess that VCS is running the command, but I don’t know and cannot find documentation of that. There are no other scripts or processes running that I can see might cause this.
I have seen other references to DB2 users seeing this, so I know this is not an isolated case.
Did you know that since version 8 the QUIESCE command has allowed you to block new connections for either the entire DB2 instance (and all databases under it) or to just quiesce a single database? You do this using the INSTANCE and DATABASE options.
You can also quiesce an instance or database, yet make exceptions to allow connections from specific users and groups, using the USER and GROUP options. You could use this, for example, to allow a production application to continue processing under its GROUP or USER authority, yet block ad hoc queries from business users. More useful yet is the ability to allow users with less than SYSADM/DBADM/SYSCTRL authority do maintenance on tables while excluding all other connections and workloads.
You can also allow applications to complete their current transaction by using the DEFER option, or allow them up to a specified period of time to complete (general default of 10 minutes) by using DEFER WITH TIMEOUT.
These options are documented here for:
