Event monitor creation date

udbraja · #1 (**permalink**) 04-05-06, 09:03

Team,

How we can find the Event monitor creation date ?

Is there any way?

Thanks,
R

GertK · #2 (**permalink**) 04-05-06, 11:53

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.

udbraja · #3 (**permalink**) 04-07-06, 10:45

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

ARWinner · #4 (**permalink**) 04-07-06, 12:10

If you setup the event monitor to write to tables, you can look at the creation timestamp of those tables.

Andy

udbraja · #5 (**permalink**) 04-07-06, 13:12

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

ARWinner · #6 (**permalink**) 04-07-06, 13:41

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

udbraja · #7 (**permalink**) 04-07-06, 14:03

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

ARWinner · #8 (**permalink**) 04-07-06, 14:32

I think you are out of luck.

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech