Multiplex database files

Each server in the multiplex uses several files.

NoteSome of these files are only created automatically by Sybase Central.

Table 2-2: Contents of multiplex database directories

Folder, Directory, or Filename

Purpose

dbname.db

File that contains the catalog store. This cannot be a raw device.

dbname.iqmsg

File that contains messages from Sybase IQ

dbname.iqtmp

This is the IQ temporary store. This file exists only if the temporary file is added as an OS file. Raw devices are recommended for all files in the IQ temporary store.

dbname.log

File that contains the database transaction log. This cannot be a raw device.

dbname.lmp

License management property file. Creating a database generates this file automatically. Dropping a database deletes all database files except this one.

params.cfg

Contains startup parameters for this particular server. May be customized for performance or specific requirements. This file is only created automatically if you use Sybase Central. (If created by Sybase Central, params.cfg does not contain server name or tcpip parameters.)

start_server

Sybase Central generates these scripts. If you use Sybase Central to create the multiplex, they are generated automatically. You can also generate them using Sybase Central after you create the multiplex with Interactive SQL.

stop_server

sync_server

For more information about the administrative scripts, see “Using administrative shell scripts”.