Preparing Oracle or Sybase databases on UNIX platforms

If you are creating an Oracle or Sybase database on a UNIX platform, you must complete setup tasks before you create the database. You are recommended to complete this setup after you have installed your database, but you can complete it before database installation if you correctly specify the intended database installation directory during this setup.

You do not have to complete this task if your database is on Windows.

  1. Issue the following command:
    mqsi_setupdatabase database_type <database_install_directory>

    where database_type is oracle9 or sybase12_5 and <database_install_directory> is the directory in which the database is (or will be) installed.

  2. You can now create the broker database. Refer to Oracle or Sybase documentation for information on how to do this.

When you issue the command that creates the broker, tables are created within the database to hold the information required.

If you are creating a Sybase database for your broker, and you deploy message flows that use aggregation, you are recommended to apply row-level locking to the aggregate table in the database. See Using aggregation with a Sybase database.

If you are creating a Sybase database for your broker, and you expect heavy use of retained publications with multiple topics, you are recommended to apply row-level locking to the retained publications table in the database. See Using retained publications with a Sybase database.

Related concepts
Message flow aggregation

Related tasks
Creating the databases
Using aggregation with a Sybase database
Using retained publications with a Sybase database

Related reference
Supported databases