Re: Replacement for BMC's Reorg for Informix product
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