Creating the Demo Database

Sybase IQ includes a demo database that includes sample data about a fictional company that sells athletic clothing. Scripts that create and load the demo database are installed as part of Sybase IQ Server Suite.

These instructions differ from those in the Installation and Configuration Guide. This task creates the demo database with an absolute path in a temporary directory named myiqdemo.

  1. Change to the $SYBASE directory.
  2. Create a subdirectory named myiqdemo.
    This is the temporary directory for the demo database. The full path to this directory is: .
    $SYBASE/myiqdemo
  3. Change to myiqdemo.
  4. Create a subdirectory named w1.
    This directory is used later for the multiplex conversion. The full path to this directory is:
    $SYBASE/myiqdemo/w1
  5. Enter:
    $IQDIR15/demo/mkiqdemo.sh -absolute

    The -absolute switch creates the demo database with an absolute path, which is required to convert the demo database to multiplex. For other options, enter:

    $IQDIR15/demo/mkiqdemo.sh -help
  6. Start the demo database:
    start_iq @iqdemo.cfg iqdemo.db