If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > -131 ISAM error: no free disk space

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Sep 2005
Posts: 7
-131 ISAM error: no free disk space

Hi,

I installed Informix Dynamic Server 10.0 and set up a database. In the beginning, I could access it like expected. But after some statements now I always get the ISAM error: no free disk space, or similar errors. Even a simple select * statement produces this error.
I installed everything on another machine (lots of disk space) and it's all the same.
I'm using the SPATIAL.8.20.TC2 datablade module but I didn't change the default configuration in any other way (i only set the DBSPACETEMP parameter in the ONCONFIG file for my server, but that didn't help).

Do you have an idea what might be wrong?
Thanks in advance
Tim
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Sep 2002
Posts: 102
Did you add those 'lots of disk space' to the database server (ie. add chunks)?
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Sep 2005
Posts: 7
No, I didn't add any chunks. Is this necessary after the usual installation? Do I have to use the onspaces tool?
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Sep 2002
Posts: 102
It is necessary because Informix does not know your OS free space. You add chunks for Informix to use. You can use onmonitor or onspaces to add chunks for your dbspaces.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Sep 2005
Posts: 7
I'm sorry for my newbie-ish answers. Now i figured out that lots of tables were placed in the rootdbs. I have to change the application so that it creates a new dbspace for every user.
Thanks for your help - it showed me the right way
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On