DB2 on Solaris : SQL0968C The file system is full. 
Author Message
 DB2 on Solaris : SQL0968C The file system is full.
Hi,
  In db2, I use:

CREATE DATABASE WAS

I received a exception : SQL0968C - the file system is full

My file system is not full, I have more than 1.6 gigs free.

Please help me... I don't have any quota, I'm root

any Idea?



Sat, 23 Aug 2003 05:44:18 GMT
 DB2 on Solaris : SQL0968C The file system is full.

First of all, I'm not sure that a DB2 CREATE DATABASE command will work
from root ... you may want to try your db2 instance owner. Second, are
you sure that the DB2 database directories are pointing to the same file
system that has 1.6GB free?
Quote:

> Hi,
>   In db2, I use:

> CREATE DATABASE WAS

> I received a exception : SQL0968C - the file system is full

> My file system is not full, I have more than 1.6 gigs free.

> Please help me... I don't have any quota, I'm root

> any Idea?



Sat, 23 Aug 2003 08:00:34 GMT
 DB2 on Solaris : SQL0968C The file system is full.

Quote:

>Hi,
>  In db2, I use:

>CREATE DATABASE WAS

>I received a exception : SQL0968C - the file system is full

>My file system is not full, I have more than 1.6 gigs free.

Which filesystem?  Where will the db be created?  (db2 get dbm cfg | grep
DFTDBPATH)  Is this the filesystem that you thought?  Is it on an NFS
filesystem (if so, move it!)?

Quote:
>Please help me... I don't have any quota, I'm root

The quota that matters isn't YOURs, it's the quota of the instance owner,
since that's the user that will create the db.
Quote:
>any Idea?



Sat, 23 Aug 2003 08:02:24 GMT
 DB2 on Solaris : SQL0968C The file system is full.
Make sure you have inodes free...
 You'll get that error if there are no files left... try a df -e

Quote:
> Hi,
>   In db2, I use:

> CREATE DATABASE WAS

> I received a exception : SQL0968C - the file system is full

> My file system is not full, I have more than 1.6 gigs free.

> Please help me... I don't have any quota, I'm root

> any Idea?



Sat, 23 Aug 2003 11:31:47 GMT
 DB2 on Solaris : SQL0968C The file system is full.
Hi, you should check the db2diag.log file in the sqllib/db2dump
directory of your instance . There you will find information about which
file db2 was trying to create ...
Quote:

> Hi,
>   In db2, I use:

> CREATE DATABASE WAS

> I received a exception : SQL0968C - the file system is full

> My file system is not full, I have more than 1.6 gigs free.

> Please help me... I don't have any quota, I'm root

> any Idea?



Sun, 24 Aug 2003 23:28:06 GMT
 DB2 on Solaris : SQL0968C The file system is full.

Quote:

>Hi,
>  In db2, I use:

>CREATE DATABASE WAS

>I received a exception : SQL0968C - the file system is full

>My file system is not full, I have more than 1.6 gigs free.

>Please help me... I don't have any quota, I'm root

>any Idea?

You will get the same error if you expand one of the containers in an SMS
tablespace past the file size limit. It's unlikely to be the source of
your error, but you might want to check your maximum file size (ulimit in
many shells).
   -Andy

--
"For what do we live, but to make sport for our neighbours, and laugh at them in our turn?"
     -Jane Austen



Sat, 30 Aug 2003 10:38:47 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Lead DB2 Systems Programmer/ IMS/DB2 Team/Full Time Position /USA

2. Lead DB2 Systems Programmer/ IMS/DB2 Team/Full Time Position

3. Lead DB2 Systems Programmer/ IMS/DB2 Team/Full Time Position /USA

4. Lead DB2 Systems Programmer/ IMS/DB2 Team/Full Time Position /USA

5. Lead DB2 Systems Programmer/ IMS/DB2 Team/Full Time Position /USA

6. Lead DB2 Systems Programmer/ IMS/DB2 Team/Full Time Position /USA

7. Lead DB2 Systems Programmer/ IMS/DB2 Team/Full Time Position /USA

8. Lead DB2 Systems Programmer/ IMS/DB2 Team/Full Time Position /USA

9. Lead DB2 Systems Programmer/ IMS/DB2 Team/Full Time Position /USA

10. DB2 7.1 AIX 4.3.3 Files system from normal to large file enabled

11. GA-Atlanta-97805--Systems Engineering-Systems Administration-UNIX-Administrator-Systems Engineer/UNIX/Solaris

12. GA-Atlanta-97805--Systems Engineering-Systems Administration-UNIX-Administrator-Systems Engineer/UNIX/Solaris


 
Powered by phpBB® Forum Software