OBJECTCONNECT_INFO view

The OBJECTCONNECT_INFO view returns information about the ObjectConnect over IP server.

This view will only return data if Option 22 of the IBM® i operating system is installed.

Authorization: None required.

The following table describes the columns in the view. The system name is OBJC_INFO. The schema is QSYS2.

Table 1. OBJECTCONNECT_INFO view
Column Name	System Column Name	Data Type	Description
STATE	STATE	VARCHAR(8)	The state of the ObjectConnect over IP server. ACTIVE The ObjectConnect over IP server is active. INACTIVE The ObjectConnect over IP server is not active.
AUTO_START	AUTO_START	VARCHAR(3)	Whether the ObjectConnect over IP server is started automatically. NO The ObjectConnect over IP server is not started automatically. YES The ObjectConnect over IP server is started automatically.
MINIMUM_JOBS	MIN_JOBS	INTEGER	The minimum number of server jobs.
MAXIMUM_JOBS	MAX_JOBS	INTEGER	The maximum number of server jobs.
INACTIVE_TIME	INACT_TIME	INTEGER	The length of time, in minutes, a server job keeps inactive before the server job ends.
SEND_BUFFER	SND_BUF	INTEGER	The size of the TCP send buffer, in bytes, that the data connection will use to send data over the network.
RECEIVE_BUFFER	RCV_BUF	INTEGER	The size of the TCP receive buffer, in bytes, that the data connection will use to receive data from the network.
SUBSYSTEM_DESCRIPTION_ LIBRARY	SBSD_LIB	VARCHAR(10)	The library containing the subsystem description.
SUBSYSTEM_DESCRIPTION	SBSD	VARCHAR(10)	The subsystem in which the ObjectConnect servers run.
AUTHENTICATION_TYPE	AUTH_TYPE	VARCHAR(8)	The type of authentication that the ObjectConnect over IP server can use. ANY The ObjectConnect over IP server can use any of the supported authentication types to authenticate an incoming ObjectConnect connection request. KERBEROS The ObjectConnect over IP server can use Kerberos to authenticate an incoming ObjectConnect connection request. PASSWORD The ObjectConnect over IP server can use the user profile and password to authenticate an incoming ObjectConnect connection request.

Example

List information about the ObjectConnect over IP server.
```
SELECT * FROM QSYS2.OBJECTCONNECT_INFO;
```