You need a database with two tables and an ODBC definition to run the DatabaseInput Node sample. To access the database the broker must be configured with a user identifier and password.
Complete the following tasks to setup the database tables:
Follow the instructions that are relevant to your database manager:
Complete the following tasks to setup the database environment for the broker:
For instructions, see Enabling ODBC connections to the databases in the WebSphere Message Broker documentation.
Use the mqsisetdbparms command to specify a user identifier and password that the broker can use with the DBINPUT 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 CUSTOMER table name is USERID.CUSTOMER.
mqsisetdbparms MB8BROKER -n DBINPUT -u <user ID> -p <password>
mqsireload MB8BROKER -e DatabaseInput