Name Type MSSql Type Oracle Type DB2 Nullable Description
MQSRV_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) false server name
MQSRV_System varchar (8) VARCHAR2 (8 CHAR) varchar(8) false system name
MQSRV_TcpIpAddr varchar (64) VARCHAR2 (64 CHAR) varchar(64) false IP address
MQSRV_TcpIpPort int NUMBER(38,0) int false IP port number
MQSRV_Type int NUMBER(38,0) int false type (1=CP, 2=WP, 4=PWP, 8=Agent, 16=JWP, 32=JCP)
MQSRV_StartTime datetime DATE timestamp true start date
MQSRV_LastUpdate datetime DATE timestamp true last update
MQSRV_TcpIpAddr2 varchar (64) VARCHAR2 (64 CHAR) varchar(64) true local IP address
MQSRV_NetArea varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Group CPs by this term
MQSRV_MQSet char (1) CHAR (1 CHAR) char(1) true 1 for new MQ1* and 2 for new MQ2*
MQSRV_RestEndpoint varchar (128) VARCHAR2 (128 CHAR) varchar(128) true Url of JCP Endpoint in format protocol://hostname:port/api
MQSRV_ConnCnt int NUMBER(38,0) int true Connection count

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_MQSRV MQSRV_Name true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File