Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: Event monitor creation date

    Team,

    How we can find the Event monitor creation date ?

    Is there any way?

    Thanks,
    R

  2. #2
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    96
    I've checked the catalog tables but couldn't find any creation date in any related table so I guess you're out of luck.

  3. #3
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    mmm... That's not fair. :-(

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If you setup the event monitor to write to tables, you can look at the creation timestamp of those tables.

    Andy

  5. #5
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    Is there any way we can get the DDL info for the event montior. Db2look did not have.
    No idea who created out in data warehouse staging db and what for and whether it uses table or file space.

    Thanks

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look in syscat.eventmonitors, syscat.events, and syscat.eventtables. These will tell you if it is writing to tables (you will see entries in eventtables).

    Andy

  7. #7
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    This event monitor goes to file under /tmp/tester12. But I dont find tester12 under /tmp directory.

    The challenging task is how to find out... when this event monitor was created.

    Thanks
    -R

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I think you are out of luck.

    Andy

Posting Permissions

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