Supplied databases (pack files)
These databases are provided with the installation program.
This topic describes the Rational Synergy
databases so that you can decide when to use them.
Informix database server dbspaces
The Rational Synergy
database uses the Informix® server
to store its metadata. The terms database server, online
server, Informix server, and online
Dynamic Server are used interchangeably in this information
center.
Informix services for Windows
In addition to services that are started automatically,
two other services are required. These are Informix services. Two Informix services are required per database
server installation: Informix Dynamic
Server and Informix Message.
Unpacking pack files to create databases
Rational Synergy
is shipped with a pack file called base.cpk, which
contains the standard development model and no user application data.
If you are using the standard base model, use the base.cpk pack
file to create new databases. You can unpack the base.cpk pack
file to another database name. A database can be stored in two formats:
standard and pack file. Pack files have the .cpk extension
and must be unpacked with the ccmdb unpack command
before they can be used.
Verifying file systems
Use the ccm fs_check command to verify
the file system portion of the database. Run this command weekly on
each database.
Dbspace chunk files
Chunk files are physical disk spaces used by dbspaces in Informix Dynamic servers. Each
dbspace must consist of at least one chunk file. After you have used
a chunk file in a database server, you cannot move it. If you move
it, the database server no longer functions. Consequently, the database
server might lose data.
Managing database server status and states
The database server administrator manages the creation, modification, and deletion of the database servers. These operations require the database be in one of the following states: online, offline, or quiescent.
Modifying database server parameter values
Use the ccmsrv modify command to modify
the number of users allowed on a database server. If you change the max_users option,
your database server requires more memory.
Deleting a database server
Use this procedure to remove a database server completely,
including its configuration file, the server entry in the sqlhosts file,
and any of the server chunk files that are not raw devices. This operation
removes the parameter file, the record of the specified server in
the sqlhosts registry entry, and all chunk files.
Increasing the database server dbspace
Informix allocates
space for its databases. You can increase the allocated dbspace capacity
by using the ccmsrv expand command. This command
expands the dbspace of an Informix server
by adding a chunk file. This method is useful when you want to increase
the size for a server that is running out of room in a dbspace.