Data Element list used by SAP ABAP Table TST04INF (Statistics: Structure for Database Information Display)
SAP ABAP Table
TST04INF (Statistics: Structure for Database Information Display) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ACTIVE_SES | Active database server sessions | ||
| 2 | AIOVPS | Number of AIO virtual processors | ||
| 3 | BUFFERS | Number of regular shared memory buffers | ||
| 4 | BUFFERSPAC | Total size of database shared memory buffer | ||
| 5 | BUFPOOLFLU | Number of buffer pool flushes | ||
| 6 | BUFREADSI | Number of reads from shared memory buffer | ||
| 7 | BUFSIZ | System page size (KB) | ||
| 8 | BUFWRITES | Number of writes to shared memory buffer | ||
| 9 | BUFWTPCNT | Percentage of Buffer Wait Events | ||
| 10 | BUFWTS | Number of Buffer Wait Events | ||
| 11 | CHUNKWRITE | Writes resulting from a checkpoint | ||
| 12 | CKPTINTVL | Database checkpoint interval (s) | ||
| 13 | CLEANERS | Number of database buffer cleaner processes | ||
| 14 | COM_SHMSIZ | Shared memory communications portion | ||
| 15 | CORR_1 | Checkpoint activity since bootup (100% = inactive) | ||
| 16 | CORR_2 | Physical log sizing by checkpoint | ||
| 17 | CORR_3 | Logical log sizing by checkpoint | ||
| 18 | DBFILES | Number of disk files used for INFORMIX database | ||
| 19 | DBSERVERNA | Name of database server | ||
| 20 | DSKREADS | Actual reads from disk | ||
| 21 | DSKWRITES | Actual number of writes to disk | ||
| 22 | FGWRITES | Number of foreground writes | ||
| 23 | FLUSHCKPTS | Number of buffer flushes due to checkpointing | ||
| 24 | IDL_WRITES | Number of idle writes | ||
| 25 | ISAMTOT | Total number of ISAM calls since database startup | ||
| 26 | ISCALLS_SE | Transaction per minute | ||
| 27 | ISCALLS_TR | ISAM calls per transaction | ||
| 28 | ISCOMMITS | ISAM commits since database startup | ||
| 29 | ISROLLBACK | ISAM rollbacks since database startup | ||
| 30 | KAIOTHREAD | Number of kaio threads for kernel asynchronous disk I/O | ||
| 31 | LLGPAGEWRI | Number of pages written to logical logs | ||
| 32 | LLGWRITES | Number of pages written to logical log | ||
| 33 | LOCKS | Max. number of locks | ||
| 34 | LOGBUFF | Size of each of the three logical log buffers | ||
| 35 | LOGSIZ | Size of a single logical log | ||
| 36 | LRUMAXDIRT | When to begin cleaning LRU queues | ||
| 37 | LRUMINDIRT | When to stop cleaning LRU queues | ||
| 38 | LRUS | Number of LRU queues | ||
| 39 | LRUWRITES | Number of LRU writes | ||
| 40 | LTXHWM | High watermark percentage | ||
| 41 | NUMCKPTS | Number of checkpoints since database startup | ||
| 42 | NUMCPUVPS | Number of user (CPU) virtual processors | ||
| 43 | OVBUFF | Number of unsuccessful accesses to shared memory buffer | ||
| 44 | PAGES_IO_1 | Average number of kbytes to physical-log per write | ||
| 45 | PAGES_IO_2 | Average number of kbytes to logical log per write | ||
| 46 | PAGREADS | Number of Buffer Pages Read | ||
| 47 | PAGWRITES | Number of Buffer Pages Written | ||
| 48 | PC_SLEEP | Sleep time for page cleaners | ||
| 49 | PHYSBUFF | Size of the two physical log buffers | ||
| 50 | PHYSFILE | Physical log file size (KB) | ||
| 51 | PLGPAGEWRI | Number of physical log pages written | ||
| 52 | PLGWRITES | Number of writes to the physical log buffer | ||
| 53 | RA_COUNT | Total number of pages which were read ahead | ||
| 54 | RA_PAGES | Number of pages to read ahead for sequential or index scans | ||
| 55 | RA_PCNT | Percentage of pages read ahead actually used | ||
| 56 | RA_PERSCAN | Number of sequential scans per read ahead | ||
| 57 | RA_THRESH | Read ahead page trigger | ||
| 58 | RA_USED | Number of used pages from read ahead data | ||
| 59 | READ_QUALI | Percentage of successful reads from shared memory | ||
| 60 | RESET_STAT | Time since last reset statistics in seconds | ||
| 61 | RES_SHMSIZ | Resident shared menory portion | ||
| 62 | SEQSCANS | Number of sequential scans since database startup | ||
| 63 | TOT_SHMSIZ | Total size of INFORMIX shared memory | ||
| 64 | UPSINCE | Time since DB start in seconds (Informix monitor) | ||
| 65 | WRITE_QUAL | Percentage of successful writes for shared memory buffer | ||
| 66 | XMEM_ALLOC | Amount of additional virtual shared memory |