Informix Error 131
activity 131; temp; onbar; ontape; no free disk space Technote (troubleshooting) Problem(Abstract) Error 131, no free disk space during onbar backup with heavy activity. Onbar will not complete the back up and give the following error code. 2013-04-01 02:23:31 4156272 3241528 Unable to get storage space backup data from the database server: ISAM error: no free disk space. -131 ISAM error: no free disk space. Cause With heavy activity during level zero archive, onbar will not be able to complete the archive, and receive the following error: Archive failed - 131 ISAM error: no free disk space. Resolving the problem Workarounds that will reduce the chance of hitting this condition: Increase size of temp dbspace . This will give the maximum allowable space to the archive process. For example increase temp dbspace by 2gig. Perform archives at off peak times. This will cut down on the amount of temporary space used. Add one or more additional temporary dbspaces. This will help the archive indirectly by giving additional temporary space to other online process. If this is done, and the temporary dbspaces are not all the same size, then set: DBSPACETEMP = to the larger spaces. For example, if temp1 and temp2= 2 gig, and temp3 and temp4 =1 gig, then set: DBSPACETEMP = temp1:temp2, otherwise, the archive may create a temp table in one of the smaller temp dbspaces Use /tmp by setting PSORT_DBTEMP to a UNIX file system. If the platform supports large file systems, you can set: PSORT_DBTEMP = to a UNIX file system for the onbar session only. This will not affect the other users. Implement incremental archives. Level 0 archives the whole online system, while level's 1 and 2 will archive pages that have been modified since the last archive. This will reduce the archiving time, which will help in scheduling for off peak time Document information More support for: Informix Servers Software version: 11.1, 11.5, 11.7, 12.1 Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows Reference #: 1433140 Modified date: 2014-06-26 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
disk space” executing an archive of the IBM Informix Dynamic Server (IDS) instance. free; disk; space; archive Technote (troubleshooting) Problem(Abstract) This document explains how to avoid the interruption of the IBM IDS backup due a lack of temporal space while the archive is running. An archive process stops and you get these errors: Archive failed - ISAM error: no free disk space or Error 131, no room left on device 2013-04-01 02:23:31 141562 361528 Unable to get storage space backup data from http://www-01.ibm.com/support/docview.wss?uid=swg21433140 the database server: ISAM error: no free disk space. Cause The problem occurs when the IBM Informix Dynamic Server (IDS) database server is running out of disk space while writing to a temporary table. Resolving the problem You can take these actions to reduce the chance of getting the errors: Increase the space of the temporary dbspace. This gives the maximum allowable http://www-01.ibm.com/support/docview.wss?uid=swg21156274 space to the archive process. Add one or more additional temporary dbspaces. This helps the archive indirectly by giving additional temporary space to other IDS processes. If there are several temporary dbspaces that are not all the same size, then set the DBSPACETEMP environment variable of the session to the larger dbspaces. Perform archives at off-peak times. This will lower the amount of temporary space used. Implement incremental archives. Use level 0 archives for the entire system. Use level 1 and 2 to archive pages that have been modified since the last archive. This will reduce the archiving time. Increase the space in the rootdbs dbspace. If there are no temporary dbspaces, the engine creates the temporary in the rootdbs. Related information A Japanese translation is available Document information More support for: Informix Servers Software version: 7.3, 9.4, 10.0, 11.1, 11.5, 11.7, 11.70, 12.1 Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows Reference #: 1156274 Modified date: 2004-10-04 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
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 http://www.dbforums.com/showthread.php?1197353-131-ISAM-error-no-free-disk-space want to visit from the selection below. Results 1 to 5 of 5 Thread: -131 ISAM error: no free disk space Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear https://www.experts-exchange.com/questions/23428616/229-Could-not-open-or-create-a-temporary-file-131-ISAM-error-no-free-disk-space.html Mode Switch to Hybrid Mode Switch to Threaded Mode 09-29-05,11:19 #1 Duschvorhang View Profile View Forum Posts Registered User Join Date Sep 2005 Posts 7 Unanswered: -131 ISAM error: no free disk space Hi, I installed Informix informix error 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 informix error 131 (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 09-29-05,11:26 #2 blackguard View Profile View Forum Posts 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 09-29-05,11:44 #3 Duschvorhang View Profile View Forum Posts 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 09-29-05,11:54 #4 blackguard View Profile View Forum Posts 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 09-30-05,12:03 #5 Duschvorhang View Profile View Forum Posts 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 Quick
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > 229: Could not open or create a temporary file. - 131: ISAM error: no free disk space Want to Advertise Here? Solved 229: Could not open or create a temporary file. - 131: ISAM error: no free disk space Posted on 2008-05-23 Databases MS SQL Server 1 Verified Solution 4 Comments 3,100 Views Last Modified: 2013-12-24 After executing the folowing query this error pop up and I don't know Informix. The question is what was the cause and how to solve this problem: ---------------------- awas1c@awasuat_shm ----- Press CTRL-W for Help ------- 229: Could not open or create a temporary file. 131: ISAM error: no free disk space select count(*) from screen_perms where role in (select role from user_role where userid=' UR21116' ) 0 Question by:LindaC Facebook Twitter LinkedIn Google LVL 2 Best Solution byTheLastStraw Informix uses dbspaces made up of 'chunks' of disk space to store data. These can be marked as temporary and used for such things as creating temporary tables or sorting data. If there are no temporary Go to Solution 3 Comments LVL 61 Overall: Level 61 Databases 9 MS SQL Server 4 Message Active today Expert Comment by:gheist2008-05-25 It is full temporary dbspace on server. Admin should examine log and add more space. 0 LVL 61 Overall: Level 61 Databases 9 MS SQL Server 4 Message Active today Expert Comment by:gheist2008-05-25 select count(*) from screen_perms where role in (select role from user_role w