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
Solved

SQL0968C  The file system is full - while loading a DB2 table...What's up with this?

Posted on 2015-02-24
9
786 Views
Last Modified: 2015-03-01
Hi all,

While loading a DB2 table, I received a SQL0968C  The file system is full error. I have since not been able to determine what I need to do bout it...

Can someonedescribe what this error is about because I think I do have enough storage in my filesystem or could I be wrong about that...

What does the following information tells anybody?

time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        4194304
memory(kbytes)       32768
coredump(blocks)     2097151
nofiles(descriptors) 2000
threads(per process) unlimited
processes(per user)  unlimited


-----------------------++---------------

>df rapmw
Filesystem    512-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4        12582912  10577264   16%     5387     1% /
rapmq02hdqra / >df /
Filesystem    512-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4        12582912  10577264   16%     5387     1% /

Thanks

Enyimba
0
Comment
Question by:Enyimba
  • 5
  • 4
9 Comments
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 40630460
Hi Enyimba,

You might want to check to make sure that all of the table spaces are assigned to one of the devices that you show.

Can you post the full results of the *df*?


Kent
0
 

Author Comment

by:Enyimba
ID: 40632023
kdo,

Here's the full esult of the df -g command: What do you think is my problem here:

Filesystem                        GB blocks      Free    %Used    Iused %Iused Mounted on

/dev/rapmw_db2tmp01    150.00         149.98    1%        4     1% /rapmw/db2tmp01
/dev/rapmw_db2tmp02    150.00         149.98    1%        4     1% /rapmw/db2tmp02
/dev/rapmw_db2tmp03    150.00         149.98    1%        4     1% /rapmw/db2tmp03
/dev/rapmw_db2tmp04    148.00         147.98    1%        4     1% /rapmw/db2tmp04
/dev/rapmw_db2log01     99.75             81.04    19%       59    1% /rapmw/db2log01
/dev/rapmw_db2home      99.75          99.41    1%       55     1% /rapmw/db2home
/dev/rapmw_db2idx01    149.50         132.53   12%       82     1% /rapmw/db2idx01
/dev/rapmw_db2idx02    149.50         132.53   12%       82     1% /rapmw/db2idx02
/dev/rapmw_db2idx03    149.50         115.59   23%      106     1% /rapmw/db2idx03
/dev/rapmw_db2idx04    149.50         132.53   12%       82     1% /rapmw/db2idx04
/dev/rapmw_db2idx05    149.50         132.53   12%       82     1% /rapmw/db2idx05
/dev/rapmw_db2idx06    149.50         132.53   12%       82     1% /rapmw/db2idx06
/dev/rapmw_db2idx07    149.50         132.53   12%       82     1% /rapmw/db2idx07
/dev/rapmw_db2data01    149.50         13.33   92%      154     1% /rapmw/db2data01
/dev/rapmw_db2data02    149.50         81.41   46%      119     1% /rapmw/db2data02
/dev/rapmw_db2data03    149.50         81.41   46%      118     1% /rapmw/db2data03
/dev/rapmw_db2data04    149.50         13.33   92%      154     1% /rapmw/db2data04
/dev/rapmw_db2data05    149.50         81.41   46%      118     1% /rapmw/db2data05
/dev/rapmw_db2data06    149.50         81.41   46%      118     1% /rapmw/db2data06
/dev/rapmw_db2data07    149.50         81.41   46%      118     1% /rapmw/db2data07
/dev/rapmw_db2data08    149.50         81.41   46%      118     1% /rapmw/db2data08
/dev/rapmw_db2data09    149.50         81.41   46%      118     1% /rapmw/db2data09
/dev/rapmw_db2data10    149.50         81.41   46%      118     1% /rapmw/db2data10
/dev/rapmw_db2data11    149.50         81.41   46%      118     1% /rapmw/db2data11
/dev/rapmw_db2data12    149.50         81.41   46%      118     1% /rapmw/db2data12
/dev/rapmw_db2data13    149.50         81.41   46%      118     1% /rapmw/db2data13
/dev/rapmw_db2data14    149.50        149.48    1%        4     1% /rapmw/db2data14
/dev/rapmw_db2data15    149.50         81.41   46%      118     1% /rapmw/db2data15

Thanks

Enyimba
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 40632217
Two devices are at 92%.

Check to see what objects are assigned to them.
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

Author Comment

by:Enyimba
ID: 40632300
...and if I find specific object assigned to them, how do you move or re-assign the object(s) to a diffrent device?

Thanks

Enyimba
0
 

Author Comment

by:Enyimba
ID: 40632316
Without any changes or additional storage space, I tried to load one table and got the same error viz:
alter table PRODUCT_TRANS_LOG activate not logged initially
DB20000I  The SQL command completed successfully.

load from PRODUCT_TRANS_LOG.ixf of ixf savecount 50000 messages A315_01252015_907pm.msg replace into schema.PRODUCT_TRANS_LOG
SQL0968C  The file system is full.

But I do have enoughstorage spread over several LUNS...why is it that DB2 doeas not use other LUN that have more speace or spread the object storage over the other LUNS with morespace?
0
 
LVL 45

Accepted Solution

by:
Kent Olsen earned 500 total points
ID: 40632920
When that table was created it was assign to a specific tablespace.

You can get a full list of tables and their tablespaces with this query:

  select TABSCHEMA, TABNAME, TBSPACEID, TBSPACE from syscat.tables
  where TABSCHEMA not like 'SYS%'


From the command line, run this:

  list tablespaces

You'll get a 7 line entry for each tablespace in the system.  Select the tablespace that you wish to check and not the ID value in the first line.  Then run this:

  list tablespace containers for {ID}

That will show you the file(s) that contain the tablespace.


This method is a little bit cumbersome.  Depending on the GUI tools that you are using, you may be able to see all of that from the tool without having to query the system tables.


Kent
0
 

Author Comment

by:Enyimba
ID: 40633421
kdo, I have a tablespace ID of -6 and a tablespace name of NULL. What does db2 tablespace ID of -6 and tablespace name of NULL mean?

SCHEMA    TABLE                           TBSPACEID TSPACE
 --------- -----------------------              --------- ---------------
SCHEMA  CONSOLID_VALUES                -6 NULL
SCHEMA  PRODUCT_TRANS_LOG          -6 NULL

Thanks

Enyimba
0
 
LVL 45

Assisted Solution

by:Kent Olsen
Kent Olsen earned 500 total points
ID: 40633452
The tablespace is defined with table partitioning.

Check table syscat.datapartitions to find the tablespace that contains the table/partition.  (Column index_tbspaceid.)
0
 

Author Closing Comment

by:Enyimba
ID: 40638717
Thanks
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

839 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