[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

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!!
0
j_k
Asked:
j_k
  • 2
1 Solution
 
jpk041897Commented:
No there is no such tool perse, Informix is desgined to reuse all  space occupied by deleted records when writting new records.

The only way you can recover the space is to upload the data (using menus backup the data) physicly delete and recreate the table, and then restore the database.

This BTW, also applies to ORACLE, SYBASE, SQLWindows, etc.

The only DB that actualy has a pack function (that I am aware of anyways) is DBASE, and its there because it does not reuse the space.
0
 
j_kAuthor Commented:
Can you elaborate on "upload the data (using menus backup the data)".
What menus are you referring to?

0
 
jpk041897Commented:
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)


0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now