Top
Systemwalker Service Quality Coordinator Reference Guide
Systemwalker

4.2.6 The Interstage folder / Interstage reports

Table name

Record ID

Record No.

Field Name

Source

Unit of Measure

Description

resource_data_wide

ISPREPORT_TDOBJ

FJ1006

tProcessID

ispreport -k TDOBJ

number

The process ID of the business application for which performance information is being measured

tMaxReqTime

ispreport -k TDOBJ

milliseconds

Maximum time (during the sampling interval) taken for the process to process an operation

tMinReqTime

ispreport -k TDOBJ

milliseconds

Minimum time (during the sampling interval) taken for the process to process an operation

tAvgReqTime

ispreport -k TDOBJ

milliseconds

Average time (during the sampling interval) taken for the process to process an operation

tMaxWaitTime

ispreport -k TDOBJ

milliseconds

Maximum time (during the sampling interval) that a request spent waiting from the time it was received from the client application until the processing by the server application started

tMinWaitTime

ispreport -k TDOBJ

milliseconds

Minimum time (during the sampling interval) that a request spent waiting from the time it was received from the client application until the processing by the server application started

tAvgWaitTime

ispreport -k TDOBJ

milliseconds

Average time (during the sampling interval) that a request spent waiting from the time it was received from the client application until the processing by the server application started

tProcNum

ispreport -k TDOBJ

number

Number of times the operation has been executed by the process during the sampling interval

tReqNum

ispreport -k TDOBJ

number

Number of processes for the object that have been accumulated since performance monitoring started

tWaitNum

ispreport -k TDOBJ

number

Maximum number of requests (during the sampling interval) to the object that had to wait to be processed

tOPName

ispreport -k TDOBJ

name

The operation name of the business application for which performance information is being measured

resource_data_vwide

ISPREPORT_EJBAPL

FJ1007

eProcessID

ispreport -k EJBAPL

number

The process ID of the EJB application for which performance information is being measured

eThreadID

ispreport -k EJBAPL

The thread ID for the thread where the monitored method is running

eMaxReqTime

ispreport -k EJBAPL

milliseconds

Maximum processing time (during the sampling interval) for monitored methods in the thread

eMinReqTime

ispreport -k EJBAPL

milliseconds

Minimum processing time (during the sampling interval) for monitored methods in the thread

eAvgReqTime

ispreport -k EJBAPL

milliseconds

Average processing time (during the sampling interval) for monitored methods in the thread

eMaxWaitTime

ispreport -k EJBAPL

milliseconds

Maximum time (during the sampling interval) that a request spent waiting from the time it was received from the client application until the method started processing

eMinWaitTime

ispreport -k EJBAPL

milliseconds

Minimum time (during the sampling interval) that a request spent waiting from the time it was received from the client application until the method started processing

eAvgWaitTime

ispreport -k EJBAPL

milliseconds

Average time (during the sampling interval) that a request spent waiting from the time it was received from the client application until the method started processing

eProcNum

ispreport -k EJBAPL

Number of times the monitored method in the thread has been processed during the sampling interval

eReqNum

ispreport -k EJBAPL

Number of EJB application processes that accumulated during the sampling interval

eWaitNum

ispreport -k EJBAPL

Maximum number of requests (during the sampling interval) to the EJB application that had to wait to be processed. For "Message-drive Bean" EJB applications, this is always "0".

ObjNum

ispreport -k EJBAPL

Number of current EJB objects (the difference between the number of times that the create() method has been executed and the number of times that the remove() method has been executed)

MaxPassivate

ispreport -k EJBAPL

Maximum number of times that instances of the EJB application (process) have been pooled during the sampling interval

MaxVMMem

ispreport -k EJBAPL

Kbytes

The maximum amount of memory used by the VM for the EJB application. This will be "0" if the method has not been processed during the sampling interval.

AvgVMMem

ispreport -k EJBAPL

Kbytes

The average amount of memory used by the VM for the EJB application. This will be "0" if the method has not been processed during the sampling interval.

MethodName

ispreport -k EJBAPL

The name and signature of the method being monitored (the types of method argument and return value)

resource_data_wide

ISPREPORT_IMPLID

FJ1008

iProcessID

ispreport -k IMPLID

The process ID of the CORBA application being monitored

iThreadID

ispreport -k IMPLID

The thread ID of the CORBA application being monitored

iMaxReqTime

ispreport -k IMPLID

