3 TSAM Plus Database Metadata

This chapter contains the following sections:

3.1 Tuxedo Configuration Information

This section contains the following:

Parent topic: TSAM Plus Database Metadata

3.1.1 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.

Parent topic: Tuxedo Configuration Information

3.1.2 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

Parent topic: Tuxedo Configuration Information

3.1.3 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

Parent topic: Tuxedo Configuration Information

3.1.4 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.
  • STD: Standby
CLOPT VARCHAR2(1023) YES - 11.1.1.2.0 CLOPT parameter in UBB
ATTRIBUTES VARCHAR2(1023) YES - 11.1.1.1.0 Reserved.

Parent topic: Tuxedo Configuration Information

3.1.5 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.

Parent topic: Tuxedo Configuration Information

3.1.6 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.

Parent topic: Tuxedo Configuration Information

3.1.7 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.

Parent topic: Tuxedo Configuration Information

3.1.8 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.

Parent topic: Tuxedo Configuration Information

3.1.9 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.

Parent topic: Tuxedo Configuration Information

3.1.10 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.

Parent topic: Tuxedo Configuration Information

3.1.11 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.

Parent topic: Tuxedo Configuration Information

3.1.12 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

Parent topic: Tuxedo Configuration Information

3.1.13 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

Parent topic: Tuxedo Configuration Information

3.2 Tuxedo Monitoring Information

This section contains the following:

Parent topic: TSAM Plus Database Metadata

3.2.1 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.

Parent topic: Tuxedo Monitoring Information

3.2.2 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

Parent topic: Tuxedo Monitoring Information

3.2.3 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.

Parent topic: Tuxedo Monitoring Information

3.2.4 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

Parent topic: Tuxedo Monitoring Information

3.2.5 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 -

Parent topic: Tuxedo Monitoring Information

3.2.6 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_commit
  • xa_start
  • xa_prepare
  • xa_rollback
  • xa_end
  • tms_msg_xxx GWTDOMAIN XA transaction activities)
  • xa_msg_xxx GWTDOMAIN XA (for 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.

Parent topic: Tuxedo Monitoring Information

3.2.7 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 -

Parent topic: Tuxedo Monitoring Information

3.2.8 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.

Parent topic: Tuxedo Monitoring Information

3.2.9 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.

Parent topic: Tuxedo Monitoring Information

3.2.10 MON_BRIDGE

Tuxedo bridge 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

Parent topic: Tuxedo Monitoring Information

3.2.11 MON_BRGLINK

Tuxedo bridge 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 -

Parent topic: Tuxedo Monitoring Information

3.2.12 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)

Parent topic: Tuxedo Monitoring Information

3.2.13 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)

Parent topic: Tuxedo Monitoring Information

3.2.14 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

Parent topic: Tuxedo Monitoring Information

3.2.15 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

Parent topic: Tuxedo Monitoring Information

3.2.16 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

Parent topic: Tuxedo Monitoring Information

3.2.17 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 -

Parent topic: Tuxedo Monitoring Information

3.3 TSAM Plus Management Information

This section contains the following:

Parent topic: TSAM Plus Database Metadata

3.3.1 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

Parent topic: TSAM Plus Management Information

3.3.2 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

Parent topic: TSAM Plus Management Information

3.3.3 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 hash
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.

Parent topic: TSAM Plus Management Information