Re: Finding pending in-place alters

Posted in 2006

bozon — 2 Feb 2006 06:51:33 -0800 — source: Usenet: comp.databases.informix

TJG Said >I have a sysmaster query that identify which tables have been altered in-place, but it >doesn't tell me which of these tables actually HAS old records out there. What is your query that does this? >So does anyone know a way to do this _without_ resorting to invasive onchecks? If you can restore your production server to a test system run your onchecks there.

↪ replying to bozon

Thomas J. Girsch — Sat, 04 Feb 2006 03:41:47 GMT — source: Usenet: comp.databases.informix

bozon wrote: > TJG Said >> I have a sysmaster query that identify which tables have been altered in-place, but it >doesn't tell me which of these tables actually HAS old records out there. > > What is your query that does this? > See Superboer's response. >> So does anyone know a way to do this _without_ resorting to invasive onchecks? > > If you can restore your production server to a test system run your > onchecks there. > This is what we've done in the past, but this time tight development schedules prohibited us from doing so.