Oninit cdi / Archive
Talk to an expert →

Adding new chunk/free up used chunk

Posted in 2007

Summary

A user on IDS 7.31 (Solaris) had a user table filling up rootdbs and couldn't add a new chunk, getting "Cannot add a new chunk to the DBspace / ISAM error: no free disk space"; deleting rows didn't help. Replies explained that if rootdbs' first chunk is completely full, no space can be added anywhere, and suggested freeing space first: unload and drop the table, add the chunk, then reload; move the table out with CREATE CLUSTER INDEX IN another dbspace or ALTER FRAGMENT ON TABLE ... INIT IN <other dbspace>; or drop and later recreate sysmaster from sysmaster.sql. The poster thanked the responders but didn't report which fix he used.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Error Codes & Troubleshooting, Platform-Specific Issues, Versions, Editions & End-of-Life

ANG VINCENT — — source: IIUG Forums & Mailing Lists

Hi, I am currently having a table that is stored in rootdbs and it almost used up all the available pages inside that space. So I decided to add a new chunk to it but it was unsuccessful. The error given is: Cannot add a new chunk to the DBspace. ISAM error: no free disk space Searched for this error and IBM is asking to call their technical support -> http://www-1.ibm.com/support/docview.wss?uid=swg21137687 So my question here is: 1) How can I resolve this without calling? 2) Any way I can free up the used chunk? Deleting records from the table doesn't seem to help. Hopefully someone can answer me. Thanks. FYI, I am currently using IDS 7.31 in Solaris (intel)

↪ replying to ANG VINCENT
SANJIT CHAKRABORTY — — source: IIUG Forums & Mailing Lists

Easiest way, unload data from a table and drop the table. This will free up some space. Add a new chunk. Create the dropped table and load data. - Sanjit Chakraborty

↪ replying to ANG VINCENT
Keith Simmons — — source: IIUG Forums & Mailing Lists

On 18/05/07, ANG VINCENT <vmech0001@yahoo.com> wrote: > Hi, > > I am currently having a table that is stored in rootdbs and it almost used up > all the available pages inside that space. So I decided to add a new chunk to > it but it was unsuccessful. The error given is: > > Cannot add a new chunk to the DBspace. > ISAM error: no free disk space> > Searched for this error and IBM is asking to call their technical support > -> http://www-1.ibm.com/support/docview.wss?uid=swg21137687 > > So my question here is: > 1) How can I resolve this without calling? > 2) Any way I can free up the used chunk? Deleting records from the table > doesn't seem to help. > > Hopefully someone can answer me. Thanks. > > FYI, I am currently using IDS 7.31 in Solaris (intel) > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > There is a problem that, if the first chunk of rootdbs is completely full, it is not possible to add more space (anywhere in the database). If you have sufficient space elsewhere then you could recreate the table there with a 'CREATE CLUSTER INDEX IN ' command. Alternativly you could drop the sysmaster database, add the new chunk and then recreate the sysmaster database using the sql script in $INFORMIXDIR/etc/sysmaster.sql. Keith

↪ replying to Keith Simmons
ANG VINCENT — — source: IIUG Forums & Mailing Lists

Thanks for the reply Keith.

↪ replying to SANJIT CHAKRABORTY
ANG VINCENT — — source: IIUG Forums & Mailing Lists

Thanks for your response SANJIT.

↪ replying to ANG VINCENT
ART KAGEL, BLOOMBERG/ — — source: IIUG Forums & Mailing Lists

If you have another dbspace with enough free space you can: ALTER FRAGMENT ON TABLE <mytable> INIT IN <other dbspace>; That will free up space in rootdbs where nothing should be residing except system created databases anyway. Art S. Kagel ----- Original Message ----- From: Ang Vincent <ids@iiug.org> At: 5/18 7:47:55 Hi, I am currently having a table that is stored in rootdbs and it almost used up all the available pages inside that space. So I decided to add a new chunk to it but it was unsuccessful. The error given is: Cannot add a new chunk to the DBspace. ISAM error: no free disk space Searched for this error and IBM is asking to call their technical support -> http://www-1.ibm.com/support/docview.wss?uid=swg21137687 So my question here is: 1) How can I resolve this without calling? 2) Any way I can free up the used chunk? Deleting records from the table doesn't seem to help. Hopefully someone can answer me. Thanks. FYI, I am currently using IDS 7.31 in Solaris (intel) ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary