Table/Structure Field list used by SAP ABAP Program LSTD2F09 (Forms for DB_INF_MAIN_LIST_64 et.al.)
SAP ABAP Program 
LSTD2F09 (Forms for DB_INF_MAIN_LIST_64 et.al.) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
PARAM_TBL - VALUE | char120 | |
| 2 | Table/Structure Field |
PARAM_TBL - NAME | Character field of length 40 | |
| 3 | Table/Structure Field |
TST04INF64 - PLGWRITES | Number of writes to the physical log | |
| 4 | Table/Structure Field |
TST04INF64 - LOCKWTPCNT | Lock Wait Events per Lock Requests (ppm) | |
| 5 | Table/Structure Field |
TST04INF64 - LOGBUFF | Size of each of the three logical log buffers | |
| 6 | Table/Structure Field |
TST04INF64 - LOGLOG_IO | Percentage of logical log buffer per write | |
| 7 | Table/Structure Field |
TST04INF64 - LRUWRITES | Number of lru writes | |
| 8 | Table/Structure Field |
TST04INF64 - MAXSORTSPC | Max Sort Space | |
| 9 | Table/Structure Field |
TST04INF64 - MEMSORTS | Number of Sort Events in Memory | |
| 10 | Table/Structure Field |
TST04INF64 - NUMCKPTS | Number of checkpoints since database startup | |
| 11 | Table/Structure Field |
TST04INF64 - PAGESIZE | System page size (KB) | |
| 12 | Table/Structure Field |
TST04INF64 - PAGREADS | Number of Buffer Pages read from Disk | |
| 13 | Table/Structure Field |
TST04INF64 - PAGWRITES | Number of Buffer Pages written to Disk | |
| 14 | Table/Structure Field |
TST04INF64 - PHYSBUFF | Size of the two physical log buffers | |
| 15 | Table/Structure Field |
TST04INF64 - PHYSCORR | Physical log sizing by checkpoint | |
| 16 | Table/Structure Field |
TST04INF64 - PHYSFILE | Physical log file size (KB) | |
| 17 | Table/Structure Field |
TST04INF64 - PHYSLOG_IO | Percentage of physical log buffer per write | |
| 18 | Table/Structure Field |
TST04INF64 - PLGPAGEWRI | Number of physical log pages written | |
| 19 | Table/Structure Field |
TST04INF64 - WRITEQUAL | Percentage of successful writes for shared memory buffer | |
| 20 | Table/Structure Field |
TST04INF64 - RA_COUNT | Sum of read ahead pages | |
| 21 | Table/Structure Field |
TST04INF64 - RA_PCNT | Percentage of pages read ahead actually used | |
| 22 | Table/Structure Field |
TST04INF64 - RA_USED | Read ahead pages used | |
| 23 | Table/Structure Field |
TST04INF64 - READQUAL | Percentage of successful reads from shared memory | |
| 24 | Table/Structure Field |
TST04INF64 - RESET_STAT | Time since last reset statistics in seconds | |
| 25 | Table/Structure Field |
TST04INF64 - SEQSCANS | Number of sequential scans | |
| 26 | Table/Structure Field |
TST04INF64 - SHMMES | Shared memory communications portion | |
| 27 | Table/Structure Field |
TST04INF64 - SHMRES | Resident shared menory portion | |
| 28 | Table/Structure Field |
TST04INF64 - SHMTOTAL | Total size of INFORMIX shared memory | |
| 29 | Table/Structure Field |
TST04INF64 - SHMVIRT | Amount of additional virtual shared memory | |
| 30 | Table/Structure Field |
TST04INF64 - SHMVSEGCNT | Number of Virtual Shared Memory Segments | |
| 31 | Table/Structure Field |
TST04INF64 - SQLREADLD | Load of SQL read activity: buffer reads / (isreads+isstart) | |
| 32 | Table/Structure Field |
TST04INF64 - TRANS_MIN | Transaction per minute | |
| 33 | Table/Structure Field |
TST04INF64 - UP_SINCE | Time since DB start in seconds (Informix monitor) | |
| 34 | Table/Structure Field |
TST04INF64 - WRITEACTIV | Percentage of Write Activity over Read Activity | |
| 35 | Table/Structure Field |
TST04INF64 - BUFWTS | Number of Buffer Wait Events | |
| 36 | Table/Structure Field |
TST04INF64 - DSKWRITES | Actual number of writes (I/O requests) to disk | |
| 37 | Table/Structure Field |
TST04INF64 - DSKREADS | Actual reads (I/O requests) from disk | |
| 38 | Table/Structure Field |
TST04INF64 - DISKSORTS | Number of Sort Events in Memory | |
| 39 | Table/Structure Field |
TST04INF64 - DEADLKS | Number of Deadlocks | |
| 40 | Table/Structure Field |
TST04INF64 - DBFILES | Number of disk files used for INFORMIX database | |
| 41 | Table/Structure Field |
TST04INF64 - CKPTINTVL | Database checkpoint interval (s) | |
| 42 | Table/Structure Field |
TST04INF64 - CKPTCORR | Checkpoint activity since bootup (100% = inactive) | |
| 43 | Table/Structure Field |
TST04INF64 - CHUNKWRITE | Writes resulting from a checkpoint | |
| 44 | Table/Structure Field |
TST04INF64 - LOCKSHELD | Locks currently held | |
| 45 | Table/Structure Field |
TST04INF64 - BUFWTPCNT | Percentage of Buffer Wait Events | |
| 46 | Table/Structure Field |
TST04INF64 - BUFWRITES | Number of writes to shared memory buffer | |
| 47 | Table/Structure Field |
TST04INF64 - BUFSIZETOT | Total size of database shared memory buffer | |
| 48 | Table/Structure Field |
TST04INF64 - BUFREADS | Number of reads from shared memory buffer | |
| 49 | Table/Structure Field |
TST04INF64 - BUFPOOLFLU | Number of buffer pool flushes | |
| 50 | Table/Structure Field |
TST04INF64 - BUFFERS | Number of regular shared memory buffers | |
| 51 | Table/Structure Field |
TST04INF64 - ACTIVESESS | Active database server sessions | |
| 52 | Table/Structure Field |
TST04INF64 - ISAMDELETE | ISAM Delete Calls | |
| 53 | Table/Structure Field |
TST04INF64 - LOCKWAITS | Number of Lock Wait Events | |
| 54 | Table/Structure Field |
TST04INF64 - LOCKREQS | Number of Lock Requests | |
| 55 | Table/Structure Field |
TST04INF64 - LLGWRITES | Number of writes to the logical log | |
| 56 | Table/Structure Field |
TST04INF64 - LLGPAGEWRI | Number of logical log pages written | |
| 57 | Table/Structure Field |
TST04INF64 - LKTOUTS | Number of Lock Timeout Events | |
| 58 | Table/Structure Field |
TST04INF64 - KAIOTHREAD | Number of kaio threads for kernel asynchronous disk I/O | |
| 59 | Table/Structure Field |
TST04INF64 - ISROLLBACK | ISAM rollbacks since database startup | |
| 60 | Table/Structure Field |
TST04INF64 - ISCOMMITS | ISAM commits since database startup | |
| 61 | Table/Structure Field |
TST04INF64 - ISCALLS_TR | ISAM calls per transaction | |
| 62 | Table/Structure Field |
TST04INF64 - ISAMWRITES | ISAM Write Calls | |
| 63 | Table/Structure Field |
TST04INF64 - ISAMTOT | Total number of ISAM calls | |
| 64 | Table/Structure Field |
TST04INF64 - ISAMSTARTS | ISAM Start Calls (Index read) | |
| 65 | Table/Structure Field |
TST04INF64 - ISAMREWRIT | ISAM Rewrite Calls | |
| 66 | Table/Structure Field |
TST04INF64 - ISAMREADS | ISAM Read Calls | |
| 67 | Table/Structure Field |
TST04INF64 - FGWRITES | Number of foreground writes | |
| 68 | Table/Structure Field |
TST04PR64 - CLEARVAL | STUI: some very long integer | |
| 69 | Table/Structure Field |
TST04PR64 - NAME | STUI: Parameter name | |
| 70 | Table/Structure Field |
TST04PR64 - RESETVAL | STUI: some very long integer | |
| 71 | Table/Structure Field |
TST04PR64 - SUMVAL | STUI: sum of some very long integer |
