Whose Responsibility Is Fragmentation?

Some overlap exists between the responsibilities of the database server administrator and those of the database administrator (DBA) with respect to fragmentation. The DBA creates the database schema, which can include table fragmentation. The database server administrator, on the other hand, is responsible for allocating the disk space in which the fragmented tables will reside. Because neither of these responsibilities can be performed in isolation from the other, to implement fragmentation requires a cooperative effort between the DBA and the database server administrator. This manual describes only those tasks that the DBA performs to implement a fragmentation strategy. For information about the tasks the database server administrator performs to implement a fragmentation strategy, see your IBM Informix: Administrator's Guide and IBM Informix: Performance Guide.