To run the Airline Reservations sample you require a database with two tables, one of which is populated with sample data as part of the setup. An ODBC definition for the database is also required and the broker must be configured with a user identifier and password to use when accessing the database.
Complete the following tasks to set up the database environment:
Follow the instructions that are relevant to your database manager:
Use the mqsisetdbparms command to specify a user identifier and password for the broker to use with the RESERVDB data source. This user identifier must be the same user identifier that you used when you created the database in the previous step. The user identifier determines the database schema name and the broker must use the same user identifier when accessing the table. For example, if your user identifier is USERID, the fully qualified name of the XMLFLIGHTTB table name is USERID.XMLFLIGHTTB.
mqsisetdbparms IB9NODE -n RESERVDB -u <user ID> -p <password>
mqsireload IB9NODE -e AirlineExecutionGroup