Question & Answer
Question
Answer
- 1. What database versions are supported by ACE?
- 2. What JDBC drivers are supported with my database?
- 3. How do I connect to a remote database ? Do I need a database client installation on my ACE machine?
- 4. How do I configure database connectivity from App Connect Enterprise?
- 5. How do I configure for global co-ordination (XA) for my database?
- 6. Is there a way to configure connection pooling for database connections made by ACE?
- 7. Where can I download database drivers? Can I download drivers from DataDirect and use them?
- 8. How do I configure credentials for database access? Is it possible to configure username and password for database access by default?
- 9. How do I invoke stored procedures from a Message flow?
- 10. How do I map database content in a Mapping node?
- 11. Can database calls be optimized in ACE?
- 12. Are there any additional steps required for migration between versions?
- 13. What database credential did I configure for database access?
- 14. How can I view JDBC provider configurable service properties?
- 15. Is there a way to validate an ODBC configuration?
- 16. Does ACE report database SQL exceptions if an error occurs?
- 17. Is there a database connection idle time? Can this be tuned?
- 18. Is the IE02 SupportPac required for database connectivtiy?
- 19. How do I capture ODBC / JDBC traces in ACE?
- 20. Are there any additional references that may help me with ACE connectivity with the application databases?
1. What database versions are supported by ACE?
Supported databases and versions are listed in the system requirements for each product.
You can find a list of links to the system requirements for each version of ACE, here:
Detailed System Requirements for IBM App Connect Enterprise, IBM Integration Bus, and WebSphere Message Broker
2. What JDBC drivers are supported with my database ?
App Connect Enterprise does not ship with JDBC drivers.
Users must ensure that their JDBC driver is compatible with their backend database.
3. How do I connect to a remote database ? Do I need a database client installation on my ACE machine ?
To connect to a remote DB2 or Informix database via ODBC, ACE requires a local database client.
Starting in ACE 11.0.0.11, a modified DB2 client is provided with the ACE installation on Linux and Unix systems.
See: Explore the new features in App Connect Enterprise version 11.0.0.11
4. How do I configure database connectivity from App Connect Enterprise?
App Connect Enterprise supports ODBC and JDBC connectivity to databases.
More information can be found in the product documentation:
5. How do I configure for global co-ordination (XA) for my database?
Please see the below information center pages for general global co-ordination configuration.- ACE Documentation: Configuring global coordination of transactions (two-phase commit)
- IIB Documentation: Configuring global coordination of transactions (two-phase commit)
6. Is there a way to configure connection pooling for database connections made by ACE?
- ACE Documentation: Using a JDBC connection pool to manage database resources used by an integration server
- IIB Documentation: Using a JDBC connection pool to manage database resources used by an integration server
7. Where can I download database drivers? Can I download drivers from DataDirect and use them?
ACE ships some ODBC drivers with the product. These drivers are fully tested with ACE and supported.For ODBC connectivity to other databases, an ODBC driver must be supplied (for example, for DB2).
IBM will provide best-effort support for the product when using a user-supplied driver.
App Connect Enterprise does not ship with JDBC drivers.
Users must ensure that their JDBC driver is compatible with their backend database.
8. How do I configure credentials for database access? Is it possible to configure username and password for database access by default ?
Credentials for database connections must be configured.Credentials can be store using mqsisetdbparms or mqsicredentials (ACE versions only) commands.
- ACE Documentation: Securing database connections
- IIB Documentation: Securing database connections
It is possible to set default credentials for ODBC or JDBC connections under an Integration Node or Integration Server.
These can be overridden at the Integration Server level or for individual datasource connections.
9. How do I invoke stored procedures from a Message flow?
We also provide a capability scenario for this use case:
10. How do I map database content in a Mapping node ?
- ACE Documentation: Mapping database content
- IIB Documentation: Mapping database content
11. Can database calls be optimized in ACE?
When a database call is made from within an ESQL Compute node, the flow constructs the appropriate SQL, which is sent to the database manager. As part of this process, the SQL statement is prepared using the SQLPrepare function, and a statement handle is acquired so that the SQL statement can be executed.
This causes every SQL statement to require the SQLPrepare function.
12. Are there any additional steps required for migration between versions?
- ACE Documentation: Configuring a database to be available at run time
- IIB Documentation: Setting up a JDBC provider for type 4 connections
13. What database credential did I configure for database access?
Security Identities configured with the mqsisetdbparms command can be queried with the mqsireportdbparms command:
For credentials stored in the vault, the mqsicredentials command has a report feature:
- ACE Documentation: Have you recently changed a password?
- IIB Documentation: Have you recently changed a password?
- ACE Documentation: mqsicredentials command
14. How can I view JDBC provider configurable service properties?
In ACE, JDBC provider policies replace configurable services.
View provider properties from the *.policyxml file within its policy project.
In IIB, display all configured JDBC providers for a single Integration Node with this command:
mqsireportproperties MY_NODE -c JDBCProviders -o AllReportableEntityNames -r
15. Is there a way to validate an ODBC configuration?
Use the command 'mqsicvp' to test and validate an ODBC configuration:
mqsicvp -n primaryDatasourcename -u primaryDatasourceUserId -p primaryDatasourcePassword
mqsicvp MY_NODE -n primaryDatasourcename
16. Does ACE report database SQL exceptions if an error occurs?
17. Is there a database connection idle time? Can this be tuned?
- Database connections associated with an additional instance of a flow persist for the life of the flow thread.
- Database connections associated with the main instance of a flow have a default timeout of 60 seconds.
- The default timeout can be tuned with the parameter 'maxConnectionAge'.
- ACE Documentation: Database connections
- IIB Documentation: Database connections
18. Is the IE02 SupportPac required for database connectivity?
From WMB V8 onwards, IE02 is required for an Integration Server to establish ODBC connectivity with all supported databases.
IE02 is installed automatically as part of the product installation.
19. How do I capture ODBC / JDBC traces in IIB?
Index: App Connect Enterprise and IBM Integration Bus trace directions
20. Are there any additional references that may help me with IIB connectivity with the application databases?
Product Synonym
WMB MB WebSphere Message Broker IBM Integration Bus IIB IBMIB MQ Integrator WBIMB WBI-MB MQSI WMQI
Was this topic helpful?
Document Information
Modified date:
24 May 2022
UID
swg21649256