SAP ABAP Table STUITHRSTA (Thread Statistics (Informix Monitor))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-INF (Application Component) Informix
     ⤷ STUI (Package) Informix Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	STUITHRSTA	Table Relationship Diagram
Short Description	Thread Statistics (Informix Monitor)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TID	☐	STUITID	INT4	INT4	10	0	Thread ID (Informix monitor)
2	LOCKSREQUE	☐	STUILCKREQ	INT4	INT4	10	0	No. of locks requested
3	LOCKSHELD	☐	STUILCKHLD	INT4	INT4	10	0	No. of locks currently held
4	LOCKWTS	☐	STUILCKWTS	INT4	INT4	10	0	No. of lock waits
5	DEADLOCKS	☐	STUIDEADLK	INT4	INT4	10	0	No. of deadlocks detected
6	LKTOUTS	☐	STUILKTOUT	INT4	INT4	10	0	No. of lock timeouts
7	LOGRECS	☐	STUILOGREC	INT4	INT4	10	0	No. of log records written
8	ISREADS	☐	STUIISREAD	INT4	INT4	10	0	No. of ISAM reads
9	ISWRITES	☐	STUIISWRIT	INT4	INT4	10	0	No. of ISAM writes
10	ISREWRITES	☐	STUIISREWR	INT4	INT4	10	0	No. of ISAM rewrites
11	ISDELETES	☐	STUIISDELE	INT4	INT4	10	0	No. of ISAM deletes
12	ISCOMMITS	☐	STUIISCOMM	INT4	INT4	10	0	Number of commits
13	ISROLLBACK	☐	STUIISRLBK	INT4	INT4	10	0	No. of rollbacks
14	LONGTXS	☐	STUILNGTXS	INT4	INT4	10	0	No. of long transactions
15	BUFREADS	☐	STUIBFREAD	INT4	INT4	10	0	Number of buffer reads
16	BUFWRITES	☐	STUIBFWRIT	INT4	INT4	10	0	Number of buffer writes
17	LOGSPUSED	☐	STUILGPUSE	INT4	INT4	10	0	% log space currently used
18	MAXLOGSP	☐	STUIMXLOGS	INT4	INT4	10	0	Max. % of logspace ever used
19	SEQSCANS	☐	STUISEQSCA	INT4	INT4	10	0	No. of sequential scans
20	TOTSORTS	☐	STUITOTSRT	INT4	INT4	10	0	Total no. of sorts
21	DSKSORTS	☐	STUIDSKSRT	INT4	INT4	10	0	No. of disk sorts
22	SRTSPMAX	☐	STUISRTMAX	INT4	INT4	10	0	srtspmax

History

Last changed by/on	SAP	20041216
SAP Release Created in