Re: VACUUM on 2.10

This is a product that is at least 10 years old, and was licensed from
Informix for redistribution. So I do not think they have updated
anything, since that would require them to re-license Informix.

Doing an ./sqlexec -V give me 2.10.03Y so that is what I am starting
with.

VACUUM is the SQL statement that will basically remove dead space
caused from multiple updates and deletions. Compacting the database to
its true size (size being file size as it is stored in the File System)

a UDR is Unload Delete and Replace. Basically they export out all the
data, build the table from scratch, and import the data back in,
effectively removing any dead space.

Art S. Kagel wrote:
VD1 wrote:
Nearest I can tell I am running Informix 2.10.03Y., or at least the

Informix 2.10? I very much doubt it. Why do you think you are running such
a version?

core of it is. Looks like it might have been bought and repackaged.
None the less, what if any is the SQL to perform a VACUUM on older
informix dbs?

what is a VACUUM?

Currently the staff is doing UDR everytime there is a major deletion.

And what is 'UDR'? Certainly not 'User Defined Routine' which is its
current meaning in Informix parlance. By its context I cannot tell what
that is.

Please provide more information. A file listing of the installation
directory would help us to either determine what database flavor you have or
to suggest how you can find out.

Art S. Kagel

.

Relevant Pages

  • Re: VACUUM on 2.10
    ... what if any is the SQL to perform a VACUUM on older ... "update statistics", this is old Postgres speak. ... current meaning in Informix parlance. ...
    (comp.databases.informix)
  • RE: Postgres or Mysql
    ... >Yes, stay with Informix. ... >Art S. Kagel ... We unload our INFORMIX to a MySQL ...
    (comp.databases.informix)
  • Re: informix - tool like SQL server profiler
    ... Art, very useful but... ... I have just few user accounts (informix, one DBA user, etc.) explicitly ... All other users are users created on Active Directory and Informix (or ... You are running 9.40 so there is the onmode command: ...
    (comp.databases.informix)
  • RE: Looking for 2 Informix Leads and 6 Informix Developer - Urgent
    ... know of some large database vendors that use other vendor's technologies. ... On Behalf Of Art S. Kagel ... Looking for 2 Informix Leads and 6 Informix Developer - Urgent ... Call system that is built over an Informix database. ...
    (comp.databases.informix)
  • Re: VACUUM on 2.10
    ... Art S. Kagel wrote: ... Informix for redistribution. ... There is no built-in table reorganization command like a 'VACUUM' (although IBM has been asked to consider adding a built-in table reorg for IDS v10.50 or v11.00 the next two releases, ... There is one possibility, I don't remember if SE had clustered indexes, if so, altering an index TO CLUSTER will cause the table's rows to be sorted into new space and unused space will be released. ...
    (comp.databases.informix)