Command Line Switches

Command line switches are used to define your Sybase IQ environment.

For a complete list of command line switches and full reference information on them, see Utility Guide > start_iq Database Server Startup Utility.

Some of the values you can set with command line options can also be changed with the SET OPTION command. See Reference: Statements and Options > Database Options and Reference: Statements and Options > SET OPTION Statement.

• Displaying Command Line Options
  Command line switches are case sensitive.
• Configuration Files
  Sets of command line switches can be stored in configuration files.
• Command Line Example Formatting in Sybase IQ Documentation
  For clarity, examples throughout Sybase IQ documentation show multiple command line switches on separate lines as they could be written in a configuration file.
• Required Command Line Options
  Not all command line switches are optional.
• Default Configuration File
  The default configuration file (default.cfg) contains all of the required switches.
• Configuration File for the Demo Database
  The iqdemo.cfg file, which you use to start the demo database, sets startup switches to the recommended defaults.
• Naming Restrictions
  Do not use hyphenated names or reserved words for database names, user identifiers or server names, even enclosed in quotation marks.
• Server and Database Names
  Use the -n command line switch as a server switch (to name the server). This prevents you from unintentionally connecting to the wrong server.
• Command-line Options for Performance
  Several command line options can affect database server performance.
• Command Line Options that Control Permissions
  Some command line options control the permissions required to carry out certain global operations.
• Maximum Catalog Page Size
  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.
• Client/Server Environment Options
  Three options can help you set up your client/server environment.
• Forced Recovery Mode Options
  Should you need to restart your server after a failure, you can usually do so using the same startup options as usual.
• Starting a Server from Interactive SQL
  If you are already connected to a running database server, you can start a new server from Interactive SQL.
• Shared Memory Conflicts
  In a production environment, it would be unusual to have more than one server running on the same system, and Sybase strongly recommends against doing this. In a development environment, however, this situation can occur.