Re: tblspace overflow
Another response from one of our closet engineers :-) ...
-----------------------------------------------------------------------
>From clay.irving@execnet.com (clay irving)
Newsgroups: comp.databases.informix
Subject: tblspace overflow
Date: 3 Aug 92 19:04:55 GMT
I have an Informix database (4.1) with over 300 tables. I used dbexport
to unload the database. I then used dbimport to create a copy of my
database in another dbspace, but I received an error message:
311 - Cannot open system catalog (sysviews)
141 - {ISAM error: tblspace table overflow
My tblspace is set to 200 and coincidentally the error occured after
loading about 200 tables. It seemed obvious to increase the tblspace
value. 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?
========================================================
Clay Irving clay.irving@execnet.com
Project Manager 1.212.760.0070 (voice)
Garpac Corporation 1.212.564.2635 (fax)
============================={===========================
--
Executive Network Information System (914) 667-4567
---------------------------------
Clay:
If you wish to increate the number of tables you do not need to
re-initialize the whole system. You only needed to bring down shared
memory reset the parameter and then bring shared memory back up.
Below is the method for doing it from the command line or tbmonitor:
>From the command line
----------------------
1. tbmode -ky
2. vi $INFORMIXDIR/etc/$TBCONFIG
3. Change the number of TBLSPACES
4 tbinit
>From tbmonitor
--------------
Mode
Immediate-Shotdown (Yes)
Take-Offline (Yes)
Exit
Parameters
Shared-Memory
Change the value in "Max # of Open Tblspaces"
Hit "ESC" (Yes)
"Return"
---John
--
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
William Daul Advanced Support INFORMIX SOFTWARE INC.
4100 Bohannon Dr. (415) 926-6488 - wk
Menlo Park, CA. 94025 uunet!infmx!billd or billd@informix.com