Re: Can you reorg a Table without stopping the DB?

In article <33dd2853.27805237@nntp> mshatila@anasazi.com (Mike Shatila) writes: >This depends on how large the table is. You might want to shut down >logging if you have a table with over 1 million rows. > >You can also create the table and load it by: > >begin work; >lock table [table name] in exclusive mode; >load from [text file] insert into [table ]>commit work >This can be done if you have less than 500,000 rows in the table. Sort of. This depends on how many locks you have configured, and locks used for a re-org is calculated by (number of rows * number of indicies on table). If I wanted to re-org a table via a load from an unload, i'd probably use dbload, and control the transaction size and locks that way. >: >:Jason Berryhill <jason_berryhill@hp.com> wrote in article >:<33D8D53E.5946@hp.com>... >:> Greetings to INFORMIX practitioners: >:> >:> Can anyone tell me if it is possible to do a reorg. on a table within IN >:> FORMIX without shutting down the database? I.E. keeping it online and >:> working. >:> -- Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona ---------------------------------------------------------------------- It's almost impossible to overestimate the unimportance of most things.