Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    62

    Unanswered: Recreate event monitors ?

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You need to also look at SYSCAT.EVENTS, and maybe SYSCAT.EVENTTABLES in some cases (if the event monitor is defined to write to a table). All of these catalog views are documented in the SQL Reference Vol 1, Appendix D System Catalog Views.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •