Hi,
as far as I know the root dbspace's size can't be changed unless it's initialized again. And with that you'll loose all the data in it so that's no option.
I see you also have a datadbs but it's quite small with 100 MB and I presume that your physical and logical logs are not redirected to that datadbs but still reside in the rootdbs. Are they big or numerous? And the user defined tables, do they reside in the rootdbs? That's because the datadbs is nearly empty.
There are two things you can try first. The easiest action is moving the user defined tables to the datadbs by unloading the data to files and write the dbschema's of the tables to files. Then drop the user defined tables and recreate them while adding the clause 'in webqa' to the table definition. Like:
Code:
create table "informix".somedata
(
col1 char(30) not null ,
col2 varchar(127,1) not null
primary key (col1) constraint "informix".pk_somedata
)
in webqa;
Load the data from the unload files again and see how much is freeed in de rootdbs. If it's enough for your purposes you're good.
If not you can move the physical and logical logfiles to new dbspaces. See the administrator guide for instructions. For that you need to create one or two cooked files, create phscllog and lgcllog dbspaces with onspaces and add the cooked files as chuncks to them. Use onparams to create new logfiles and delete the ones in the rootdbs.
Good luck,
Hans
dBforums
>
Increasing Database size
06-03-09, 14:52
Linear Mode
