I want to create an event monitor in DB2 z / OS 9.2 I spent a lot of time trying to solve this problem.
So, I suggest this link: http://www.ibm.com/developerworks/data/library/techarticle/0303kolluru/0303kolluru.html
and try the following steps:
db2 => connect to dbname user username using password
db2 => update monitor switches using statement on
db2 => create event monitor rkmon for statements write to file '/tmp'
db2 => set event monitor rkmon state=1
but when I put the command: create an rkmon event monitor for the operators, write to the '/ tmp' file Db2 gave me an error:
"DB2ADMIN" does not have the privilege to perform operation "CREATE EVENT MONITOR".. SQLCODE=-552, SQLSTATE=42502, DRIVER=3.58.81
therefore, I will try to add some privilege to my db2admin user:
grant DBADM to db2admin
but get another error:
The name "DBADM" cannot be used because the specified identifier is reserved for system use.. SQLCODE=-707, SQLSTATE=42939, DRIVER=3.58.81
Now I don’t know what to do to solve this problem.
Maybe there is some way to register sql requests to my db2?
( java-, hibernate db2, - - , sql db).
?