Command Line Switches

Command line switches define your SAP Sybase IQ environment.

For a complete list of command line switches and full reference information, 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.

• Displaying Command Line Options
  Command line switches are case sensitive.
• Configuration Files
  You can store sets of command line switches in configuration files.
• Command Line Example Formatting in SAP Sybase IQ Documentation
  For clarity, examples throughout SAP Sybase IQ documentation show multiple command line switches on separate lines as you can write them 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 startup 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 Privileges
  The database server start-up command start_iq includes options that set the privilege level of some database and server functions.
• 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
  The -x (communication protocol), -tl (network connection timeout), and -ti (client connection timeout) options can help you set up your client/server environment.
• Forced Recovery Mode Options
  After a failure, restart your server with your usual startup options. On rare occasions, you may need to supply startup options to force recovery or to recover leaked storage.
• 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 SAP Sybase strongly recommends against it. In a development environment, however, this situation can occur.