IDS logs

Hello, Is there a way to find, in Informix logs, changes (DDL) to database schema tables? For instance, when a new table is created or a column added/dropped from a table, is this information recorded in Informix tables/logs? Also, when reading into logical logs and searching for table information (DML information) is the TABID or PARTNUM or TABLE NAME recorded into these logs? Thanks _________________________________________________________________ MSN Dating: Find someone special. Start now. http://go.microsoft.com/?linkid=9734384

Hello! Yes, every database command is logged (of course, if you're using a logged database type). On IDS 11.X you could check this link for more information: http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adref.doc/id s_adr_0350.htm (you didn't post your OS and IDS versions) :P The partnum is always recorded, also... the documentation tells evertything ok? Hope it helps. Regards. Em Seg, 2010-06-07 Ã s 11:00 -0400, Georges Martin escreveu: > Hello, > > Is there a way to find, in Informix logs, changes (DDL) to database schema > tables? > > For instance, when a new table is created or a column added/dropped from a > table, is this information recorded in Informix tables/logs? > > Also, when reading into logical logs and searching for table information (DML > information) is the TABID or PARTNUM or TABLE NAME recorded into these logs? > > Thanks > > _________________________________________________________________ > MSN Dating: Find someone special. Start now. > http://go.microsoft.com/?linkid=9734384 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > Alexandre Marini Especialista DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSGR / Sistemas IBM-Informix IBM Certified Professional - Informix Dynamic Server v.10 / v.11

DDL is logged and tables are identified by partnum. However, onlog doesn't print out everything that's in the log records. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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 Mon, Jun 7, 2010 at 11:00 AM, Georges Martin < georges_martin_1@hotmail.com> wrote: > Hello, > > Is there a way to find, in Informix logs, changes (DDL) to database schema > tables? > > For instance, when a new table is created or a column added/dropped from a > table, is this information recorded in Informix tables/logs? > > Also, when reading into logical logs and searching for table information > (DML > information) is the TABID or PARTNUM or TABLE NAME recorded into these > logs? > > Thanks > > _________________________________________________________________ > MSN Dating: Find someone special. Start now. > http://go.microsoft.com/?linkid=9734384 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd688c0f7bf0b048874a4f7