Hello,
Running db2 v9.5 AIX v6.1.
I did redirected restore of our sap db. Db instance owner changed from db2u1 to db2u2. One of post restore tasks is to recreate event monitors which were created under old instance owner name and now throws errors. The goal is to create exactly the same event monitors only using current instance owner (db2u2). This is ouput of "select * from syscat.eventmonitors":
Code:
EVMONNAME OWNER OWNERTYPE TARGET_TYPE TARGET MAXFILES MAXFILESIZE BUFFERSIZE IO_MODE WRITE_MODE AUTOSTART DBPARTITIONNUM MONSCOPE EVMON_ACTIVATES NODENUM DEFINER REMARKS
----------------- ------ -------------------------------------------------- ----------- ----------- ----------- ------- ---------- --------- -------------- -------- --------------- ------- ------- -------
DB2DETAILDEADLOCK DB2U1 U F db2detaildeadlock 20 512 17 B A Y 0 G 0 0 DB2U1 -
DB6_EDLMON1 DB2U1 U F /db2/db2u1/db2event/edlmon1 - 1000 2 B R Y 0 L 0 0 DB2U1 -
DB6_EDLMON2 DB2U1 U F /db2/db2u1/db2event/edlmon2 - 1000 2 B R N 0 L 0 0 DB2U1 -
3 record(s) selected.
The syntax of "create event monitor" statement is rather complex and I have no idea what parameters to use to construct event monitors exact as they are now.
Any ideas ?
thanks
Vilius
dBforums
>
Recreate event monitors ?
10-28-10, 01:02
Linear Mode
