Task B Creating a Database

Depending on your environment, you might have to ask your database administrator to create a database or use an existing database. For example, for MySql database server, you can create a local database for your testing purposes.

For production environments using Oracle, DB2 and MS SQL Server database server, ask your database administrator to create a database such as asgstat for the Central Logger component of TIBCO API Exchange Gateway.

This section lists the steps to create a database for testing purposes using MySql database server. You must contact your database administrator to use appropriate database for production requirements.

Procedure

  1. Verify that the MySql database server is running.
  2. Log on to the database server using the command: 
       mysql -uroot -p
  3. Enter the password when prompted. 
       Enter password:
  4. Type the following command at the mysql command prompt to create a new database: 
       create database asgstat;
  5. Verify that the asgstat database is created.
    Note:
    • Refer to http://dev.mysql.com/doc/refman/5.5/en/creating-database.html link for more information.