Re: VACUUM on 2.10

Adam Tauno Williams wrote:
Nearest I can tell I am running Informix 2.10.03Y., or at least the


Run "onstat" dude!

onstat and even tbstat weren't even invented in this era. ;-)

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?


"update statistics", this is old Postgres (ingres?) speak.

No, you are thinking of ANALYSE. A VACUUM, as detailed already is to remove dead space in the data files.

Cheers,

--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@xxxxxxxxxxxxxxxxxx |//////// /|
| |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+


.

Relevant Pages

  • Re: Ping: Calvin & _____
    ... >John Hanson wrote: ... >>>I'm not totally retarded, dude. ... Trust me, I looked. ... >>>in a vacuum. ...
    (misc.fitness.weights)
  • Re: Jarhead
    ... And yo wouldn't know a vacuum if you lived in one. ... >>Tough to create substance from a vacuum. ... > Dude. ... You wouldn't know substance if it bit you on the ass. ...
    (misc.news.internet.discuss)