TSAM Plus Database Metadata

This chapter contains the following sections:

•	Tuxedo Configuration Information

•	Tuxedo Monitoring Information

•	TSAM Plus Management Information

Tuxedo Configuration Information

This section contains the following:

•

TUXDOMAIN

•

MACHINE

•

GROUPS

•

SERVER

•

SERVICE

•

LDOM

•

RDOM

•

ARTREGION

•	ARTTUXGROUP

•	ARTRESGROUP

•

ARTTRAN

•

IMS_TRANS

•

IMS_APPS

TUXDOMAIN

Tuxedo domain information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
NAME	VARCHAR2(255)	NO	Unique	11.1.1.1.0	The domain name to identify the domain. Its value is composed of: [Domain id]:[PMID of master machine]:[IPC key]
MASTER	VARCHAR2(255)	NO		11.1.1.1.0	LMID of master machine
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	The status of the Tuxedo domain: • ACT: Active • INA: Inactive • INV: Invalid, the node may not exist anymore.
TUXMODE	VARCHAR2(31)	YES		11.1.1.1.0	MODE parameter in UBB
TAG	NUMBER	NO		11.1.1.1.0	Internal used.
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

MACHINE

Tuxedo machine information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
TUXDOMAINID	NUMBER	NO	FK to TUXDOMAIN (ID)	11.1.1.1.0
NAME	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	PMID of the Tuxedo Machine
LMID	VARCHAR2(255)	NO		11.1.1.1.0	LMID of the Tuxedo Machine
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	The status of the Tuxedo machine: • ACT: Active • INA: Inactive • INV: Invalid, the node may not exist anymore.
TUXVERSION	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo version
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM Plus Agent version
HOSTNAME	VARCHAR2(255)	NO		11.1.1.1.0	Host name of the machine.
SERVERNAME	VARCHAR(1023)	YES		12.1.1.0	The host name of TSAM Plus manages to which the Tuxedo machine is connecting.
SERVERPORT	NUMBER	YES		12.1.1.0	The port of TSAM Plus manager to which the Tuxedo machine is connecting.
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved

GROUPS

Tuxedo group information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
MACHINEID	NUMBER	NO	FK to MACHINE (ID)	11.1.1.1.0
NAME	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Group name
TUXGRPID	NUMBER	NO		11.1.1.1.0	GRPNO parameter in the UBB.
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	The status of the Tuxedo machine: • ACT: Active • INA: Inactive • INV: Invalid, the node may not exist anymore.
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved

SERVER

Tuxedo server information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
GROUPID	NUMBER	NO	FK to GROUPS (ID)	11.1.1.1.0	GRPNO parameter in the UBB
NAME	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	AOUT parameter in UBB
TUXSVRID	NUMBER	NO		11.1.1.1.0	SRVID parameter in UBB
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	The status of the Tuxedo machine: • ACT: Active • INA: Inactive • INV: Invalid, the node may not exist anymore.
CLOPT	VARCHAR2(1023)	YES		11.1.1.2.0	CLOPT parameter in UBB
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

SERVICE

Tuxedo service information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
SERVERID	NUMBER	NO	FK to SERVER (ID)	11.1.1.1.0
NAME	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Service name
FUNCNAME	VARCHAR2(255)	YES		11.1.1.1.0	Function name
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	The status of the Tuxedo machine: • ACT: Active • INA: Inactive • INV: Invalid, the node may not exist anymore.
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

LDOM

Tuxedo local domain gateway information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
NAME	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	The name of this local domain access point.
LDOMID	VARCHAR2(255)	NO		11.1.1.1.0	The identifier of the domain gateway group associated with this local domain access point.
GROUPNAME	VARCHAR2(255)	NO		11.1.1.1.0	The group name of the domain gateway group representing this local domain access point.
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	The status of this local domain access point: VALid
TYPE	VARCHAR2(255)	YES		11.1.1.1.0	Always TDOMAIN
TUXDOMAINID	NUMBER	NO	FK to TUXDOMAIN (ID)	11.1.1.1.0
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

RDOM

Tuxedo remote domain gateway information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
NAME	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	The name of the remote domain access point
RDOMID	VARCHAR2(255)	YES		11.1.1.1.0	Reserved
LDOM	NUMBER	NO	FK to LDOM(ID)	11.1.1.1.0
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	The status of the remote domain access point: • ACTive • SUSpended • INItializing • INActive • UNKnown
TYPE	VARCHAR2(255)	YES		11.1.1.1.0	The type of domain: TDOMAIN
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

ARTREGION

