Schema Journaling within INFORMIX
Can changes to the schema be automatically maintained in a system catalog, or elsewhere, when ALTERing the schema with DBACCESS or an SQL proc?.. Although for years I have been manually documenting any changes, it would be very desirable for the server record these changes.
On Sun, May 6, 2012 at 7:25 PM, FRANK J. COMPUTER <frank_in_pr@hotmail.com>wrote: > Can changes to the schema be automatically maintained in a system catalog, > or > elsewhere, when ALTERing the schema with DBACCESS or an SQL proc?.. > Although > for years I have been manually documenting any changes, it would be very > desirable for the server record these changes. > They are not really automatically recorded anywhere. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --bcaec554d4ecc9eb9804bf6a53fd
No is the simple answer. However, Informix comes with an AGS Server Studio basic license and a 30 day free trial of the full enterprise license for both Server Studio and Sentinel. Sentinel has the ability to not only take periodic snapshots of your schema and server configuration states and store them in its repository, it will automatically notify you when something changes. So if someone makes an unauthorized schema or ONCONFIG file change you will get an email alert. If you give that a try and like it, you can upgrade to a permanent enterprise license. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, May 6, 2012 at 10:25 PM, FRANK J. COMPUTER <frank_in_pr@hotmail.com>wrote: > Can changes to the schema be automatically maintained in a system catalog, > or > elsewhere, when ALTERing the schema with DBACCESS or an SQL proc?.. > Although > for years I have been manually documenting any changes, it would be very > desirable for the server record these changes. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec5299a3168137304bf6f7a76