drop Compressed tables / dictionary
Hi,
IDS 11.50 UC6 - Linux OpenSuse 11.2
- I have here in a test environment, one table compressed.
- My sysadmin database reside on the "admin" dbspace...
I need reuse the "admin" dbspace chunks to execute others tests (low disk
space), so then I moved the sysadmin to rootdbs with the task('reset
sysadmin...)
But I still not able to drop the 'admin' dbspace because the compression
dictionary still into the dbspace.
the oncheck -pe admin return this:
DBspace Usage Report: admin Owner: informix Created: 05/08/2010
Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p)
25 /ifmxdados/L_admin.ch1 8 250000 292 249708
Description Offset(p) Size(p)
------------------------------------------------------------- -------- --------
RESERVED PAGES 0 2
CHUNK FREELIST PAGE 2 1
admin:'informix'.TBLSpace 3 50
FREE 53 208
admin:'informix'.TBLSpace 261 50
FREE 311 424
admin:'informix'.TBLSpace 735 50
FREE 785 4592
admin:'informix'.rsccompdict 5377 8
admin:'informix'.rsccompdict 5385 8
FREE 5393 10096
sysadmin:'informix'.aus_work_icols_idx1 15489 4
FREE 15493 21120
admin:'informix'.rsccompdict 36613 20
FREE 36633 1892
admin:'informix'.rsccompdict 38525 24
FREE Comment: The index sysadmin:'informix'.aus_work_icols_idx1 38549 134140
admin:'informix'.rsccompdict 172689 32
FREE 172721 77236
admin:'informix'.TBLSpace 249957 43
Total Used: 292
Total Free: 249708
First question. Is there some way to move the dictionary to other dbspace ?
Trying to quickly solve this I drop the table compressed.. but the dictionary
don't dropped together... If I try to purge_dictionary now, it says :
22:24:59 SCHAPI ERROR:myfs_db:informix.fs_full_new-No such table
22:24:59 SCHAPI ERROR: table purge_dictionary myfs_db:informix.fs_full_new
failed
So, to delete a compressed table... I need to uncompress/purge before???
Or I missing something here???
Just a note, I already try to purge the dictionary using the partnum (get in
the syscompdicts) and they keep saying "No such table"...
Other note, I don't know why the sysadmin:'informix'.aus_work_icols_idx1 keep
into this dbspace.. once I already dropped sysadmin and it still exists there..
Regards
César