SAP ABAP Table TST04INF64 (Statistics: Structure for Database Information Display)

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	TST04INF64	Table Relationship Diagram
Short Description	Statistics: Structure for Database Information Display

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
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	BUFSIZETOT	☐	BUFFERSPAC	SINT4_NOS	INT4	10	0	Total size of database shared memory buffer
2	BUFREADS	☐	BUFREADS64	STUI_INT64	DEC	18	0	Number of reads from shared memory buffer
3	DSKREADS	☐	DSKREADS64	STUI_INT64	DEC	18	0	Actual reads (I/O requests) from disk
4	BUFWRITES	☐	BUFWRITS64	STUI_INT64	DEC	18	0	Number of writes to shared memory buffer
5	DSKWRITES	☐	DSKWRITS64	STUI_INT64	DEC	18	0	Actual number of writes (I/O requests) to disk
6	PLGPAGEWRI	☐	PLGPGWRI64	STUI_INT64	DEC	18	0	Number of physical log pages written
7	PLGWRITES	☐	PLGWRITS64	STUI_INT64	DEC	18	0	Number of writes to the physical log
8	LLGPAGEWRI	☐	LLGPGWRI64	STUI_INT64	DEC	18	0	Number of logical log pages written
9	LLGWRITES	☐	LLGWRITS64	STUI_INT64	DEC	18	0	Number of writes to the logical log
10	BUFPOOLFLU	☐	BUFPOOLFLU	SINT4_NOS	INT4	10	0	Number of buffer pool flushes
11	FGWRITES	☐	FGWRITES64	STUI_INT64	DEC	18	0	Number of foreground writes
12	LRUWRITES	☐	LRUWRITS64	STUI_INT64	DEC	18	0	Number of lru writes
13	CHUNKWRITE	☐	CHKWRITS64	STUI_INT64	DEC	18	0	Writes resulting from a checkpoint
14	ISCOMMITS	☐	ISCOMMIT64	STUI_INT64	DEC	18	0	ISAM commits since database startup
15	ISROLLBACK	☐	ISROLLBK64	STUI_INT64	DEC	18	0	ISAM rollbacks since database startup
16	ISAMTOT	☐	ISAMTOT64	STUI_INT64	DEC	18	0	Total number of ISAM calls
17	SEQSCANS	☐	SEQSCANS64	STUI_INT64	DEC	18	0	Number of sequential scans
18	NUMCKPTS	☐	NUMCKPTS	SINT4_NOS	INT4	10	0	Number of checkpoints since database startup
19	READQUAL	☐	READ_QUALI	SINT4_NOS	INT4	10	0	Percentage of successful reads from shared memory
20	WRITEQUAL	☐	WRITE_QUAL	SINT4_NOS	INT4	10	0	Percentage of successful writes for shared memory buffer
21	PHYSLOG_IO	☐	PAGES_PC_1	SINT4_NOS	INT4	10	0	Percentage of physical log buffer per write
22	LOGLOG_IO	☐	PAGES_PC_2	SINT4_NOS	INT4	10	0	Percentage of logical log buffer per write
23	ACTIVESESS	☐	ACTIVE_SES	SINT4_NOS	INT4	10	0	Active database server sessions
24	TRANS_MIN	☐	ISCALLS_SE	SINT4_NOS	INT4	10	0	Transaction per minute
25	ISCALLS_TR	☐	ISCALLS_TR	SINT4_NOS	INT4	10	0	ISAM calls per transaction
26	CKPTCORR	☐	CORR_1	SINT4_NOS	INT4	10	0	Checkpoint activity since bootup (100% = inactive)
27	PHYSCORR	☐	CORR_2	SINT4_NOS	INT4	10	0	Physical log sizing by checkpoint
28	CORR_3	☐	CORR_3	SINT4_NOS	INT4	10	0	Logical log sizing by checkpoint
29	BUFFERS	☐	BUFFERS	SINT4_NOS	INT4	10	0	Number of regular shared memory buffers
30	PAGESIZE	☐	BUFSIZ	SINT4_NOS	INT4	10	0	System page size (KB)
31	PHYSBUFF	☐	PHYSBUFF	SINT4_NOS	INT4	10	0	Size of the two physical log buffers
32	LOGBUFF	☐	LOGBUFF	SINT4_NOS	INT4	10	0	Size of each of the three logical log buffers
33	CLEANERS	☐	CLEANERS	SINT4_NOS	INT4	10	0	Number of database buffer cleaner processes
34	LRUS	☐	LRUS	SINT4_NOS	INT4	10	0	Number of LRU queues
35	LRUMAXDIRT	☐	LRUMAXDIRT	SINT4_NOS	INT4	10	0	When to begin cleaning LRU queues
36	LRUMINDIRT	☐	LRUMINDIRT	SINT4_NOS	INT4	10	0	When to stop cleaning LRU queues
37	CKPTINTVL	☐	CKPTINTVL	SINT4_NOS	INT4	10	0	Database checkpoint interval (s)
38	NUMCPUVPS	☐	NUMCPUVPS	SINT4_NOS	INT4	10	0	Number of user (CPU) virtual processors
39	PHYSFILE	☐	PHYSFILE	SINT4_NOS	INT4	10	0	Physical log file size (KB)
40	LOGSIZ	☐	LOGSIZ	SINT4_NOS	INT4	10	0	Size of a single logical log
41	LOGFILES	☐	LOGFILES	SINT4_NOS	INT4	10	0	Number of Log Files
42	LOGSIZETOT	☐	LOGSIZETOT	SINT4_NOS	INT4	10	0	Total Size of Logical Log (Kb)
43	DBSERVERNA	☑	DBSERVERNA	CHAR20	CHAR	20	0	Name of database server
44	LTXHWM	☐	LTXHWM	SINT4_NOS	INT4	10	0	High watermark percentage
45	LOCKS	☐	LOCKS	SINT4_NOS	INT4	10	0	Max. number of locks
46	RA_PAGES	☐	RA_PAGES	SINT4_NOS	INT4	10	0	Number of pages to read ahead for sequential or index scans
47	RA_THRESH	☐	RA_THRESH	SINT4_NOS	INT4	10	0	Read ahead page trigger
48	RA_USED	☐	RA_USED64	STUI_INT64	DEC	18	0	Read ahead pages used
49	RA_COUNT	☐	RA_COUNT64	STUI_INT64	DEC	18	0	Sum of read ahead pages
50	RA_PERSCAN	☐	RA_PERSCAN	SINT4_NOS	INT4	10	0	Number of sequential scans per read ahead
51	RA_PCNT	☐	RA_PCNT	STUI_PCNT	DEC	4	1	Percentage of pages read ahead actually used
52	IDL_WRITES	☐	IDL_WRITES	SINT4_NOS	INT4	10	0	Number of idle writes
53	PC_SLEEP	☐	PC_SLEEP	SINT4_NOS	INT4	10	0	Sleep time for page cleaners
54	OVBUFF	☐	OVBUFF	SINT4_NOS	INT4	10	0	Number of unsuccessful accesses to shared memory buffer
55	SHMVIRT	☐	XMEM_ALLOC	SINT4_NOS	INT4	10	0	Amount of additional virtual shared memory
56	FLUSHCKPTS	☐	FLUSHCKPTS	SINT4_NOS	INT4	10	0	Number of buffer flushes due to checkpointing
57	SHMTOTAL	☐	TOT_SHMSIZ	SINT4_NOS	INT4	10	0	Total size of INFORMIX shared memory
58	NUMAIOVPS	☐	AIOVPS	SINT4_NOS	INT4	10	0	Number of AIO virtual processors
59	DBFILES	☐	DBFILES	SINT4_NOS	INT4	10	0	Number of disk files used for INFORMIX database
60	SHMRES	☐	RES_SHMSIZ	SINT4_NOS	INT4	10	0	Resident shared menory portion
61	SHMMES	☐	COM_SHMSIZ	SINT4_NOS	INT4	10	0	Shared memory communications portion
62	KAIOTHREAD	☐	KAIOTHREAD	SINT4_NOS	INT4	10	0	Number of kaio threads for kernel asynchronous disk I/O
63	UP_SINCE	☐	UPSINCE	INT4	INT4	10	0	Time since DB start in seconds (Informix monitor)
64	RESET_STAT	☐	RESET_STAT	INT4	INT4	10	0	Time since last reset statistics in seconds
65	PAGREADS	☐	PAGREADS64	STUI_INT64	DEC	18	0	Number of Buffer Pages read from Disk
66	PAGWRITES	☐	PAGWRITS64	STUI_INT64	DEC	18	0	Number of Buffer Pages written to Disk
67	BUFWTS	☐	BUFWAITS64	STUI_INT64	DEC	18	0	Number of Buffer Wait Events
68	BUFWTPCNT	☐	BUFWTPCNT	STUI_PCNT	DEC	4	1	Percentage of Buffer Wait Events
69	MAXPDQPRIO	☐	MAXPDQPRIO	SINT4_NOS	INT4	10	0	Max PDQ Priority
70	DSMAXQUERY	☐	DSMAXQUERY	SINT4_NOS	INT4	10	0	DS Max Queries
71	DSMAXSCANS	☐	DSMAXSCANS	SINT4_NOS	INT4	10	0	DS Max Scans
72	DSTOTALMEM	☐	DSTOTALMEM	SINT4_NOS	INT4	10	0	DS Total Memory
73	ISAMREADS	☐	ISREADS64	STUI_INT64	DEC	18	0	ISAM Read Calls
74	ISAMWRITES	☐	ISWRITES64	STUI_INT64	DEC	18	0	ISAM Write Calls
75	ISAMREWRIT	☐	ISREWRIT64	STUI_INT64	DEC	18	0	ISAM Rewrite Calls
76	ISAMDELETE	☐	ISDELETE64	STUI_INT64	DEC	18	0	ISAM Delete Calls
77	ISAMSTARTS	☐	ISSTARTS64	STUI_INT64	DEC	18	0	ISAM Start Calls (Index read)
78	MAXSORTSPC	☐	MAXSORTSPC	SINT4_NOS	INT4	10	0	Max Sort Space
79	SHMVSEGCNT	☐	SHMVSEGCNT	SINT4_NOS	INT4	10	0	Number of Virtual Shared Memory Segments
80	SQLREADLD	☐	SQLREADLD	STUI_1000	DEC	5	1	Load of SQL read activity: buffer reads / (isreads+isstart)
81	MEMSORTS	☐	MEMSORTS	STUI_INT64	DEC	18	0	Number of Sort Events in Memory
82	DISKSORTS	☐	DISKSORTS	STUI_INT64	DEC	18	0	Number of Sort Events in Memory
83	WRITEACTIV	☐	WRITEACTIV	STUI_PCNT	DEC	4	1	Percentage of Write Activity over Read Activity
84	LONG_TX	☐	LONG_TX	SINT4_NOS	INT4	10	0	Number of Long Transactions (aborted)
85	LOCKWAITS	☐	LOCKWAIT64	STUI_INT64	DEC	18	0	Number of Lock Wait Events
86	LOCKREQS	☐	LOCKREQS64	STUI_INT64	DEC	18	0	Number of Lock Requests
87	LOCKWTPCNT	☐	LOCKWTPCNT	SINT4_NOS	INT4	10	0	Lock Wait Events per Lock Requests (ppm)
88	LKTOUTS	☐	LOCKTOUTS	SINT4_NOS	INT4	10	0	Number of Lock Timeout Events
89	DEADLKS	☐	DEADLCKS	SINT4_NOS	INT4	10	0	Number of Deadlocks
90	LOCKSHELD	☐	LOCKSCURR	SINT4_NOS	INT4	10	0	Locks currently held

History

Last changed by/on	SAP	20041216
SAP Release Created in	700