Tuxedo application runtime for CICS region information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0	Region ID
TUXDOMAINID	NUMBER	NO	FK to TUXDOMAIN (ID)	11.1.1.1.0	Domain ID
NAME	VARCHAR2(255)	NO	Unique	11.1.1.1.0	Region name
STATUS	VARCHAR2(31)	YES		11.1.1.1.0	The status of the Region: • ACT: Active • INA: Inactive • INV: Invalid, the node may not exist anymore.
STARTTIME	TIMESTAMP	YES		11.1.1.1.0	Start time
SHUTDOWNTIME	TIMESTAMP	YES		11.1.1.1.0	Shutdown time
TRANCLASSESDESC	VARCHAR2(4000)	YES		12.1.1.0	The content of file tranclasses.desc
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

ARTTUXGROUP

Tuxedo application runtime for CICS region information

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
ARTREGIONID	NUMBER	NO	FK to ARTREGION (ID)	11.1.1.1.0
GROUPID	NUMBER	NO		11.1.1.1.0	Tuxedo Group ID
NAME	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo Group Name
STATUS	VARCHAR2(31)	YES		11.1.1.1.0	Reserved.
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

ARTRESGROUP

Tuxedo application runtime for CICS group information

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
ARTREGIONID	NUMBER	NO	FK to ARTREGION (ID)	11.1.1.1.0
NAME	VARCHAR2(255)	NO		11.1.1.1.0	Resource group name
STATUS	VARCHAR2(31)	YES		11.1.1.1.0	The status of the resource group: • ACT: Active • INA: Inactive • INV: Invalid, the node may not exist anymore.
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

ARTTRAN

Tuxedo application runtime for CICS transaction information

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
ARTRESGROUPID	NUMBER	NO	FK to ARTRESGROUP (ID)	11.1.1.1.0
NAME	VARCHAR2(255)	NO		11.1.1.1.0	Resource group name
STATUS	VARCHAR2(31)	YES		11.1.1.1.0	The status of the Region group: • ACT: Active • INA: Inactive • INV: Invalid, the node may not exist anymore.
TRANCLASS	VARCHAR2(255)	YES		12.1.1.0	The transaction class which this resource group belongs to.
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

IMS_TRANS

IMS transaction configuration

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
NAME	VARCHAR2 (255)	NO	PK	12.1.3	Transaction code
SPA_SIZE	NUMBER	YES		12.1.3	SPA size
RESPONSE	VARCHAR2 (255)	YES		12.1.3	Whether response is required for the transaction code specified in the "NAME" field. Its value is "Yes" or "No".
EDIT	VARCHAR2 (255)	YES		12.1.3	Whether the messages are converted to upper case automatically. Its value is "UC" or "ULC".
APPNAME	VARCHAR2 (255)	NO		12.1.3	The name of the COBOL application program that processes the transaction code specified in the "NAME" field.
CLASS	NUMBER	YES		12.1.3	The class of the transaction code. Its range is [1..999].
ATTRIBUTES	VARCHAR2(1023)	YES		12.1.3	Reserved.
TUXDOMAINID	NUMBER	NO	PK, FK to TUXDOMAIN (ID)	12.1.3	Domain ID

IMS_APPS

IMS application configuration

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
NAME	VARCHAR2 (255)	NO	PK	12.1.3	Application name
PGMTYPE	VARCHAR2 (255)	NO		12.1.3	For MPP, its value is "TP"; for BMP and BMPT, its value is "BATCH".
LANG	VARCHAR2 (255)	NO		12.1.3	For COBOL programs, its value is "COBOL"; for c programs, its value is "C".
ATTRIBUTES	VARCHAR2(1023)	YES		12.1.3	Reserved.
TUXDOMAINID	NUMBER	NO	PK, FK to TUXDOMAIN (ID)	12.1.3	Domain ID

Tuxedo Monitoring Information

This section contains the following:

•

POLICY

•	ALERT_DEFINITION

•

ALERT

•	MON_CPSEGMENT

•	MON_PAYLOAD

•

MON_XA

•	MON_SERVICE

•	MON_GWTDOMAIN

•	MON_GWTLINK

•	MON_BRIDGE

•	MON_BRGLINK

•

MON_GWWS

•	MON_ARTTCP

•	MON_JESJOB

•

MON_CLOB

•	MON_IMS_DETAIL

•	REPLAYDEFINITION

POLICY

Monitoring policy information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
TUXDOMAINID	NUMBER	NO	FK to TUXDOMAIN (ID)	11.1.1.1.0
NAME	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Policy name.
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	Policy status: • enabled • disabled
AGENTTYPE	VARCHAR2(255)	YES		11.1.1.1.0	Policy type: • tuxedo: Tuxedo monitoring policy. • art: Tuxedo application runtime for CICS monitoring policy.
CREATEDTIME	TIMESTAMP	NO		11.1.1.1.0	Create time
MODIFIEDTIME	TIMESTAMP	YES		11.1.1.1.0	Modify time
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	Reserved.
DEFINITION	VARCHAR2(4000)	YES		11.1.1.1.0	Policy definition in XML.
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

ALERT_DEFINITION

