Informix 9.40: Need Script to Determine Which Tables Have IN-PLACE

Posted in 2004

Clifton M. Bean — Tue, 03 Aug 2004 01:25:59 — source: IIUG Forums & Mailing Lists

Does anyone have a script that will run against a sysmaster table that will quickly identify which tables within a database have active in-place alter tables. I used to have one that worked on 7.3+ instances but the sysmaster tables used by that script no longer exist in 9.40. I added sapmix to the email list believing that, perhaps, an SAP OSS note may address this issue and can be used by the non-SAP world to locate these tables. Thanks in advance. Clifton