Parameter
dbs/db4/connect_type
Short text
Type of primary database connection.
Parameter Description
The parameter determines the connection type of the primary database connection to the ABAP schema. It only matters if application server and database server both use IBM i as an operating system. In all other cases, the connect type will be TCP/IP.
If the parameter is left blank, an appropriate setting is determined automatically. This setting is recommended.
If dbs/db4/driver_type == XDN, a local connect is chosen, whenever application server and database server reside on the same host, TCP/IP otherwise. SQL Cancel is always possible.
If dbs/db4/driver_type == XDA, parameter dbs/db4/allow_cancel == 1 will cause usage of Unix domain sockets if application server and database server reside on the same host, TCP/IP otherwise. If dbs/db4/allow_cancel == 0, a local connect is chosen.
If application server and database server do not reside on the same host, TCP/IP is chosen unless dbs/db4/opticonnect is set to ‘1’.
Setting this parameter explicitly works as a hint to the database driver:
dbs/db4/connect_type = ‘U’ tries to route over Unix domain sockets, whenever technically possible.
dbs/db4/connect_type = ‘T’ routes over TCP/IP sockets.
dbs/db4/connect_type = ‘O’ tries to route over Opticonnect. This does not work, if dbs/db4/driver_type == XDN. In this case, see SAP Note 1760552 for more information about how to route the TCP/IP protocol over Opticonnect. However, this is not recommended.
The final choice is logged in the developer trace:
Connect type = LOCAL | OPTICONNECT | TCPIP SOCKETS | UX-DOMAIN SOCKETS
For more information, see SAP Note 1257635.
Application Area
Database
Default Value
blank
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
Parameter overrules dbs/db4/allow_cancel, and dbs/db4/opticonnect.
Values allowed
blank — Automatic
L — Local (= application and database connection share the same process)
T — TCP/IP
U — Unix Domain Sockets
O — Opticonnect