Monitoring alert policy definition.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
ARTREGIONID	NUMBER	YES		11.1.1.1.0	ART Region ID
NAME	VARCHAR2(255)	NO	UNIQUE	11.1.1.1.0	Alert definition name
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	Status: • enabled • disabled
SEVERITY	VARCHAR2(31)	NO		11.1.1.1.0	Alert definition severity: • information • warn • critical • fatal
TYPE	VARCHAR2(255)	NO		11.1.1.1.0	Alert definition type: • callpath • svc • xatran • gwtdomain • bridge • gwws • arttran • arttcp • jesjob • jesmetrics
AGENTTYPE	VARCHAR2(255)	YES		11.1.1.1.0	Alert definition agent type: • tuxedo • art • jes
EXPRESSION	VARCHAR2(4000)	YES		11.1.1.1.0	Alert definition expression
EXPRESSIONMODE	NUMBER	NO		11.1.1.1.0	Alert definition expression mode: • 0 (Metric Evaluation) • 1 (fml)
ACTION	VARCHAR2(255)	YES		11.1.1.1.0	Alert definition action. Null or a Tuxedo event broker name
RESFILTER	VARCHAR2(4000)	YES		11.1.1.1.0	Alert definition resource filter
RESFILTERMODE	NUMBER	NO		11.1.1.1.0	Alert definition resource filter mode: • 0 (Selection) • 1 (advance)
TUXEVENTNAME	VARCHAR2(255)	YES		11.1.1.1.0	The event name posted to the Oracle Tuxedo event broker. The event name is the alert name by default; you can also specify it manually.
CREATEDTIME	TIMESTAMP	YES		12.1.1.1	Alert definition created timestamp
MODIFIEDTIME	TIMESTAMP	YES		12.1.1.1	Alert definition modified timestamp
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.
INTERVAL	NUMBER	YES		11.1.1.1.0	Alert check interval

ALERT

Alert information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
ALERTDEFID	NUMBER	YES		11.1.1.1.0
NAME	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Alert definition name
DOMAIN	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo domain name
MACHINE	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo machine LMID
TUXGROUP	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo group number
PROCESSNAME	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo process name
SERVERID	NUMBER	YES		11.1.1.1.0	Tuxedo server ID
PID	NUMBER	YES		11.1.1.1.0	Tuxedo process ID
LOGTIME	TIMESTAMP	NO		11.1.1.1.0	The time an alert occurs.
CLEARTIME	TIMESTAMP	YES		11.1.1.1.0	The time an alert is cleared.
SEVERITY	VARCHAR2(31)	NO		11.1.1.1.0	Alert definition severity: • information • warn • critical • fatal
ALERTTYPE	VARCHAR2(31)	NO		11.1.1.1.0	Alert definition type: • callpath • svc • xatran • gwtdomain • bridge • gwws • arttran • arttcp • jesjob • jesmetrics • system
REASON	VARCHAR2(1023)	YES		11.1.1.1.0	The reason/cause for the alert.
STATUS	VARCHAR2(31)	NO		11.1.1.1.0	The status of an alert: • 0 (new) • 1 (cleared)
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM Plus agent version: • null (11g or above) • 1.1 (TSAM 1.1 and 10gR3)
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

MON_CPSEGMENT

