How to know which databases and tables created/deleted yesterday?

Posted in 2000

DH — Fri, 24 Nov 2000 02:56:34 GMT — source: Informix-list mailing list archive (1991-1998)

Hi all, I would like to have a daily report of the list of datatabases and tables were created or deleted yesterday. Is it possible to do that with IDS2000? Can I use Unix Shell script to query it and run it everynight automatically with Unix cron deamon? Thanks in advance for any advise. DH.

↪ replying to DH

Rudy Fernandes — Fri, 24 Nov 2000 11:47:49 -0500 — source: Informix-list mailing list archive (1991-1998)

DH wrote: > Hi all, > > I would like to have a daily report of the list of datatabases and tables > were created or deleted yesterday. > > Is it possible to do that with IDS2000? Can I use Unix Shell script to query > it and run it everynight automatically with Unix cron deamon? > > Thanks in advance for any advise. > > DH Here's one way to go about it. Build a Script/Stored Proc. that records the various Databases/Tables as at a point in time. (sysmaster:sysdatabases, <dbname>:systables). This information should be stored in your own private database, for example Once you have that, a comparison of information returned on successive days should give you what you want. Rudy

↪ replying to DH

smooth1 — Sat, 25 Nov 2000 01:46:34 -0000 — source: Informix-list mailing list archive (1991-1998)

Go to my site www.smooth1.demon.co.uk and get dbdiff2.4gl. This can be used to compare database schemas. DH wrote in message <975034593.577486@news.aei.ca>... >Hi all, > >I would like to have a daily report of the list of datatabases and tables >were created or deleted yesterday. > >Is it possible to do that with IDS2000? Can I use Unix Shell script to query >it and run it everynight automatically with Unix cron deamon? > >Thanks in advance for any advise. > >DH. > >