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

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

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

Two devices are at 92%.

Check to see what objects are assigned to them.

...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

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?

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

Thanks