Call path detail information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
CORRELATIONID	VARCHAR2(255)	NO	Indexed	11.1.1.1.0
DOMAIN	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo domain name
MACHINE	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo machine LMID
TUXGROUP	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo group number
PROCESSNAME	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo server process name
SERVERID	NUMBER	YES		11.1.1.1.0	Tuxedo server ID
PID	NUMBER	NO		11.1.1.1.0	Tuxedo server process ID
USERNAME	VARCHAR2(255)	YES		12.1.1.0	Tuxedo user name
DEPTH	NUMBER	YES		11.1.1.1.0	Call path depth
TARGETSVC	VARCHAR2(255)	YES		11.1.1.1.0	Target service
HOSTSVC	VARCHAR2(255)	YES		11.1.1.1.0	Host service
CPUTIME	NUMBER	YES		11.1.1.1.0	CPU time
SYSCPUTIME	NUMBER	YES		12.1.1.0	SYS CPU time
USRCPUTIME	NUMBER	YES		12.1.1.0	User CPU time
ELAPSETIME	NUMBER	YES		11.1.1.1.0	Elapse time
TOTALTIME	NUMBER	YES	Indexed	11.1.1.1.0	Total time
URCODE	NUMBER	YES		11.1.1.1.0	tpurcode
ERRNO	NUMBER	YES	Indexed	11.1.1.1.0	tperrno
STATUS	NUMBER	YES		11.1.1.1.0	Status: • null • 1
MSGTYPE	VARCHAR2(16)	YES		11.1.1.1.0	Message type: • ARP • ARQ
MSGSIZE	NUMBER	YES		11.1.1.1.0	Message size
MSGSTAGE	VARCHAR2(16)	YES		11.1.1.1.0	Message stage: • STMO • ME2NET • NET2ME • ME2Q • Q2ME • ME2QFAIL
MSGQUEUED	NUMBER	YES		11.1.1.1.0	Message queue length
LOCALGTRID	VARCHAR2(255)	YES	Indexed	11.1.1.1.0	Local GTRID
MSGID	VARCHAR2(255)	YES		11.1.1.1.0	Message ID
CALLMODE	NUMBER	YES		11.1.1.1.0	Call mode: • 1 (tpacall) • 2 (tpcall) • 3 (tpforward)
CALLFLAG	NUMBER	YES		11.1.1.1.0	Call flag
SVCSEQ	VARCHAR2(1023)	YES		11.1.1.1.0	Service sequence
PSVCSEQ	VARCHAR2(1023)	YES		11.1.1.1.0	Parent service sequence
IPCQID	VARCHAR2(64)	YES		11.1.1.1.0	IPC queue ID
LOGTIME	TIMESTAMP	YES		11.1.1.1.0	Log time
STARTTIME	TIMESTAMP	NO		11.1.1.1.0	Call start time
LASTTIME	TIMESTAMP	YES		11.1.1.1.0	Call last time
PROCTYPE	NUMBER	YES		11.1.1.1.0	Tuxedo Process type: • 0 (NCLIENT) • 1 (WCLIENT) • 2 (APPSERVER) • 3 (GWTDOMAIN) • 4 (BRIDGE) • 5 (GWWS) • 6 (WSH) • 7 (JSH) • 8 (ISH) • 9 (TMQUEUE) • 10 (TMQFORWARD)
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM agent version: • null (11g or above) • 1.1 (TSAM 1.1 and 10gR3)
CLTADDR	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo client address
LDOM	VARCHAR2(255)	YES		11.1.1.1.0	Ldom name: Ldom ID
RDOM	VARCHAR2(255)	YES		11.1.1.1.0	Rdom name: Rdom ID
MSGCVTTIME	NUMBER	YES		11.1.1.1.0	Message convert time
ATTRIBUTES	VARCHAR2(4000)	YES		11.1.1.1.0	Reserved.
EXTTYPE	VARCHAR2(255)	YES		12.1.1.0	Call path extended type
EXTSUBTYPE	VARCHAR2(255)	YES		12.1.1.0	Call path extended subtype
EXTSEQ	NUMBER	YES		12.1.1.0	Call path extended sequence
EXTCORRSEQ	NUMBER	YES		12.1.1.0	Call path extended parent sequence
ECID	VARCHAR2(1024)	YES		12.1.3	ECID (Execution Context ID)
MSGTAG	VARCHAR2(4000)	YES		12.1.3 RP006	Message Tag
MD5	VARCHAR(40)	YES		12.1.3 RP008	MD5 in MON_CLOB_CP
MD5_DTL	VARCHAR(40)	YES		12.1.3 RP008	MD5 in MON_CLOB_CPDTL

MON_PAYLOAD

User payload data.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO		12.2.2	auto-generated ID
DOMAINID	VARCHAR2(30)	yes		12.2.2	Domain ID, it is null when no DOMAINID is set in UBBCONFIG
LMID	VARCHAR2(30)	NO		12.2.2	Machine LMID
GROUPID	SMALLINT	NO		12.2.2	Tuxedo group number
SERVERID	SMALLINT	NO		12.2.2	Server ID
SVCNAME	VARCHAR2(127)	NO		12.2.2	Service name
CORRELATIONID	VARCHAR2(255)	YES		12.2.2	Call path CORRELATIONID
ECID	VARCHAR2(1024)	YES		12.2.2	Tuxedo call ECID
TPERRNO	SMALLINT	NO		12.2.2	tperrno
valueTypeIndex	SMALLINT	NO		12.2.2	Tuxedo buffer type index, defined in weblogic.wtc.jatmi.StandardTypes CARRAY : 16 STRING : 17 FML : 18 VIEW : 19 X_OCTET : 20 X_C_TYPE : 21 X_COMMON : 22 FML32 : 23 VIEW32 : 24 XML : 25 MBSTRING : 26
valueSubType	VARCHAR2(127)	YES		12.2.2	Tuxedo sub buffer type. It is the view or view32 name
PAYLOADTYPE	SMALLINT	NO		12.2.2	1 means request; 2 means reply
value	BLOB	NO		12.2.2	User payload value
LOGTIME	Date	No		12.2.2

MON_XA

