IBM Support

Adding JDBC properties for a database connection in Data Server Manager (DSM)

Question & Answer


Question

How to add JDBC properties for a database connection in Data Server Manager (DSM)?

Cause

There is a need to add additional JDBC properties to a database connection in DSM, for example, add tracing information.

Answer

Here are the steps to add the additional JDBC properties to a database connection in DSM:
1. From the menu on the left side, select Settings --> Manage Connections.
2. The Database Connection tab is shown
3. Select the database to add the additional JDBC properties
4. Click on Edit button
5. Select the Advanced JDBC properties tab
6. Enter the JDBC property and the its value
7. Click on Add buttion
8. Test the connection (optional)
9. Click OK button to save the database connection

[{"Product":{"code":"SS5Q8A","label":"IBM Data Server Manager"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"}],"Version":"1.1.1;1.1;1.1.2;2.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21989378