Sybase 12.4.2 manual Setting a maximum Catalog page size

	CHAPTER 2 Running Adaptive Server IQ
	• UTILITY_DB—Only those users who can connect to the utility_db database
	can create and drop databases. See “The utility database” on page 18 for
	information.
Stopping the server	The -gkoption limits the users who can shut down a server to those with a
	certain level of permission in the database.
	• DBA (default) —Only the DBA can stop the server.
	• ALL (default)—Any user can stop the server.
	• NONE—No user can shut down the server with the STOP ENGINE
	command.

Setting a maximum Catalog page size

The database server cache is arranged in pages, which are fixed-size areas of memory. Since 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 1024, 2048, or 4096 bytes.

Every database page must fit into a cache page.

You use the -gpoption to set the Catalog page size explicitly. By setting -gpto the maximum size, 4096, you maximize the number of columns per table that Adaptive Server 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 -gpoption 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 , an attempt to load a database file with a Catalog page size larger than the databases started on the command line will fail.

If you use larger page sizes, remember to increase your cache size. A cache of the same size will accommodate only a fraction of the number of the larger pages, leaving less flexibility in arranging the space.

Note The -gpoption and the page sizes listed here apply to the Catalog Store only. You set the page size for the IQ Store in the IQ PAGE SIZE parameter of the CREATE DATABASE command. See “Choosing an IQ page size” for more information.

37