milliseconds

The maximum processing time for the operation in the thread during the sampling interval

iMinReqTime

ispreport -k IMPLID

milliseconds

The minimum processing time for the operation in the thread during the sampling interval

iAvgReqTime

ispreport -k IMPLID

milliseconds

The average processing time for the operation in the thread during the sampling interval

iMaxWaitTime

ispreport -k IMPLID

milliseconds

Maximum time (during the sampling interval) spent waiting from the time that a request was received from the client application until the object started processing

iMinWaitTime

ispreport -k IMPLID

milliseconds

Minimum time (during the sampling interval) spent waiting from the time that a request was received from the client application until the object started processing

iAvgWaitTime

ispreport -k IMPLID

milliseconds

Average time (during the sampling interval) spent waiting from the time that a request was received from the client application until the object started processing

MaxDataLen

ispreport -k IMPLID

bytes

The maximum data length sent from the client application

MinDataLen

ispreport -k IMPLID

bytes

The minimum data length sent from the client application

AvgDataLen

ispreport -k IMPLID

bytes

The average data length sent from the client application

iProcNum

ispreport -k IMPLID

Number of times that the operation has been processed in the thread during the sampling interval

iReqNum

ispreport -k IMPLID

Number of processes for the object that accumulated during the sampling interval

iWaitNum

ispreport -k IMPLID

Maximum number of requests (during the sampling interval) to the object that had to wait to be processed

ObjectName

ispreport -k IMPLID

The name of the object that is included in the implementation repository

iOPName

ispreport -k IMPLID

The operation name within the object that is included in the implementation repository

resource_data_wide

IS_JMX_JVM

FJ1088

ijjvhpcur

jmxif

byte

Current heap size

ijjvhpmin

jmxif

byte

Minimum heap size

ijjvhpmax

jmxif

byte

Maximum heap size

ijjvhpulim

jmxif

byte

Heap size upper limit

ijpermcur

jmxif

byte

Current Perm

ijpermmin

jmxif

byte

Minimum Perm

ijpermmax

jmxif

byte

Maximum Perm

ijpermulim

jmxif

byte

Perm upper limit

ijgcocnum

jmxif

number

Number of garbage collections

ijgcoctim

jmxif

microsec

Total time spent on garbage collection

ijgcocavg

jmxif

microsec

Average interval between garbage collections

resource_data

IS_JMX_SERVLET

FJ1089

ijsvltmcal

jmxif

number

Method call count

ijsvltptavg

jmxif

microsec

Average processing time

ijsvltptmax

jmxif

microsec

Maximum processing time

ijsvltptmin

jmxif

microsec

Minimum processing time

resource_data

IS_JMX_ENTITYBEAN_METHOD

FJ1090

ijentmcal

jmxif

number

Method call count

ijentptavg

jmxif

microsec

Average processing time

ijentptmax

jmxif

microsec

Maximum processing time

ijentptmin

jmxif

microsec

Minimum processing time

resource_data_wide

IS_JMX_ENTBEAN_POOL_AND_PASSIVATE

FJ1091

ijenticur

jmxif

number

Current number of ready instances

ijentimax

jmxif

number

Maximum number of ready instances

ijentimin

jmxif

number

Minimum number of ready instances

ijentpicur

jmxif

number

Current number of instances in pool

ijentpimax

jmxif

number

Maximum number of instances in pool

ijentpimin

jmxif

number

Minimum number of instances in pool

ijentricur

jmxif

number

Average number of instances used in a single transaction

ijentrimax

jmxif

number

Maximum number of instances used in a single transaction

ijentrimin

jmxif

number

Minimum number of instances used in a single transaction

ijentpvcur

jmxif

number

Average number of passivated instances

ijentpvmax

jmxif

number

Maximum number of passivated instances

ijentpvmin

jmxif

number

Minimum number of passivated instances

ijentpvnum

jmxif

number

Number of transactions in which passivation occurred

ijenttrnum

jmxif

number

Method call count

resource_data

IS_JMX_STFBEAN_METHOD

FJ1092

ijstfmcal

jmxif

number

Average processing time

ijstfmptavg

jmxif

microsec

Maximum processing time

ijstfmptmax

jmxif

microsec

Minimum processing time

ijstfmptmin

jmxif

microsec

Current number of ready instances

resource_data

IS_JMX_STFBEAN_INS_AND_IDLE

FJ1093

ijstfiicur

jmxif

