Preparing databases on UNIX systems

Start of changeIf you are creating an Oracle database on a UNIX system, you must complete the following extra setup tasks before you create the database.End of change 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.

Start of changeUnless your database is Oracle, you do not have to complete this task..End of change

Issue the following command:
mqsi_setupdatabase database_type <database_install_directory>

Start of changewhere database_type is oracle9, or oracle10, and <database_install_directory> is the directory in which the database is (or will be) installed.End of change

You can now create the broker database. For DB2, see Creating a DB2 database on Windows or Creating a DB2 database on Linux and UNIX systems. For Oracle and Sybase, refer to the database product documentation for information about 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 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.

If you are using Sybase on AIX, ensure that you run the Sybase profile before the mqsiprofile.

Related concepts
Message flow aggregation
Related tasks
Creating a DB2 database on Windows
Creating a DB2 database on Linux and UNIX systems
Using retained publications with a Sybase database
Related reference
Supported databases