Re: tblspace overflow (fwd)

In article <9260@emory.mathcs.emory.edu> cris@logic.dsg.ti.com (Cris Schramm) writes: >> From: clay.irving@execnet.com (clay irving) >> Subject: tblspace overflow >> >> The only way I know to increase this value is to initialize the >> database and increase the shared memory parameters -- this is going >> to clear {m{y root dbspace (not quite a friendly thing)! >> Does anyone have another solution? > >You don't have to reinitialize your database or any of your disk parameters, >only your shared memory parameters. Take OnLine off-line. Enter the >Parameters Menu. Select the Shared-memory option. Change the number >of table spaces. Then reinitialize. This is essentially correct. "Reinitialize" in the last sentence is an unfortunate choice of word, though, as reinitializing is not necessary. What you are actually doing at that point is restarting OnLine (enter the Modes menu and choose Startup then On-Line). Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** The heart and the mind on a parallel course, never the two shall meet. -E. Saliers