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>

Advance To: