5/5/2023 0 Comments Informix dbschema functionIndex 100_1 fragment partition datadbs1 in DBspace datadbs1Ī good starting place for reorganization would be any object with 50 or more extents. Logical Page Physical Page Size Physical Pages Prior to defragment: oncheck -pt bjsdb:data You can use the following query to determine the number of extents for your tables and indexes: database sysmaster Īlternatively, to see the fragments for a given table, you can run oncheck –pt database:table, as shown below. There is now a sysadmin function that allows you to defragment a table or index in the same way you might defrag a disk in Windows. ![]() This often results in tables getting out of hand because there is no convenient time to reorganize. Prior to Informix 11.70, reorganizing a table required exclusive access and meant a disruption to service. ![]() In a blog post that I wrote a couple of years ago, “ Informix Extents: Sizing and Performance“, I explained the importance of managing the number of extents allocated to tables and indexes. ![]() Do you have large tables that contain too many extents but haven’t been able to schedule a maintenance window to reorganize? With the release of Informix 11.70, IBM introduced a new defragmentation utility that lets you reorganize a table or index online while the table is in use.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |