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.c om>...
> 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.

Gary, thanks for your response.

I contacted AGS Technical Support and found that Server
Studio JE did not quite meet our requirements. One requirement I
neglected to mention in my initial message was that we need to be able
to invoke/execute the product, to reorganization/truncate tables, from
within a batch script. Server Studio JE can only be invoked via a GUI
interface.

Does anyone know of a supported product that fulfills the
requirements I previously mentioned, and can be invoked/executed from
within a script. Also, we need it to be able to utilize High
Performance Loader (HPL) on large table.

Brian Moorhead
EDS

ginzba@hotmail.com (Gary) wrote in message news:<45a6b344.0410080742.4cf34c88@posting.google. com>...
> 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.

On 28 Oct 2004 14:46:17 -0700, Brian.Moorhead@eds.com (Brian Moorhead)
wrote:

>Gary, thanks for your response.
>
> I contacted AGS Technical Support and found that Server
>Studio JE did not quite meet our requirements. One requirement I
>neglected to mention in my initial message was that we need to be able
>to invoke/execute the product, to reorganization/truncate tables, from
>within a batch script. Server Studio JE can only be invoked via a GUI
>interface.
>
> Does anyone know of a supported product that fulfills the
>requirements I previously mentioned, and can be invoked/executed from
>within a script. Also, we need it to be able to utilize High
>Performance Loader (HPL) on large table.
>
>Brian Moorhead
>EDS
>

What engine version are you running?

JWC

>ginzba@hotmail.com (Gary) wrote in message news:<45a6b344.0410080742.4cf34c88@posting.google. com>...
>> 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.

>
> What engine version are you running?
>

Brian mentioned in hist first message that it is IDS 7.31 on Solaris 8.

Gorazd

On Sat, 30 Oct 2004 10:48:21 +0200, "Gorazd Hribar Rajteric"
<REMOVE_gorazdh@hotmail.com> wrote:

>>
>> What engine version are you running?
>>
>
>Brian mentioned in hist first message that it is IDS 7.31 on Solaris 8.
>
>Gorazd

My bad. . . I seem to have lost that message.

There are tools at the IIUG website that allow a DBA to manipulate the
HPL database so as to create HPL jobs from the command line. I did
that in a previous life on 7.30, 9.21, and 9.3 with no ill effects.

Disclaimer: It worked for me. Test, test, test, and test some more.
Your mileage may vary. Void where prohibited. Batteries not included,
and so on . . .

JWC

Thanks John.

We were hoping to find a supported product. I had looked at the
IIUG web site previously and not found anything that did all we wanted
it to. I will now look again and see what we can use.

Brian

John Carlson <jwcarlson1@yahoo.com.invalid> wrote in message news:<6bebo0lau1ud99216ae35cvoslou8pv3o9@4ax.com>. ..
> On Sat, 30 Oct 2004 10:48:21 +0200, "Gorazd Hribar Rajteric"
> <REMOVE_gorazdh@hotmail.com> wrote:
>
> >>
> >> What engine version are you running?
> >>
> >
> >Brian mentioned in hist first message that it is IDS 7.31 on Solaris 8.
> >
> >Gorazd
>
> My bad. . . I seem to have lost that message.
>
> There are tools at the IIUG website that allow a DBA to manipulate the
> HPL database so as to create HPL jobs from the command line. I did
> that in a previous life on 7.30, 9.21, and 9.3 with no ill effects.
>
> Disclaimer: It worked for me. Test, test, test, and test some more.
> Your mileage may vary. Void where prohibited. Batteries not included,
> and so on . . .
>
> JWC

On 2 Nov 2004 16:15:45 -0800, Brian.Moorhead@eds.com (Brian Moorhead)
wrote:

>Thanks John.
>
> We were hoping to find a supported product. I had looked at the
>IIUG web site previously and not found anything that did all we wanted
>it to. I will now look again and see what we can use.
>
>Brian
>

Just a reminder . . . what you will find at the IIUG website will be
unsupported by IBM/Informix. It may work (remember . . . .test, test,
test, test) but it will be officially unsupported.

JWC