error in alter fragment
Posted in 2012
Roger — — source: Usenet: comp.databases.informix
Hi,
I have the following situation:
There are several dbspaces in one instance, one dbspace is called
dbspaceA, other is called dbspaceB.
I have a table called table1 in dbspaceA
There are no free space in the host and the dbspaceA is full. However,
the dbspaceB has free space.
I want to free up space in the dbspaceA
When I run the SQL:
alter fragment on table table1 init in dbspaceB
the outpus is:
212: Cannot add index.
131: ISAM error: no free disk space
and in the log appears WARNING: DBspace dbspaceA is full and then the
SQL rolls back.
Why is this behaviour ?
My version is 11.50FC8 and runs in HP-UX
Thanks in advance
Roger.