Replacement for BMC's Reorg for Informix product

One of our Informix systems uses BMC's "Reorg for Informix" product (Also know as "PATROL DB-Reorg for Informix".) for both truncating and reorganizing tables. This product automates these processes. For truncating a table, it drops and recreates the table putting back any indexes, views, access granted etc, thus avoiding long running DELETE statements. For reorganizing a table, it also includes the unloading and loading of the data with or without a WHERE clause. BMC are going to cease support for this product, at the end of this year, so we need to find a replacement product. Is anyone aware of a supported product that we could replace this BMC product with? The system in question uses Informix IDS 7.31 on Sun Solaris 8.

Brian, Server Studio JE has Table Reorganization wizard that does exactly what you are looking for. It can reorganize tables (and indexes) using 2 methods: - unload data, drop and recreate table, load data, recreate all indexes/views/permissions - reorganize "in place" using just SQL statements (without dropping a table) This method works if you need to modify any parameters except first extent size. You can download Server Studio JE from: www.serverstudio.com To invoke the Table Reorganization wizard, select any table in the Object Explorer tree and choose Maintenance -> Reorganize from popup menu You can also invoke the same operation using Tools -> Table Manager -> Reorganize top-level menu. Server Studio JE supports all versions of Informix starting from 7.2 and can operate under any OS platform. This is a client side application that can connect remotetly to multiple Informix instances from your workstation. Regards, Gary Okopnik AGS Ltd. Brian.Moorhead@eds.com (Brian Moorhead) wrote in message news:<467b294.0410071212.2308d52c@posting.google.com>... > One of our Informix systems uses BMC's "Reorg for Informix" product > (Also know as "PATROL DB-Reorg for Informix".) for both truncating and > reorganizing tables. This product automates these processes. For > truncating a table, it drops and recreates the table putting back any > indexes, views, access granted etc, thus avoiding long running DELETE > statements. For reorganizing a table, it also includes the unloading > and loading of the data with or without a WHERE clause. BMC are going > to cease support for this product, at the end of this year, so we need > to find a replacement product. > > Is anyone aware of a supported product that we could replace this > BMC product with? The system in question uses Informix IDS 7.31 on > Sun Solaris 8.