Preallocating database space with gbak
From InterBase
Go Up to Creating incremental backups
GBAK backs up and restores database preallocation information. This preallocation information will be silently ignored by earlier versions of the product that are not aware of the feature. A switch has been added to -gbak to alter the stored preallocation in a database or backup file.
Example:
/D/testbed>isql Use CONNECT or CREATE DATABASE to specify a database SQL> create database 'pr.ib' preallocate 500; SQL> commit; SQL> quit; /D/testbed>ls -l pr.ib -rwxrwxrwx 1 Administrators None 2048000 Jul 2 18:09 pr.ib /* It is 2MB size because each of the 500 database pages is 4KB in size */ /D/testbed>isql -a pr.ib SET SQL DIALECT 3; /* CREATE DATABASE 'pr.ib' PREALLOCATE 500 PAGE_SIZE 4096 */ /* Grant permissions for this database */ /D/testbed>isql -x pr.ib SET SQL DIALECT 3; /* CREATE DATABASE 'pr.ib' PREALLOCATE 500 PAGE_SIZE 4096 */ /* Grant permissions for this database */ /D/testbed>