XA transaction information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
LOCALGTRID	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Local GTRID
DOMAIN	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo domain name
MACHINE	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo machine LMID
TUXGROUP	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo group number
PROCESSNAME	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo server process name
SERVERID	NUMBER	YES		11.1.1.1.0	Tuxedo server ID
PID	NUMBER	YES		11.1.1.1.0	Tuxedo process ID
PROCTYPE	NUMBER	YES		11.1.1.1.0	Tuxedo process type: • 0 (NCLIENT) • 1 (WCLIENT) • 2 (APPSERVER) • 3 (GWTDOMAIN) • 4 (BRIDGE) • 5 (GWWS) • 6 (WSH) • 7 (JSH) • 8 (ISH) • 9 (TMQUEUE) • 10 (TMQFORWARD)
LOGTIME	TIMESTAMP	YES	Indexed	11.1.1.1.0	Log time
XACODE	NUMBER	YES		11.1.1.1.0	The XA Routine return code
REMOTEGTRID	VARCHAR2(255)	YES		11.1.1.1.0	Remote GTRID
RMID	NUMBER	YES		11.1.1.1.0	RMID
XANAME	VARCHAR2(255)	YES		11.1.1.1.0	The transaction routine name: • tpbegin • tpcommit • tprollback • tpabort • xa_commit • xa_start • xa_prepare • xa_rollback • xa_end • tms_msg_xxx (for GWTDOMAIN XA transaction activities) • xa_msg_xxx (for GWTDOMAIN XA transaction activities)
LDOM	VARCHAR2(255)	YES		11.1.1.1.0	Ldom name: Ldom ID
RDOM	VARCHAR2(255)	YES		11.1.1.1.0	Rdom name: Rdom ID
MSGCVTTIME	NUMBER	YES		11.1.1.1.0	Message convert time
EXECTIME	NUMBER	YES		11.1.1.1.0	Transaction execute time
FLAGS	NUMBER	YES		11.1.1.1.0	The XA Routine call flag
TIMEOUT	NUMBER	YES		11.1.1.1.0	The XA Routine timeout
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM agent version: • null (11g or above) • 1.1 (TSAM 1.1 and 10gR3)
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

MON_SERVICE

Tuxedo service call information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
SVCNAME	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Service name
DOMAIN	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Tuxedo domain name
MACHINE	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Tuxedo machine LMID
TUXGROUP	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Tuxedo group number
PROCESSNAME	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo server process name
SERVERID	NUMBER	YES		11.1.1.1.0	Tuxedo server ID
PID	NUMBER	YES		11.1.1.1.0	Tuxedo process ID
THREADID	NUMBER	YES		11.1.1.1.0	Tuxedo thread ID
PROCTYPE	NUMBER	YES		11.1.1.1.0	Tuxedo Process type: • 0 (NCLIENT) • 1 (WCLIENT) • 2 (APPSERVER) • 3 (GWTDOMAIN) • 4 (BRIDGE) • 5 (GWWS) • 6 (WSH) • 7 (JSH) • 8 (ISH) • 9 (TMQUEUE) • 10 (TMQFORWARD)
USERNAME	VARCHAR2(255)	YES	Indexed	12.1.1.0	Tuxedo user name
LOGTIME	TIMESTAMP	NO	Indexed	11.1.1.1.0	Log time
MSGSIZE	NUMBER	YES		11.1.1.1.0	Message size
MSGTYPE	VARCHAR2(6)	YES		11.1.1.1.0	Message type: • ARP • ARQ
MSGQUEUED	NUMBER	YES		11.1.1.1.0	Message queue length
MSGWAITTIME	NUMBER	YES		11.1.1.1.0	Message wait time
STATUS	VARCHAR2(31)	YES		11.1.1.1.0	Reserved
ERRNO	NUMBER	YES		11.1.1.1.0	tperrno
URCODE	NUMBER	YES		11.1.1.1.0	tpurcode
EXECTIME	NUMBER	YES		11.1.1.1.0	Service execute time
CPUTIME	NUMBER	YES		11.1.1.1.0	Service CPU time
SYSCPUTIME	NUMBER	YES		12.1.1.0	Service SYS CPU time
USRCPUTIME	NUMBER	YES		12.1.1.0	Service USER CPU time
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM agent version: • null (11g or above) • 1.1 (TSAM 1.1 and 10gR3)
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved
ARTTRAN	VARCHAR2(255)	YES		12.1.3	ART CICS transaction server name
ARTSVRTYPE	NUMBER	YES		12.1.3 RP001
ARTPROGRAMENAME	VARCHAR2(255)	YES		12.1.3 RP001

MON_GWTDOMAIN

Tuxedo /T domain gateway performance statistics master information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
DOMAIN	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo domain name
MACHINE	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo machine LMID
TUXGROUP	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo group number
PROCESSNAME	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo server process name
SERVERID	NUMBER	YES		11.1.1.1.0	Tuxedo server ID
PID	NUMBER	NO		11.1.1.1.0	Tuxedo process ID
LDOM	VARCHAR2(255)	YES	Indexed	11.1.1.1.0	Ldom name: Ldom ID
LOGTIME	TIMESTAMP	NO	Indexed	11.1.1.1.0	Log time
LINKNUMBER	NUMBER	YES		11.1.1.1.0	Link number
MSGQUEUED	NUMBER	YES		11.1.1.1.0	Message queue length
REQUESTQUEUED	NUMBER	YES		11.1.1.1.0	Reserved
WORKLOAD	NUMBER	YES		11.1.1.1.0	Reserved
PROCTYPE	NUMBER	YES		11.1.1.1.0	Tuxedo process type: 3 (GWTDOMAIN)
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM agent version: • null (11g or above) • 1.1 (TSAM 1.1 and 10gR3)
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

