We need to move data from a fragment which resides on one DBSPACE which is currently allocated to a single Logical Volume (on a RAID Level 5 setup). We are using the following query

ALTER FRAGMENT ON TABLE main_table

MODIFY old_dbspace to fragment_id IN ("a”,"b") IN new_dbspace

The new_dbspace is allocated over 4 different logical volumes each with 500 MB of space and the old_dbspace has about 1.2 GB of data.

We are getting “ISAM: No free disk space” error after filling up about 2 volumes, despite the fact that the other volumes have plenty of free space.

Please help.

When you've created the new_dbspace with the first logical volume did you add the three other logical volumes as a chunk to the new_dbspace ?

Please also check your fragmentation expression that you are not pulling over data from other fragments (data that was not in old_dbspace) of your table into new_dbspace.

Thanks very much for the help.

We have verified that there isn’t any problem with the fragmentation expression.

As pointed out by you, the new dbspace was created and then three other logical volumes were added as chunks.