How do you use this feature and why would you want to?
Ajaykumar Gupte answers these questions in a new developerWorks article entitled Flexible fragmentation strategy in Informix Dynamic Server 10.0. He describes how IDS 10.0 overcomes the following limitations in earlier releases:
- Having to add a new dbspace for every new fragment expression.The overhead of monitoring a large number of dbspaces.Limited chunks per dbspace.Fixed page size for all dbspaces.
The article follows an example which includes a look at the sysfragments sysmaster table, sqexplain analysis and fragmentation strategy guidelines.