Running database setup scripts
Configure a broker to access databases from deployed message flows by customizing the command environment.
When you install a database product the relevant settings might be made to the system environment (typical for Windows systems). However, some database managers provide a profile to perform this setup, or provide details of actions that you must take. Always check the database product documentation for environment setup details; the information that is provided here is for general guidance only.
If a profile is provided for the database that you are using, complete
the following steps:
- If you can update the profile to provide permanent values for
the details that are required (for example, the
database server name or the installation directory):
- Complete the changes to the database profile.
- Copy the profile file to the following directory:
- On Windows: work_path\Common\profiles
- On Linux® and UNIX: work_path/common/profiles
where work_path is the machine-wide IBM® Integration Bus working directory.Note: To verify the machine-wide IBM Integration Bus working directory, enter the following command in a command console:echo %MQSI_WORKPATH%
- If you cannot update the profile permanently, but need to make changes each time, you must run it independently of the mqsiprofile command before you start the component.