Articles & Content


Less dbspaces, More Fragments. Fragmentation enhancements (K08)

Topic: 2006 NA

Subtopic: Informix

DATE: 2006-05-10 (08:30 AM - 09:40 AM)
SPEAKERS: Nelson Corcoran (IBM)

You know it, you love it and now, we have enhanced it. Traditional IDS fragmentation required each fragment of a table or an index in separate fragments.Large chunks and dbspaces feature in IDS made it possible to have multiple large fragments within a single dbspace. IDS 10.00 has enhanced the all aspects of fragmentation scheme to organize your tables and indices in fewer dbspaces.

EXP. LEVEL: Intermediate,Advanced


Traditional fragmentation

New table & index fragmentation

fragment modification using alter

upgrade cases

Output changes in utilities

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.