Hello,
I'd like to create event monitor on DB2 z/OS 9.2 i have spent a lot of time trying resolve this problem.
So i suggest this link:
Tuning DB2 Universal Database Using the Statement Event Monitor
and trying to make this steps:
Code:
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 command: create event monitor rkmon for statements write to file '/tmp' Db2 throw me an error:
Code:
"DB2ADMIN" does not have the privilege to perform operation "CREATE EVENT MONITOR".. SQLCODE=-552, SQLSTATE=42502, DRIVER=3.58.81
so, then i try add some privilege to my db2admin user:
Code:
connect to mydatabase user db2admin password xyz
Code:
grant DBADM to db2admin
but get another error:
Code:
The name "DBADM" cannot be used because the specified identifier is reserved for system use.. SQLCODE=-707, SQLSTATE=42939, DRIVER=3.58.8
1
So, i tried this one:
Code:
grant DBADM on mydatabase to user db2admin
but got error:
Code:
DB2ADMIN.MYDATABASE is an undefined name. SQLSTATE=42704
I understand this error like, I'm logged and "in" database so there is undenfiend name.
Now, I don't have any idea what shoould i do to resolve this problem.
Maybe, there is some othere way to logs sql queries sends to my db2 ?
(I develop some java apps using hibernate and db2, and sometimes quickest way to resolve some problem is see what sql queries is send to db).
Any ideas ?
Thanks
dBforums
>
DB2 creating event monitor.
10-31-10, 03:48
Linear Mode
