The database server cache is arranged in pages, which are fixed-size areas of memory. Because the server uses a single cache for the catalog store until it is shut down, all catalog pages must have the same size.
A catalog file is also arranged in pages, of size 4096, 8192, 16384, or 32768 bytes. Every database page must fit into a cache page.
Use the -gp option to set the catalog page size explicitly. By setting -gp to the maximum size, 32768, you maximize the number of columns per table that SAP Sybase IQ can support.
By default, the server page size is the same as the largest page size of the databases on the command line. The -gp option overrides this default. Once the server starts, you cannot load a database with a larger catalog page size than the server. Unless you specify -gp, you cannot load a database file with a catalog page size larger than the databases started on the command line.
If you use larger page sizes, increase your cache size. A cache of the same size accommodates only a fraction of the number of the larger pages, leaving less flexibility in arranging the space.