I have two dbspaces that at one time have had automatic storage added to them and I need that space to go away as it is empty and is impeding moving out of my raw spaces with mirroring.....Informix won't mirror these spaces or drop them.
onspaces -d space -p /opt/informix/disk_links/t_l29_pool1 -o 0 -y
Chunk not dropped.
ISAM error: No such chunk
The other one is a different offset in the same file. I cannot drop it from HQ or AGS either....those give an ISAM 22 error.
oncheck -pe space
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
20 /opt/informix/disk_links/t_l20_space 2 1024000 868803 155197
Description Offset(p) Size(p) Partnum Ext Num
------------------------------------------------------------- -------- -------- ---------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
achdbs1:'informix'.TBLSpace 3 50 0x01400001 1
tba:'informix'.table1 53 512 0x01400002 1
tba:'informix'.table2 565 372656 0x01400003 1
....
....
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
36 /opt/informix/disk_links/t_l29_pool1 2 102400 3 102397
Description Offset(p) Size(p) Partnum Ext Num
------------------------------------------------------------- -------- -------- ---------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
FREE 3 102397
Anyone ever encountered something similar? I do see "CHUNK FREELIST PAGE" in there rather than just "FREE", but I don't know if that makes a difference. I need these two spaces to go away.
This is 14.10.FC7
Update ---
I got one of them to drop with:
execute function admin( 'drop chunk to storagepool', 'space', '/opt/informix/disk_links/t_l29_pool1', '716800' )
Which AGS magically output when I told it to drop it and return it to the storage pool. The other space won't drop. AGS gives errors with both drop options....ISAM 22 with drop, ISAM 191 with drop and return to storage pool
------------------------------
Jared Heath
------------------------------