Home | Previous Page | Next Page   Configuration > Installing and Configuring the Database Server > Starting and Administering the Database Server >

Configuring the Database Server Page Size

Use the PAGESIZE configuration parameter to set the database server page size. You can specify a page size of 2048, 4096, or 8192 bytes. For more information, see the chapter on configuration parameters in the IBM Informix: Administrator's Reference.

Steps for changing the page size
  1. Unload your data using a page-independent tool such as external tables, dbexport, or the SQL statement UNLOAD.
  2. Set the PAGESIZE value in the ONCONFIG file.
  3. Reinitialize the database server with the new page size set.
  4. Load your data back into the database.
  5. Perform a level-0 backup of the system.

For information on unloading and loading data, see the IBM Informix: Migration Guide. For information on how to use external tables to unload, see the chapter on loading with external tables in the IBM Informix: Administrator's Reference.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]