Multiplex Creation

Convert a single Sybase IQ server into a multiplex.

1. Set up the main store and hardware to meet requirements.
2. Convert databases to multiplex.

• Multiplex Storage Requirements
  Create multiplex stores on the appropriate device.
• Main Store Requirements
  Make sure that your main store meets prerequisites for multiplex operation.
• Hardware Requirements
  A Sybase IQ multiplex requires shared storage for data on IQ_SYSTEM_MAIN, IQ_SHARED_TEMP, and user dbspaces.
• Java External Environment in a Multiplex
  Before you can use Java external environment UDFs in a multiplex configuration, install the Java class file or JAR files on each node of the multiplex that requires the UDF.
• Multiplex Planning Worksheet
  Before creating a multiplex, check that the paths of proposed objects meet requirements.
• Converting Databases to Multiplex
  Use Sybase Central, Sybase® Control Center, or Interactive SQL to create multiplex servers.
• Multiplex Database Files
  Each server in the multiplex uses several files to store data, metadata, and configuration information.