Re: Replacement for BMC's Reorg for Informix product
Brian Moorhead of EDS sought a replacement for BMC Reorg on IDS 7.31 (Solaris 8) that could run from a batch script and use HPL; Server Studio JE was GUI-only. John Carlson said IIUG tools can manipulate the HPL database to create HPL jobs from the command line, which he had used on 7.30, 9.21 and 9.3. No product was named.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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