catch.saravana
Member
Progress Version: 11.6
Let's take an example,
1. I have an AREA with variable extent
2. I created couple of tables say 't1' (250MB size) and 't2' (350 MB size)
3. Take a backup of the db
4. Delete the table 't1'
5. Free chain analysis says '888 block(s) found in the free chain.'. Backup size remains the same as that of initial backup.
6. Add a new table 't4' (150 MB size)
7. Free chain analysis says '320 block(s) found in the free chain.'. Backup size remains the same as that of initial backup.
Does progress only reuses the space like step 7? Or is there a way we can make progress to deallocate (on step5) the extents that were created as part of step 2 (meaning like db backup size gets reduced when tables are deleted)?
Let's take an example,
1. I have an AREA with variable extent
2. I created couple of tables say 't1' (250MB size) and 't2' (350 MB size)
3. Take a backup of the db
4. Delete the table 't1'
5. Free chain analysis says '888 block(s) found in the free chain.'. Backup size remains the same as that of initial backup.
6. Add a new table 't4' (150 MB size)
7. Free chain analysis says '320 block(s) found in the free chain.'. Backup size remains the same as that of initial backup.
Does progress only reuses the space like step 7? Or is there a way we can make progress to deallocate (on step5) the extents that were created as part of step 2 (meaning like db backup size gets reduced when tables are deleted)?