Table/Structure Field list used by SAP ABAP Program LSTD2F02 (Subroutines for DB_INF_MAIN_LIST)
SAP ABAP Program
LSTD2F02 (Subroutines for DB_INF_MAIN_LIST) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | PARAM_TBL - VALUE | char120 | ||
| 2 | PARAM_TBL - NAME | Character field of length 40 | ||
| 3 | SYST - FDPOS | ABAP System Field: Occurrence in Byte or Character String | ||
| 4 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 5 | TST04INF - LRUWRITES | Number of LRU writes | ||
| 6 | TST04INF - WRITEQUAL | Percentage of successful writes for shared memory buffer | ||
| 7 | TST04INF - NUMCKPTS | Number of checkpoints since database startup | ||
| 8 | TST04INF - PAGESIZE | System page size (KB) | ||
| 9 | TST04INF - PAGREADS | Number of Buffer Pages Read | ||
| 10 | TST04INF - PAGWRITES | Number of Buffer Pages Written | ||
| 11 | TST04INF - PHYSCORR | Physical log sizing by checkpoint | ||
| 12 | TST04INF - PHYSFILE | Physical log file size (KB) | ||
| 13 | TST04INF - PHYSLOG_IO | Average number of kbytes to physical-log per write | ||
| 14 | TST04INF - PLGPAGEWRI | Number of physical log pages written | ||
| 15 | TST04INF - PLGWRITES | Number of writes to the physical log buffer | ||
| 16 | TST04INF - RA_COUNT | Total number of pages which were read ahead | ||
| 17 | TST04INF - RA_PCNT | Percentage of pages read ahead actually used | ||
| 18 | TST04INF - RA_USED | Number of used pages from read ahead data | ||
| 19 | TST04INF - READQUAL | Percentage of successful reads from shared memory | ||
| 20 | TST04INF - RESET_STAT | Time since last reset statistics in seconds | ||
| 21 | TST04INF - SEQSCANS | Number of sequential scans since database startup | ||
| 22 | TST04INF - SHMMES | Shared memory communications portion | ||
| 23 | TST04INF - SHMRES | Resident shared menory portion | ||
| 24 | TST04INF - SHMTOTAL | Total size of INFORMIX shared memory | ||
| 25 | TST04INF - SHMVIRT | Amount of additional virtual shared memory | ||
| 26 | TST04INF - TRANS_MIN | Transaction per minute | ||
| 27 | TST04INF - UP_SINCE | Time since DB start in seconds (Informix monitor) | ||
| 28 | TST04INF - DBFILES | Number of disk files used for INFORMIX database | ||
| 29 | TST04INF - ACTIVESESS | Active database server sessions | ||
| 30 | TST04INF - BUFFERS | Number of regular shared memory buffers | ||
| 31 | TST04INF - BUFPOOLFLU | Number of buffer pool flushes | ||
| 32 | TST04INF - BUFREADS | Number of reads from shared memory buffer | ||
| 33 | TST04INF - BUFSIZETOT | Total size of database shared memory buffer | ||
| 34 | TST04INF - BUFWRITES | Number of writes to shared memory buffer | ||
| 35 | TST04INF - BUFWTPCNT | Percentage of Buffer Wait Events | ||
| 36 | TST04INF - BUFWTS | Number of Buffer Wait Events | ||
| 37 | TST04INF - CHUNKWRITE | Writes resulting from a checkpoint | ||
| 38 | TST04INF - CKPTCORR | Checkpoint activity since bootup (100% = inactive) | ||
| 39 | TST04INF - CKPTINTVL | Database checkpoint interval (s) | ||
| 40 | TST04INF - LOGLOG_IO | Average number of kbytes to logical log per write | ||
| 41 | TST04INF - DSKREADS | Actual reads from disk | ||
| 42 | TST04INF - DSKWRITES | Actual number of writes to disk | ||
| 43 | TST04INF - FGWRITES | Number of foreground writes | ||
| 44 | TST04INF - ISAMTOT | Total number of ISAM calls since database startup | ||
| 45 | TST04INF - ISCALLS_TR | ISAM calls per transaction | ||
| 46 | TST04INF - ISCOMMITS | ISAM commits since database startup | ||
| 47 | TST04INF - ISROLLBACK | ISAM rollbacks since database startup | ||
| 48 | TST04INF - KAIOTHREAD | Number of kaio threads for kernel asynchronous disk I/O | ||
| 49 | TST04INF - LLGPAGEWRI | Number of pages written to logical logs | ||
| 50 | TST04INF - LLGWRITES | Number of pages written to logical log | ||
| 51 | TST04INF - LOCKS | Max. number of locks |