You do not have to complete this task if your database is on Windows or Linux.
mqsi_setupdatabase database_type <database_install_directory>
where database_type is db2, oracle9, or sybase12_5 and <database_install_directory> is the directory in which the database is (or will be) installed (for example, /usr/lpp/db2_07_01).
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 DB2 or 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 DB2 database or 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.