Solved

Know how to check if I'm running out of swap space on Solaris 8?

Posted on 2001-06-26
7
946 Views
Last Modified: 2013-12-27
I'm wondering if I'm somehow weirdly running out of swap space.  We get some errors that are telling us that the device is full.  But, there's still plenty of room on the partitions.

We only got 64MB of ram and are running an Informix DB on it.  I did setup 1GB of swap space.  But, I'm just wondering if it's using it all or something wierd like that.

Thx
0
Comment
Question by:richyz26
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 38

Expert Comment

by:yuzh
ID: 6229762
Hi  richyz26,

    type in:
             swap -l  
   to find outthe usage of  your swapping space, you nothing left, you need to add more swap space to your system.

   You are runing DB, and only have 64MB RAM, you might have to check this out.

    Cheers!

yuzh
0
 
LVL 4

Expert Comment

by:jlms
ID: 6230860
Please post the errors as well as the output of "df -kl" and "swap -l"

0
 

Author Comment

by:richyz26
ID: 6231786
# df -kl
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/dsk/c0d0s0      1205046  937419  207375    82%    /
/dev/dsk/c0d0p0:boot   10484    1623    8861    16%    /boot
/proc                      0       0       0     0%    /proc
fd                         0       0       0     0%    /dev/fd
mnttab                     0       0       0     0%    /etc/mnttab
swap                 1062584       4 1062580     1%    /var/run
swap                 1062604      24 1062580     1%    /tmp
/dev/dsk/c0d0s7      16993969  670462 16153568     4%    /export/home
# swap -l
swapfile             dev  swaplo blocks   free
/dev/dsk/c0d0s1     102,1       8 2048248 2048248


Here's a java error we get that is caused by a Standard JDBC call (getPrimaryKeys).  Some device somewhere is out of space (I wonder if we're actually using the swap space):

java.sql.SQLException: Could not open or create a temporary file.      at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:340)      at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:2830)      at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3115)      at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2118)      at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2041)      at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:670)      at com.informix.jdbc.IfxResultSet.executeUpdate(IfxResultSet.java:277)      at com.informix.jdbc.IfxStatement.executeUpdateImpl(IfxStatement.java:745)      at com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:199) SQL Error Code = -229 SQL State = IX000 SQL next exception =        at com.informix.jdbc.IfxDatabaseMetaData.getPrimaryKeys(IfxDatabaseMetaData.java:4008)      at Test.main(Test.java:69) java.sql.SQLException: ISAM error: no free disk space      at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:340)      at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:2830)      at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3119)      at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2118)      at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2041)      at com.informix.jdbc.IfxSqli.executeCommand(IfxSqli.java:670)      at com.informix.jdbc.IfxResultSet.executeUpdate(IfxResultSet.java:277)      at com.informix.jdbc.IfxStatement.executeUpdateImpl(IfxStatement.java:745)      at com.informix.jdbc.IfxStatement.executeUpdate(IfxStatement.java:199)      at com.informix.jdbc.IfxDatabaseMetaData.getPrimaryKeys(IfxDatabaseMetaData.java:4008)      at Test.main(Test.java:69)
0
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 
LVL 1

Expert Comment

by:k.kidambi
ID: 6232822
What is the size of your database (informix) check that whether the device full messages are from that.

post your comments here

Kidambi
0
 
LVL 4

Expert Comment

by:besky
ID: 6232876
Your machine doesnt seem to be out of resources.

You are only using up 1% of avalable swapspace
and from the java output it seems like the program are trying to create a file at informix.com (  I guess this is not your domainname).

Could be a configuration problem or an automatic problemreporting back to informix that does not find any diskspace.
0
 
LVL 5

Expert Comment

by:Nisus091197
ID: 6233010
Can you check the database sort space while your java process is running?

Do you get the same result when you have logging turned off?

Regards, Nisus
http://www.omnimodo.com
0
 
LVL 5

Accepted Solution

by:
Nisus091197 earned 35 total points
ID: 6233017
In your $INFORMIXDIR/etc/onconfig file check if you got the DBSPACETEMP variable filled with the names of your Temporary DBspaces separated by commas or colons (no
white space).
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question