Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 57 / 536

CHAPTER 2 Running Adaptive Server IQ
37
•
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
-gk
option 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
-gp
option to set the Catalog page size explicitly. By setting
-gp
to
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
-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
, 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
-gp
option 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.