MON_GWTLINK

Tuxedo /T domain gateway performance statistics detail information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
MON_GWTDOMAINID	NUMBER	NO	FK to MON_GWTDOMAIN (ID)	11.1.1.1.0
LINKADDRESS	VARCHAR2(255)	YES		11.1.1.1.0	Link address
LOGTIME	TIMESTAMP	NO		12.1.1.0	Log time
LINKSTATUS	NUMBER	YES		11.1.1.1.0	Link status: • 0 (UP) • -1 (DOWN) • 1 (INIT)
PENDNUMBER	NUMBER	YES		11.1.1.1.0	Network Pending Number
PENDBYTES	NUMBER	YES		11.1.1.1.0	Network Pending Bytes
ACCNUMBER	NUMBER	YES		11.1.1.1.0	Network Message Number
ACCBYTES	NUMBER	YES		11.1.1.1.0	Network Message Bytes
WAITREPLYNUMBER	NUMBER	YES		11.1.1.1.0	Network Outstanding Requests
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved.

MON_BRIDGE

Tuxedo bridge gateway performance statistics master information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
DOMAIN	VARCHAR2(255)	NO	Indexed	11.1.1.1.0	Tuxedo domain name
MACHINE	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo machine LMID
TUXGROUP	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo group number
PROCESSNAME	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo server process name
SERVERID	NUMBER	YES		11.1.1.1.0	Tuxedo server ID
PID	NUMBER	NO		11.1.1.1.0	Tuxedo process ID
LOGTIME	TIMESTAMP	NO	Indexed	11.1.1.1.0	Log time
LINKNUMBER	NUMBER	YES		11.1.1.1.0	Link number
MSGQUEUED	NUMBER	YES		11.1.1.1.0	Message queue length
REQUESTQUEUED	NUMBER	YES		11.1.1.1.0	Reserved
WORKLOAD	NUMBER	YES		11.1.1.1.0	Reserved
PROCTYPE	NUMBER	YES		11.1.1.1.0
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM agent version: • null (11g or above) • 1.1 (TSAM 1.1 and 10gR3)
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved

MON_BRGLINK

Tuxedo /T domain gateway performance statistics detail information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
MON_BRIDGEID	NUMBER	NO	FK to MON_BRIDGE (ID)	11.1.1.1.0
LINKADDRESS	VARCHAR2(255)	YES		11.1.1.1.0	Link address
LOGTIME	TIMESTAMP	NO		12.1.1.0	Log time
LINKSTATUS	NUMBER	YES		11.1.1.1.0	Link status: • 0 (UP) • -1 (DOWN) • 1 (INIT)
PENDNUMBER	NUMBER	YES		11.1.1.1.0	Network Pending Number
PENDBYTES	NUMBER	YES		11.1.1.1.0	Network Pending Bytes
ACCNUMBER	NUMBER	YES		11.1.1.1.0	Network Message Number
ACCBYTES	NUMBER	YES		11.1.1.1.0	Network Message Bytes
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM agent version: • null (11g or above) • 1.1 (TSAM 1.1 and 10gR3)
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0

MON_GWWS

Tuxedo GWWS performance statistics information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
ACTCLIENTNUM	NUMBER	YES		11.1.1.1.0	Active client number
ACTTHREADNUM	NUMBER	YES		11.1.1.1.0	Active Thread Number
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved
AVGINTIME	NUMBER	YES		11.1.1.1.0	Average Inbound Process Time
AVGOUTTIME	NUMBER	YES		11.1.1.1.0	Average Outbound Process Time
DOMAIN	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo domain name
TUXGROUP	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo group number
GWWSID	VARCHAR2(255)	NO		11.1.1.1.0	GWWS ID
INBOUNDPEND	NUMBER	YES		11.1.1.1.0	Inbound Pending Request
OUTBOUNDPEND	NUMBER	YES		11.1.1.1.0	Outbound Pending Request
INOWFAILNUM	NUMBER	YES		11.1.1.1.0	Inbound One-Way Failure Number
INOWSUCCNUM	NUMBER	YES		11.1.1.1.0	Inbound One-Way Success Number
INRPCFAILNUM	NUMBER	YES		11.1.1.1.0	Inbound RPC Failure Number
INRPCSUCCNUM	NUMBER	YES		11.1.1.1.0	Inbound RPC Success Number
MACHINE	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo machine LMID
OUTOWFAILNUM	NUMBER	YES		11.1.1.1.0	Outbound One-Way Failure Number
OUTOWSUCCNUM	NUMBER	YES		11.1.1.1.0	Outbound One-Way Success Number
OUTRPCFAILNUM	NUMBER	YES		11.1.1.1.0	Outbound RPC Failure Number
OUTRPCSUCCNUM	NUMBER	YES		11.1.1.1.0	Outbound RPC Success Number
PID	NUMBER	NO		11.1.1.1.0	Tuxedo process ID
PROCESSNAME	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo process name
PROCTYPE	NUMBER	YES		11.1.1.1.0	Tuxedo process type: 5 (GWWS)
SERVERID	NUMBER	YES		11.1.1.1.0	Tuxedo server ID
LOGTIME	TIMESTAMP	YES		11.1.1.1.0	Log time
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM agent version: • null (11g or above) • 1.1 (TSAM 1.1 and 10gR3)

