SQL0968C The file system is full

[Former Member]

Hi All,

In our BI pre-prod system we trying to test the BI data load.

It stopped giving this error in SM21

Database error -968 at FET

SQL0968C The file system is full. SQLSTATE=57011

Database error -968.

Our BI is 7.0 version ,DB2 8.1, AIX 5.3.

I checked in db2diag.log and found that temporary tablespace was full at that time.

Following is some example from db2diag.log.

********************************************************************************************

2007-06-18-21.00.17.073907+060 E154034841A701 LEVEL: Error

PID : 528538 TID : 1 PROC : db2pclnr 0

INSTANCE: db2fbr NODE : 000

FUNCTION: DB2 UDB, buffer pool services, sqlbClnrAsyncWriteCompletion, probe:0

MESSAGE : ADM6017E The table space "PSAPTEMP16" (ID "3") is full. Detected on

container "/db2/FBR/saptemp1/NODE0000/temp16/PSAPTEMP16.container000"

(ID "0"). The underlying file system is full or the maximum allowed

space usage for the file system has been reached. It is also possible

that there are user limits in place with respect to maximum file size

and these limits have been reached.

********************************************************************************************

But we tested the same load before with approximatly same amount of data but dont know why its giving the problem this time.

How to solve this temporary tablespace issue is it require to increase the filsystem size. tablespace is in autoextent mode and fiesystem is still 20GB free.

Regards,

Manish

[Former Member]

HI  Former Member

     We are also facing same issue. Can you please tell me how you will overcome the issue.

If any solution please reply me.

Thanks & Regards

manikanta

[Former Member]

Hi Manish,

when looking at the error message <a href="http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.msg-search.doc/doc/sql0968-sch.htm?resultof=%22%53%51%4c%30%39%36%38%43%22%20%22%73%71%6c%30%39%36%38%63%22%20">SQL0968C</a>, the documentation states the following:

-

---

SQL0968C

The file system is full.

Explanation:

<b>One of the file systems containing the database is full. This file system may contain the database directory, the database log files, or a table space container.</b>

The statement cannot be processed.

User response:

Free system space by erasing unwanted files. Do not erase database files. If additional space is required, it may be necessary to drop tables and indexes identified as not required.

On unix-based systems, this disk full condition may be due to exceeding the maximum file size allowed for the current userid. Use the chuser command to update fsize. A reboot may be necessary.

This disk full condition may be caused when containers are of varying sizes. If there is sufficient space in the file system, drop the table space and recreate it with containers of equal size.

sqlcode: -968

sqlstate: 57011

-

---

Please check also the other filesystems that belong to the database, not only the one where PSAPTEMP16 is included.

Check, if you are using quotas in your system.

Kind regards

Waldemar Gaida

[Former Member]

Manish,

If this is not the filesytem 'df-k', look for your userlimits 'ulimit -a'

best regards,

Joachim Müller

[Former Member]

Thanks Joachim,

Please check the output of ulimit -a on the same system.

huxc0005:db2fbr 13> ulimit -a

time(seconds) unlimited

file(blocks) unlimited

data(kbytes) unlimited

stack(kbytes) unlimited

memory(kbytes) unlimited

coredump(blocks) unlimited

nofiles(descriptors) 2000

[markus_doehr2]

How big is the file? Bigger than 2 GB? What filesystem are you using?

--

Markus

[Former Member]

Thanks Markus,

File is greater than 2GB for sure and filesystem type JFS2