smart blob metadata space is not being released
Posted in 2014
IBM Informix Dynamic Server Version 11.70.FC5
We have a database where we keep one year's worth of transaction logs. The
data spaces are fragmented by month so on the first of each month I detach
last year's logs, drop the table and alter the fragment to catch this year's
logs:
Alter fragment on table incoming_log_archivedetach archive2 tb1;
drop table tb1;
Alter fragment on table incoming_log_archive
Add ((ia_received_time >= datetime(2014-02-01 00:00:00) year to second )
AND (ia_received_time < datetime(2014-03-01 00:00:00) year to second ) )
in archive2;
I suspected when I did the table drop metadata was not being released. Here
are pre and post onstat -d results trimmed down to just the sblob spaces. As
you can see dataspace is being release but metadata space remains unchanged.
The copied text doesn't post very well so I can email you the raw file if it
will help.
Has anyone else seen this and/or is the way to reclaim metadata space?
Pre-
address chunk/dbs offset size free bpages flags pathname
608f7828 23 23 0 5242880 262141 3649781 POSB-D /db4/arch_sbloba
Metadata 1593046 0 1593046
608f7a28 24 24 0 5242880 0 4439419 POSB-D /db4/arch_sblobb
Metadata 803408 0 803408
608f7c28 25 25 0 52428800 0 41783300 POSB-D /db4/arch_sblobc
Metadata 10645447 0 10645447
608f7e28 26 26 0 52428800 4027631 47037403 POSB-D /db4/arch_sblobd
Metadata 5391344 0 5391344
608f8028 27 23 0 52428800 0 41741270 POSB-D /db4/arch_sbloba_1
Metadata 10687527 0 10687527
608f8228 28 24 0 52428800 0 44394864 POSB-D /db4/arch_sblobb_1
Metadata 8033933 0 8033933
608f8428 29 26 0 52428800 0 44416010 POSB-D /db4/arch_sblobd_1
Metadata 8012787 0 8012787
61b40d78 34 24 0 26214400 0 0 POSB-D /db4/arch_sblobb_2
Metadata 26214397 19073823 26214397
63ae8650 35 25 0 26214400 2396617 24903677 POSB-D /db4/arch_sblobc_1
Metadata 1310720 0 1310720
614040b0 36 24 0 26214400 0 26129576 POSB-D /db4/arch_sblobb_3
Metadata 84821 84821 84821
6114ce20 40 23 0 26214400 5967643 19660797 POSB-D /db4/arch_sbloba_2
Metadata 6553600 3042944 6553600
63feddc8 41 25 0 10485760 0 0 POSB-D /db4/arch_sblobc_2
Metadata 10485757 4940791 10485757
62f73de8 42 26 0 26214400 0 0 POSB-D /db4/arch_sblobd_2
Metadata 26214397 21164921 26214397
86713308 43 26 0 26214400 11508421 26214397 POSB-D /db4/arch_sblobd_3
63804c40 44 24 0 26214400 3283982 26129576 POSB-D /db4/arch_sblobb_4
Metadata 84821 84821 84821
Post-
address chunk/dbs offset size free bpages flags pathname
608f7828 23 23 0 5242880 262141 3649781 POSB-D /db4/arch_sbloba
Metadata 1593046 0 1593046
608f7a28 24 24 0 5242880 0 4439419 POSB-D /db4/arch_sblobb
Metadata 803408 0 803408
608f7c28 25 25 0 52428800 3287810 41783300 POSB-D /db4/arch_sblobc
Metadata 10645447 0 10645447
608f7e28 26 26 0 52428800 6228824 47037403 POSB-D /db4/arch_sblobd
Metadata 5391344 0 5391344
608f8028 27 23 0 52428800 3089664 41741270 POSB-D /db4/arch_sbloba_1
Metadata 10687527 0 10687527
608f8228 28 24 0 52428800 3975389 44394864 POSB-D /db4/arch_sblobb_1
Metadata 8033933 0 8033933
608f8428 29 26 0 52428800 3348601 44416010 POSB-D /db4/arch_sblobd_1
Metadata 8012787 0 8012787
61b40d78 34 24 0 26214400 0 0 POSB-D /db4/arch_sblobb_2
Metadata 26214397 19073823 26214397
63ae8650 35 25 0 26214400 2396617 24903677 POSB-D /db4/arch_sblobc_1
Metadata 1310720 0 1310720
614040b0 36 24 0 26214400 0 26129576 POSB-D /db4/arch_sblobb_3
Metadata 84821 84821 84821
6114ce20 40 23 0 26214400 5967643 19660797 POSB-D /db4/arch_sbloba_2
Metadata 6553600 3042944 6553600
63feddc8 41 25 0 10485760 0 0 POSB-D /db4/arch_sblobc_2
Metadata 10485757 4940791 10485757
62f73de8 42 26 0 26214400 0 0 POSB-D /db4/arch_sblobd_2
Metadata 26214397 21164921 26214397
86713308 43 26 0 26214400 11508421 26214397 POSB-D /db4/arch_sblobd_3
63804c40 44 24 0 26214400 3283982 26129576 POSB-D /db4/arch_sblobb_4
Metadata 84821 84821 84821