MON_ARTTCP

Tuxedo application runtime for CICS TCP listener performance statistics information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.1.0
ATTRIBUTES	VARCHAR2(1023)			11.1.1.1.0	Reserved
DOMAIN	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo domain name
TUXGROUP	VARCHAR2(255)	YES		11.1.1.1.0	Tuxedo group number
TRANFAILNUM	NUMBER	YES		11.1.1.1.0	Failed Transaction Number
TRANSUCCNUM	NUMBER	YES		11.1.1.1.0	Successful Transaction Number
MACHINE	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo machine LMID
SESSIONNUM	NUMBER	YES		11.1.1.1.0	Session Number
PID	NUMBER	NO		11.1.1.1.0	Tuxedo process ID
PROCESSNAME	VARCHAR2(255)	NO		11.1.1.1.0	Tuxedo process name
PROCTYPE	SMALLINT	YES		11.1.1.1.0	Tuxedo process type: 2 (APPSERVER)
SERVERID	NUMBER	YES		11.1.1.1.0	Tuxedo server ID
LOGTIME	TIMESTAMP	NO		11.1.1.1.0	Log time
TSAMVERSION	VARCHAR2(255)	YES		11.1.1.1.0	TSAM agent version: null (11g or above)

MON_JESJOB

Tuxedo application runtime for Batch job information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	11.1.1.2.0	Job ID
DOMAIN	VARCHAR2(255)	NO	PK	11.1.1.2.0	Tuxedo domain name
MACHINE	VARCHAR2(255)	YES		11.1.1.2.0	Tuxedo machine LMID
NAME	VARCHAR2(32)	YES	Indexed	11.1.1.2.0	Job name
TYPRUN	VARCHAR2(7)	YES		11.1.1.2.0	Job typrun
PRIORITY	NUMBER	YES	Indexed	11.1.1.2.0	Job priority
OWNER	VARCHAR2(32)	YES	Indexed	11.1.1.2.0	Job owner
EXECMAC	VARCHAR2(32)	YES		11.1.1.2.0	Job executing machine
STATUS	VARCHAR2(12)	YES		11.1.1.2.0	Job status: • CONVING • WAITING • EXECUTING • DONE • HOLD_CONVING • HOLD_WAITING • HOLD_DELAY • FAIL • DISCARD • INDOUBT
JOBCLASS	CHAR(1)	YES	Indexed	11.1.1.2.0	Job class. Value may be [A-Z], [0-9]
RUNNINGSTEP	VARCHAR2(32)	YES		11.1.1.2.0	Job running step
EXECSTATUS	VARCHAR2(32)	YES		11.1.1.2.0	Job executing status
SUBMITTIME	NUMBER	YES		11.1.1.2.0	Submit time
WAITINGTIME	NUMBER	YES		11.1.1.2.0	Job waiting time
EXECTIME	NUMBER	YES		11.1.1.2.0	Job execution time
ENDTIME	NUMBER	YES		11.1.1.2.0	Job end time
PURGETIME	NUMBER	YES		11.1.1.2.0	Job purge time
LOGTIME	TIMESTAMP	NO	Indexed	11.1.1.2.0	Log time
USRCPU	NUMBER	YES		11.1.1.2.0	Job user CPU time
SYSCPU	NUMBER	YES		11.1.1.2.0	Job system CPU time
INITIATORPID	NUMBER	YES		11.1.1.2.0	Job initiator PID
ATTRIBUTES	VARCHAR2(1023)	YES		12.1.1.0	Reserved

MON_CLOB

Global CLOB information table.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
MD5	VARCHAR2(40)	NO	PK	12.1.1.0	Call pattern content MD5 If MD5 is a user name, CONTENT is the saved queries XML.
CONTENT	CLOB	NO		12.1.1.0	Call pattern content
ATTRIBUTES	VARCHAR2(1023)	YES		12.1.1.0	Reserved

MON_IMS_DETAIL

