Table of Contents Previous Next PDF


TSAM Plus Database Metadata
TSAM Plus Database Metadata
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
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
CLOB
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.
Tuxedo Monitoring Information
This section contains the following:
•
POLICY
•
ALERT_DEFINITION
•
ALERT
•
CALLPATH
•
MON_CPSEGMENT
•
MON_XA
•
MON_SERVICE
•
MON_GWTDOMAIN
•
MON_GWTLINK
•
MON_BRIDGE
•
MON_BRGLINK
•
MON_GWWS
•
MON_ARTTCP
•
MON_JESJOB
•
MON_CLOB
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.
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.
CALLPATH
Call path master information.
 
COLUMN
TYPE
Nullable
Constraints
Since Version
Note
CORRELATIONID
VARCHAR2(255)
NO
PK
11.1.1.1.0
 
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)
DOMAIN
VARCHAR2(255)
YES
Indexed
11.1.1.1.0
Tuxedo domain name
MACHINE
VARCHAR2(255)
YES
Indexed
11.1.1.1.0
Tuxedo machine LMID
INITIATOR
VARCHAR2(255)
YES
Indexed
11.1.1.1.0
Initiator process name
SERVICE
VARCHAR2(255)
YES
Indexed
11.1.1.1.0
Tuxedo service
LOGTIME
TIMESTAMP
YES
Indexed
11.1.1.1.0
The time a call path is generated
USERNAME
VARCHAR2(255)
YES
 
12.1.1.0
Tuxedo user name
CLTADDR
VARCHAR2(255)
YES
 
11.1.1.1.0
Tuxedo client name
TSAMVERSION
VARCHAR2(255)
YES
 
11.1.1.1.0
TSAM agent version:
•
null (11g or above)
•
1.1 (TSAM 1.1 and 10gR3)
SEGMENTCOUNT
NUMBER
NO
 
11.1.1.1.0
Segment count
CALLPATTERN
VARCHAR2(4000)
YES
 
11.1.1.1.0
Call pattern in XML.
If the length exceeds 4000, only an MD5 value will be stored here and the actual value should be found in MON_CLOB table.
CALLPATTERN_DETAILED
VARCHAR2(4000)
YES
 
11.1.1.1.0
Detailed call pattern in XML.
If the length exceeds 4000, only an MD5 value will be stored here and the actual value should be found in MON_CLOB table.
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
YES
 
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
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
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
YES
 
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
YES
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
ID
NUMBER
NO
PK
12.1.1.0
 
MD5
VARCHAR2(40)
NO
Indexed
12.1.1.0
Call pattern content MD5
CONTENT
CLOB
NO
 
12.1.1.0
Call pattern content
ATTRIBUTES
VARCHAR2(1023)
YES
 
12.1.1.0
Reserved
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
 
11.1.1.2.0
Role ID
DESCRIPTION
VARCHAR2(255)
YES
Unique
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
 

Copyright © 1994, 2017, Oracle and/or its affiliates. All rights reserved.