I am trying to reorg a table and I am getting a error

SQL2216N SQL error "-968" occured while reorganising a database table or its indexes.

I tried different possibilities but I am unable to solve it.

It's giving a message in my diaglog that the "disk is full"

Can you suggest me anything with this?

Thanks in advance
milee

You are probably running out of temporary space. Check to see if there's enough space on the device hosting temporary TS container(s).

SQL0968C The file system is full.

Explanation:

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.

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

I checked with the temp tablespace and and the containers in the tablespaces too. We have only 1 container in every tablespace according to our business rules so ther's no point of that error.
I am able to reorg some tables in the same tablespace while some are not being reorged.(without & with using "use <tablespacename>")
I am not able to figure out what the problem is.

can u do df-k and let me know how much free space left in the file system for temp tabspace? and also tablesize?

There should be double the space of the tablesize in tempspace for the reorg to be successful..so u have two options..create a new temp tablespace using new filesystem...or ask your system admin to add more space to u'r current filesystem.

Thanks for your advice.But all that stuff is already done but still we have no improvement.

Thanks in advance
sharmilee.

did u try reorg with cleanup only option?
did it work on these tables?

I think cleanup option is for indexes and I didn't have any problem with reorging indexes. My problem is with tables and not all tables. I am not able to reorg not only large tables but also tables that have only 500 or so rows in it which don't require much space to reorg. Some tables were reorged without any problem.