RE: Informix ReOrg Scripts/Programs

Eric I have a Perl script which I wrote for reorganizing a database. This is what it does (this is from my inline docs for this tool, sorry if it is cryptic): # Allows reorg for a database or database table. Allows the user to # unload a table, drop it and recreate it with new parameters for # dbspace, initial and next extent size, then reloads the data. # Can be used iteratively against all tables in the given database. # System prompts for new values for dbspace and the extent sizes, # and also suggests values based on current data. User can choose # to simply drop and create a table to eliminate fragmentation. I have succesfully tested it for ver 7.x databases. It has been written to work with both 5.x and 7.x. It supports both interactive use and command line type use. However I dont use it very often so I cant guarantee that it is totally bug free. If you (or anyone else) are interested I can post the script in this newsgroup. Sujit Pal ---------- From: Eric W. Ziegenfus[SMTP:ziegene@caicorp.compaid.com] Sent: Tuesday, February 11, 1997 3:16 PM To: informix-list@rmy.emory.edu Subject: Informix ReOrg Scripts/Programs Are there any public domain Informix database re-organization scripts available? Is there any pointers to products that perform this action? I'd like to see what is available before duplicating efforts. ewz