By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

Cannot Reorganise any table in the tablespace

P: n/a
Hi,

I am unable to reorganise the tables and get an error
"SQL2216N SQL error "-968" occurred while reorganizing a database
table or its indexes."

Further, i find that all these tables belong to a tablespace and i
cannot reorganise any tables in that tablespace.
But, the tablespace has enough free space.

What could be the reason for it and what should be done to fix it.

Thanks a lot

Rahul

Sep 17 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Rahul.. SQL0968C The file system is full.... pls check Tempspace,
is it a DMS or SMS ? IF DMS, is it big enough ? IF SMS, do you have
enough free space on the file system where the tempspace is ?
/roger

Sep 17 '07 #2

P: n/a
Ian
Rahul Babbar wrote:
Hi,

I am unable to reorganise the tables and get an error
"SQL2216N SQL error "-968" occurred while reorganizing a database
table or its indexes."

Further, i find that all these tables belong to a tablespace and i
cannot reorganise any tables in that tablespace.
But, the tablespace has enough free space.
Look in your db2diag.log to see which tablespace/container filled up and
caused the issue; this will give you somewhere to start.

Also you may want to look at the ulimit settings (fsize) for the
instance owner.
Sep 17 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.