TST04INF64 SAP (Statistics: Structure for Database Information Display) Structure details
Description: Statistics: Structure for Database Information Display
Structure field list including key, data, relationships and ABAP select examples
TST04INF64 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Statistics: Structure for Database Information Display" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_TST04INF64 TYPE TST04INF64.
The TST04INF64 table consists of various fields, each holding specific information or linking keys about Statistics: Structure for Database Information Display data available in SAP. These include BUFREADS (Number of reads from shared memory buffer), DSKREADS (Actual reads (I/O requests) from disk), BUFWRITES (Number of writes to shared memory buffer), DSKWRITES (Actual number of writes (I/O requests) to disk).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: S - System table, maint. only by SAP, change = modificationDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP TST04INF64 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
BUFSIZETOT | Total size of database shared memory buffer | BUFFERSPAC | INT4 | 10 | SINT4_NOS | ||||
BUFREADS | Number of reads from shared memory buffer | BUFREADS64 | DEC | 18 | STUI_INT64 | ||||
DSKREADS | Actual reads (I/O requests) from disk | DSKREADS64 | DEC | 18 | STUI_INT64 | ||||
BUFWRITES | Number of writes to shared memory buffer | BUFWRITS64 | DEC | 18 | STUI_INT64 | ||||
DSKWRITES | Actual number of writes (I/O requests) to disk | DSKWRITS64 | DEC | 18 | STUI_INT64 | ||||
PLGPAGEWRI | Number of physical log pages written | PLGPGWRI64 | DEC | 18 | STUI_INT64 | ||||
PLGWRITES | Number of writes to the physical log | PLGWRITS64 | DEC | 18 | STUI_INT64 | ||||
LLGPAGEWRI | Number of logical log pages written | LLGPGWRI64 | DEC | 18 | STUI_INT64 | ||||
LLGWRITES | Number of writes to the logical log | LLGWRITS64 | DEC | 18 | STUI_INT64 | ||||
BUFPOOLFLU | Number of buffer pool flushes | BUFPOOLFLU | INT4 | 10 | SINT4_NOS | ||||
FGWRITES | Number of foreground writes | FGWRITES64 | DEC | 18 | STUI_INT64 | ||||
LRUWRITES | Number of lru writes | LRUWRITS64 | DEC | 18 | STUI_INT64 | ||||
CHUNKWRITE | Writes resulting from a checkpoint | CHKWRITS64 | DEC | 18 | STUI_INT64 | ||||
ISCOMMITS | ISAM commits since database startup | ISCOMMIT64 | DEC | 18 | STUI_INT64 | ||||
ISROLLBACK | ISAM rollbacks since database startup | ISROLLBK64 | DEC | 18 | STUI_INT64 | ||||
ISAMTOT | Total number of ISAM calls | ISAMTOT64 | DEC | 18 | STUI_INT64 | ||||
SEQSCANS | Number of sequential scans | SEQSCANS64 | DEC | 18 | STUI_INT64 | ||||
NUMCKPTS | Number of checkpoints since database startup | NUMCKPTS | INT4 | 10 | SINT4_NOS | ||||
READQUAL | Percentage of successful reads from shared memory | READ_QUALI | INT4 | 10 | SINT4_NOS | ||||
WRITEQUAL | Percentage of successful writes for shared memory buffer | WRITE_QUAL | INT4 | 10 | SINT4_NOS | ||||
PHYSLOG_IO | Percentage of physical log buffer per write | PAGES_PC_1 | INT4 | 10 | SINT4_NOS | ||||
LOGLOG_IO | Percentage of logical log buffer per write | PAGES_PC_2 | INT4 | 10 | SINT4_NOS | ||||
ACTIVESESS | Active database server sessions | ACTIVE_SES | INT4 | 10 | SINT4_NOS | ||||
TRANS_MIN | Transaction per minute | ISCALLS_SE | INT4 | 10 | SINT4_NOS | ||||
ISCALLS_TR | ISAM calls per transaction | ISCALLS_TR | INT4 | 10 | SINT4_NOS | ||||
CKPTCORR | Checkpoint activity since bootup (100% = inactive) | CORR_1 | INT4 | 10 | SINT4_NOS | ||||
PHYSCORR | Physical log sizing by checkpoint | CORR_2 | INT4 | 10 | SINT4_NOS | ||||
CORR_3 | Logical log sizing by checkpoint | CORR_3 | INT4 | 10 | SINT4_NOS | ||||
BUFFERS | Number of regular shared memory buffers | BUFFERS | INT4 | 10 | SINT4_NOS | ||||
PAGESIZE | System page size (KB) | BUFSIZ | INT4 | 10 | SINT4_NOS | ||||
PHYSBUFF | Size of the two physical log buffers | PHYSBUFF | INT4 | 10 | SINT4_NOS | ||||
LOGBUFF | Size of each of the three logical log buffers | LOGBUFF | INT4 | 10 | SINT4_NOS | ||||
CLEANERS | Number of database buffer cleaner processes | CLEANERS | INT4 | 10 | SINT4_NOS | ||||
LRUS | Number of LRU queues | LRUS | INT4 | 10 | SINT4_NOS | ||||
LRUMAXDIRT | When to begin cleaning LRU queues | LRUMAXDIRT | INT4 | 10 | SINT4_NOS | ||||
LRUMINDIRT | When to stop cleaning LRU queues | LRUMINDIRT | INT4 | 10 | SINT4_NOS | ||||
CKPTINTVL | Database checkpoint interval (s) | CKPTINTVL | INT4 | 10 | SINT4_NOS | ||||
NUMCPUVPS | Number of user (CPU) virtual processors | NUMCPUVPS | INT4 | 10 | SINT4_NOS | ||||
PHYSFILE | Physical log file size (KB) | PHYSFILE | INT4 | 10 | SINT4_NOS | ||||
LOGSIZ | Size of a single logical log | LOGSIZ | INT4 | 10 | SINT4_NOS | ||||
LOGFILES | Number of Log Files | LOGFILES | INT4 | 10 | SINT4_NOS | ||||
LOGSIZETOT | Total Size of Logical Log (Kb) | LOGSIZETOT | INT4 | 10 | SINT4_NOS | ||||
DBSERVERNA | Name of database server | DBSERVERNA | CHAR | 20 | CHAR20 | ||||
LTXHWM | High watermark percentage | LTXHWM | INT4 | 10 | SINT4_NOS | ||||
LOCKS | Max. number of locks | LOCKS | INT4 | 10 | SINT4_NOS | ||||
RA_PAGES | Number of pages to read ahead for sequential or index scans | RA_PAGES | INT4 | 10 | SINT4_NOS | ||||
RA_THRESH | Read ahead page trigger | RA_THRESH | INT4 | 10 | SINT4_NOS | ||||
RA_USED | Read ahead pages used | RA_USED64 | DEC | 18 | STUI_INT64 | ||||
RA_COUNT | Sum of read ahead pages | RA_COUNT64 | DEC | 18 | STUI_INT64 | ||||
RA_PERSCAN | Number of sequential scans per read ahead | RA_PERSCAN | INT4 | 10 | SINT4_NOS | ||||
RA_PCNT | Percentage of pages read ahead actually used | RA_PCNT | DEC | 4(1) | STUI_PCNT | ||||
IDL_WRITES | Number of idle writes | IDL_WRITES | INT4 | 10 | SINT4_NOS | ||||
PC_SLEEP | Sleep time for page cleaners | PC_SLEEP | INT4 | 10 | SINT4_NOS | ||||
OVBUFF | Number of unsuccessful accesses to shared memory buffer | OVBUFF | INT4 | 10 | SINT4_NOS | ||||
SHMVIRT | Amount of additional virtual shared memory | XMEM_ALLOC | INT4 | 10 | SINT4_NOS | ||||
FLUSHCKPTS | Number of buffer flushes due to checkpointing | FLUSHCKPTS | INT4 | 10 | SINT4_NOS | ||||
SHMTOTAL | Total size of INFORMIX shared memory | TOT_SHMSIZ | INT4 | 10 | SINT4_NOS | ||||
NUMAIOVPS | Number of AIO virtual processors | AIOVPS | INT4 | 10 | SINT4_NOS | ||||
DBFILES | Number of disk files used for INFORMIX database | DBFILES | INT4 | 10 | SINT4_NOS | ||||
SHMRES | Resident shared menory portion | RES_SHMSIZ | INT4 | 10 | SINT4_NOS | ||||
SHMMES | Shared memory communications portion | COM_SHMSIZ | INT4 | 10 | SINT4_NOS | ||||
KAIOTHREAD | Number of kaio threads for kernel asynchronous disk I/O | KAIOTHREAD | INT4 | 10 | SINT4_NOS | ||||
UP_SINCE | Time since DB start in seconds (Informix monitor) | UPSINCE | INT4 | 10 | INT4 | ||||
RESET_STAT | Time since last reset statistics in seconds | RESET_STAT | INT4 | 10 | INT4 | ||||
PAGREADS | Number of Buffer Pages read from Disk | PAGREADS64 | DEC | 18 | STUI_INT64 | ||||
PAGWRITES | Number of Buffer Pages written to Disk | PAGWRITS64 | DEC | 18 | STUI_INT64 | ||||
BUFWTS | Number of Buffer Wait Events | BUFWAITS64 | DEC | 18 | STUI_INT64 | ||||
BUFWTPCNT | Percentage of Buffer Wait Events | BUFWTPCNT | DEC | 4(1) | STUI_PCNT | ||||
MAXPDQPRIO | Max PDQ Priority | MAXPDQPRIO | INT4 | 10 | SINT4_NOS | ||||
DSMAXQUERY | DS Max Queries | DSMAXQUERY | INT4 | 10 | SINT4_NOS | ||||
DSMAXSCANS | DS Max Scans | DSMAXSCANS | INT4 | 10 | SINT4_NOS | ||||
DSTOTALMEM | DS Total Memory | DSTOTALMEM | INT4 | 10 | SINT4_NOS | ||||
ISAMREADS | ISAM Read Calls | ISREADS64 | DEC | 18 | STUI_INT64 | ||||
ISAMWRITES | ISAM Write Calls | ISWRITES64 | DEC | 18 | STUI_INT64 | ||||
ISAMREWRIT | ISAM Rewrite Calls | ISREWRIT64 | DEC | 18 | STUI_INT64 | ||||
ISAMDELETE | ISAM Delete Calls | ISDELETE64 | DEC | 18 | STUI_INT64 | ||||
ISAMSTARTS | ISAM Start Calls (Index read) | ISSTARTS64 | DEC | 18 | STUI_INT64 | ||||
MAXSORTSPC | Max Sort Space | MAXSORTSPC | INT4 | 10 | SINT4_NOS | ||||
SHMVSEGCNT | Number of Virtual Shared Memory Segments | SHMVSEGCNT | INT4 | 10 | SINT4_NOS | ||||
SQLREADLD | Load of SQL read activity: buffer reads / (isreads+isstart) | SQLREADLD | DEC | 5(1) | STUI_1000 | ||||
MEMSORTS | Number of Sort Events in Memory | MEMSORTS | DEC | 18 | STUI_INT64 | ||||
DISKSORTS | Number of Sort Events in Memory | DISKSORTS | DEC | 18 | STUI_INT64 | ||||
WRITEACTIV | Percentage of Write Activity over Read Activity | WRITEACTIV | DEC | 4(1) | STUI_PCNT | ||||
LONG_TX | Number of Long Transactions (aborted) | LONG_TX | INT4 | 10 | SINT4_NOS | ||||
LOCKWAITS | Number of Lock Wait Events | LOCKWAIT64 | DEC | 18 | STUI_INT64 | ||||
LOCKREQS | Number of Lock Requests | LOCKREQS64 | DEC | 18 | STUI_INT64 | ||||
LOCKWTPCNT | Lock Wait Events per Lock Requests (ppm) | LOCKWTPCNT | INT4 | 10 | SINT4_NOS | ||||
LKTOUTS | Number of Lock Timeout Events | LOCKTOUTS | INT4 | 10 | SINT4_NOS | ||||
DEADLKS | Number of Deadlocks | DEADLCKS | INT4 | 10 | SINT4_NOS | ||||
LOCKSHELD | Locks currently held | LOCKSCURR | INT4 | 10 | SINT4_NOS |
Key field | Non-key field |
How do I retrieve data from SAP structure TST04INF64 using ABAP code?
As TST04INF64 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TST04INF64 as there is no data to select.How to access SAP table TST04INF64
Within an ECC or HANA version of SAP you can also view further information about TST04INF64 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects