Link to home
Start Free TrialLog in
Avatar of j_k
j_k

asked on

informix packing

I have a huge database in Informix that keeps track of username, date, computer etc... of every plot sent to our plotter.  This database has over 150,000 records in it now.  I removed about 100,000 records but the file size of the database files remained the same.
Is there a pack tool or something like that that will purge the removed records from the database?  Searching is awful slow now!!
ASKER CERTIFIED SOLUTION
Avatar of jpk041897
jpk041897

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of j_k
j_k

ASKER

Can you elaborate on "upload the data (using menus backup the data)".
What menus are you referring to?

Use the Informix admin utilities and store  the DB.

Sorry about the referance to menus, got it mixed up with isql. (Haven't used Infrmix in over a year)