Direct DRDA Connection properties

Direct DRDA Connection properties define how the connection to a particular data source is established. You can specify Direct DRDA Connection properties in the Advanced JDBC Settings window.

The Direct DRDA Connection has the following properties:

Parameters

securityMechanism
This property specifies the Direct DRDA Connection security mechanism. The data type of this property is integer. Possible values are:
  • SECMEC.I_USRIDPWD = 3

    Neither user ID nor password is encrypted.

  • SECMEC.I_EUSRIDPWD = 9

    Both user ID and password are encrypted.

  • SECMEC.I_EUSRPWDDTA = 13

    The user ID, Password, and Data are encrypted.

If you do not specify a value for securityMechanism, the requester attempts to connect using the security mechanism without any encryption.

If the server accepts only encrypted login information, the requester attempts to switch to the corresponding security mechanism.

If a connection cannot be established because the server does not support that security mechanism, an exception is thrown.

sslConnection
This property specifies whether the use of SSL certificates is enabled for the current connection. The data type of this property is string. Possible values are:
true
Specifies that the use of SSL certificates is enabled.
false
Specifies that the use of SSL certificates is disabled.
sslTrustStoreLocation
This property specifies the path to the truststore file that is used for the connection. The data type of this property is string. The value must contain a path to the truststore file.
sslTrustStorePassword
This property specifies the password to the truststore file that is used for the connection. The data type of this property is string. The value must contain a password to the truststore file.
enableBidiLayoutTransformation
This property specifies the way the Direct DRDA Connection processes bidirectional data. Enabling this property allows QMF DRDA driver to correctly handle the data entered in a language with the right-to-left writing system (such as Arabic) that is stored in visual order. If the data is stored in logical order, enabling this option will result in incorrect data output.
true
The enableBidiLayoutTransformation property is enabled.
false
The enableBidiLayoutTransformation property is disabled.
Note: If the enableBidiLayoutTransformation option is enabled, users cannot insert, edit, or delete any data in the database. Also, with the enableBidiLayoutTransformation option enabled, the driver is configured to handle BiDi data on the server machine and on the client machine differently. See the following table for detailsSee the table in the Db2 Type 4 UDB JDBC driver parameters for bidirectional layout transformations procedure for details. For the server machine, see the row that corresponds with value 4. For the client machine, see the row that corresponds with value 5.