Tuxedo application runtime for IMS transactions or programs.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
ID	NUMBER	NO	PK	12.1.3
DOMAIN	VARCHAR2(255)	NO	Indexed	12.1.3	Tuxedo domain name
MACHINE	VARCHAR2(255)	NO	Indexed	12.1.3	Tuxedo machine LMID
TUXGROUP	VARCHAR2(255)	NO	Indexed	12.1.3	Tuxedo group number
PROCESSNAME	VARCHAR2(255)	YES		12.1.3	Tuxedo process name
SERVERID	NUMBER	YES		12.1.3	Tuxedo server ID
PID	NUMBER	YES		12.1.3	Tuxedo process ID
LOGTIME	TIMESTAMP	YES	Indexed	12.1.3	Log time
TSAMVERSION	VARCHAR2(255)	YES		12.1.3	TSAM agent version. Its value is null.
TRANSACTION_NAME	VARCHAR2 (255)	YES	Indexed	12.1.3	Transaction name
TRANSACTION_CLASS	NUMBER	YES	Indexed	12.1.3	Transaction class
LOGIC_TERMINAL	VARCHAR2 (255)	YES		12.1.3	Logic terminal name
REGION_TYPE	VARCHAR2 (255)	NO	Indexed	12.1.3	Region type
JOB_NAME	VARCHAR2 (255)	YES		12.1.3	JES submitted job name
USER_ID	VARCHAR2 (255)	YES		12.1.3	User ID of DFSRC00
START_TIME	TIMESTAMP	NO		12.1.3	Transaction/Program start time
END_TIME	TIMESTAMP	NO		12.1.3	Transaction/Program end time
ELAPSED_TIME	NUMBER	YES		12.1.3	Transaction/Program elapsed time
SYS_CPU_TIME	NUMBER	YES		12.1.3	Transaction/Program system CPU time
USER_CPU_TIME	NUMBER	YES		12.1.3	Transaction/Program user CPU time
PROGRAM_NAME	VARCHAR2 (255)	YES	Indexed	12.1.3	Program name
PSB_NAME	VARCHAR2 (255)	YES		12.1.3	PSB name
PROGRAM_ELAPSED_TIME	NUMBER	YES		12.1.3	Total program elapsed time, includes DL/I elapsed time
SPA_SIZE	NUMBER	YES		12.1.3	Current SPA size
ABEND_NUMBER	NUMBER	YES		12.1.3	Abend code
ENQ_NUMBER	NUMBER	YES		12.1.3	Message number pushed in /Q
DEQ_NUMBER	NUMBER	YES		12.1.3	Message number popped from /Q
DLI_TIME	NUMBER	YES		12.1.3	DL/I elapsed time
DLIS	VARCHAR2 (2048)	YES		12.1.3	DL/I list
ATTRIBUTES	VARCHAR2(1023)	YES		12.1.3	Reserved

REPLAYDEFINITION

Test load generator database table.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
NAME	VARCHAR2(255 BYTE)	NO	PK	12.2.2
REPLAYDEFINITION	CLOB			12.2.2
CREATEDTIME	TIMESTAMP			12.2.2
MODIFIEDTIME	TIMESTAMP			12.2.2
ATTRIBUTES	VARCHAR2(1023 BYTE)			12.2.2

TSAM Plus Management Information

This section contains the following:

•	GLOBALCONFIG

•

ROLES

•

USERS

GLOBALCONFIG

TSAM Plus global parameters information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
PARAM	VARCHAR2(255)	NO	PK	11.1.1.1.0	Parameter name
VALUE	VARCHAR2(255)	YES		11.1.1.1.0	Parameter value
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved

ROLES

TSAM Plus role information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
NAME	VARCHAR2(255)	NO	PK	11.1.1.2.0	Role name
ID	NUMBER	NO	Unique	11.1.1.2.0	Role ID
DESCRIPTION	VARCHAR2(255)	YES		11.1.1.2.0	Role description
DEFINITION	VARCHAR2(4000)	YES		11.1.1.2.0	Role definition
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.2.0	Reserved

USERS

TSAM Plus user information.

 

COLUMN	TYPE	Nullable	Constraints	Since Version	Note
NAME	VARCHAR2(255)	NO	PK	11.1.1.1.0	User login name
ROLENAMES	VARCHAR2(255)	NO		11.1.1.2.0	Role names the user belongs to
PASSWORD	VARCHAR2(255)	NO		11.1.1.1.0	User password
FULLNAME	VARCHAR2(255)	YES	Indexed	11.1.1.1.0	User full name
DESCRIPTION	VARCHAR2(255)	YES		11.1.1.1.0	User description
MODIFIEDTIME	TIMESTAMP	YES		11.1.1.1.0	User modification time
ATTRIBUTES	VARCHAR2(1023)	YES		11.1.1.1.0	Reserved
SAVEDQUERIES	VARCHAR2(4000)	YES		12.1.3	Saved queries XML. If the length exceeds 4000, only the user name is stored here and the actual value should be found in MON_CLOB table.