RE: Table definition version

Posted in 2000

Bernstein, Rick — Mon, 4 Dec 2000 15:33:25 -0800 — source: Informix-list mailing list archive (1991-1998)

This is documented in section 8.60 of the Informix FAQ at http://www.smooth1.demon.co.uk/informix.htm -----Original Message----- From: Thanh Ngo [mailto:t-ngo@ti.com] Sent: Monday, December 04, 2000 15:00 To: informix-list@iiug.org Subject: Table definition version Hi. I have this question, can someone help me out. When I use command 'oncheck -pT database:table' a portion of output show me how many definition of a table. (oldest .... current). I want to write a SQL which show me all tables in a database have more than 2 definition version, but I don't know which system tables I have to select from. Thanks, Thanh Ngo

↪ replying to Bernstein, Rick

Thanh Ngo — Tue, 05 Dec 2000 13:22:45 -0600 — source: Informix-list mailing list archive (1991-1998)

Thank you for your quick response. I ran the script, it generated output with tables in dbspace. I random check the output which oncheck command and it show me some tables only have one definition. Do you know why? Other thing I don't understand is the value of tblpartnum was set to 1048577. Do I need to change this number to some other number and where it comes from? Again thanks for your help. Thanks, Thanh Ngo "Bernstein, Rick" wrote: > > This is documented in section 8.60 of the Informix FAQ at > http://www.smooth1.demon.co.uk/informix.htm > > -----Original Message----- > From: Thanh Ngo [mailto:t-ngo@ti.com] > Sent: Monday, December 04, 2000 15:00 > To: informix-list@iiug.org > Subject: Table definition version > > Hi. I have this question, can someone help me out. > When I use command 'oncheck -pT database:table' > a portion of output show me how many definition of > a table. (oldest .... current). > I want to write a SQL which show me all tables in a database have more than > 2 > definition version, but I don't know which system tables I have to select > from. > > Thanks, > Thanh Ngo