Cleaning up the database

When you have finished with the DatabaseInput Node sample, you can remove the database, its ODBC definition, and the user identifier and password values that are associated with the data source name.

Complete the following tasks to clean up the database environment:

1. Remove the database and ODBC definition.

   Follow the instructions that are relevant to your database manager:

   • Cleaning up DB2
   • Cleaning up Oracle
   
   
2. Remove the user identifier and password that are associated with the data source name DBINPUT.

   Open a command console window in which you can run IBM Integration Bus commands. Enter the following command to remove the user identifier and password.

   mqsisetdbparms IB9NODE -n DBINPUT -d

Back to sample home