number

Current number of instances that can invoke a method

ijstfiimax

jmxif

number

Maximum number of instances that can invoke a method

ijstfiimin

jmxif

number

Minimum number of instances that can invoke a method

ijstfitime

jmxif

microsec

Timeout time

ijstfinum

jmxif

number

Timeout count

resource_data

IS_JMX_STLSBEAN_METHOD

FJ1094

ijstlmcal

jmxif

number

Method call count

ijstlmptavg

jmxif

microsec

Average processing time

ijstlmptmax

jmxif

microsec

Maximum processing time

ijstlmptmin

jmxif

microsec

Minimum processing time

resource_data

IS_JMX_MESSBEAN_METHOD

FJ1095

ijmesmcal

jmxif

number

Method call count

ijmesptmax

jmxif

microsec

Maximum processing time

ijmesptmin

jmxif

microsec

Minimum processing time

resource_data

IS_JMX_MESSBEAN_INFO

FJ1096

ijmesprnum

jmxif

number

Number of processed messages

ijmesvnum

jmxif

number

Number of saved messages

resource_data_wide

IS_JMX_JTARESOURCE

FJ1097

ijtaexnum

jmxif

number

Total number of executed transactions

ijtactnum

jmxif

number

Number of committed transactions

ijtarbnum

jmxif

number

Number of transactions rolled back

ijtatravg

jmxif

microsec

Average transaction processing time

ijtatrmax

jmxif

microsec

Maximum transaction processing time

ijtatrmin

jmxif

microsec

Minimum transaction processing time

ijtatpavg

jmxif

number

Current number of transactions being executed

ijtatpmax

jmxif

number

Maximum number of transactions being executed

ijtatpmin

jmxif

number

Minimum number of transactions being executed

resource_data_uwide

IS_JMX_JDBCRESOURCE

FJ1098

ijdbcpcur

jmxif

number

Number of physical connections - Current value (*1)

ijdbcpulim

jmxif

number

Number of physical connections - Upper limit (*1)

ijdbcfree

jmxif

number

Number of free connections (*1)

ijdbcused

jmxif

number

Number of used connections (*1)

ijdbcwtnum

jmxif

number

Connection wait count (*2)

ijdbcwtavg

jmxif

microsec

Connection wait time - Average (*2)

ijdbcwtmax

jmxif

microsec

Connection wait time - Maximum (*2)

ijdbcwtmin

jmxif

microsec

Connection wait time - Minimum (*2)

ijdbcthcur

jmxif

number

Number of threads waiting for a connection - Current value (*2)

ijdbcthmax

jmxif

number

Number of threads waiting for a connection - Maximum value (*2)

ijdbcthout

jmxif

number

Number of connection wait timeouts (*2)

ijdbcpcnum

jmxif

number

Number of physical connections established (*2)

ijdbcpcavg

jmxif

microsec

Physical connection establishment time - Average (*2)

ijdbcpcmax

jmxif

microsec

Physical connection establishment time - Maximum (*2)

ijdbcpcmin

jmxif

microsec

Physical connection establishment time - Minimum (*2)

ijdbcidlcl

jmxif

number

Number of closures caused by idle timeouts (*2)

ijdbcexccl

jmxif

number

Number of closures caused by exceptions (*2)

ijdbcget

jmxif

number

Connection allocation count

ijdbccls

jmxif

number

Connection closure count

ijdbccavg

jmxif

microsec

Connection time - Average

ijdbccmax

jmxif

microsec

Connection time - Maximum

ijdbccmin

jmxif

microsec

Connection time - Minimum

resource_data

IS_JMX_EVENTSERVICE

FJ1306

ijevntcntsum

jmxif

number

Number of accumulation event data

ijevntnum

jmxif

number

connected consumers

ijevntsprnum

jmxif

number

connected suppliers

resource_data

IS_JMX_SERVLETCONTAINER

FJ1305

ijsvcntnum

jmxif

number

Number of threads processing now

ijsvcnttotal

jmxif

number

Total number of threads

resource_data

IS_JMX_WEBAPPSESSION

FJ1304

ijwebapnum

jmxif

number

sessions

*1: Collected only if JDBC connections are pooled under Interstage, or if the database is Oracle10g or later and the JDBC drivers pool JDBC connections. Otherwise, not collected.

*2: Collected only if JDBC connections are pooled under Interstage. Not collected when the JDBC drivers pool JDBC connections.