Is there a problem with a database?

If you have database problems, complete a set of initial checks to identify errors.

Procedure

  • Check that the database is started.
  • Check that you have correctly completed ODBC configuration:
    • Linux platformUNIX platformOn Linux® and UNIX systems, check that you have created a copy of the sample ODBC configuration file (odbc.ini), and have modified them for your environment, and that you have not added any extra unsupported parameters.
    • Windows platformOn Windows systems, click Start > Control Panel > Administrative Tools > Data Sources (ODBC) to configure the connections you require.

    Detailed instructions for setting up ODBC connections on distributed systems are provided in Enabling ODBC connections to the databases.

  • Use the mqsicvp command to help you with ODBC database diagnostics.
  • Check that you have correctly completed JDBC configuration.
    Detailed instructions for setting up JDBC connections are provided in Enabling JDBC connections to the databases.
  • Check the number of database connections that are in use on IBM® DB2® for AIX®. If you use local mode connections, a maximum of 10 is supported.
  • If messages that indicate that imbdfdb2v6.lil failed to load, check that you have installed a supported database.
    Details of supported databases are given in IBM Integration Bus system requirements.