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