Table/Structure Field list used by SAP ABAP Program RSINF000N (INFORMIX Performance Analysis)
SAP ABAP Program
RSINF000N (INFORMIX Performance Analysis) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | PARAM_TBL - VALUE | char120 | ||
| 2 | PARAM_TBL - NAME | Character field of length 40 | ||
| 3 | RFCSI - RFCHOST | RFCCHAR8 | ||
| 4 | RFCSI - RFCOPSYS | Operating System of Application Server | ||
| 5 | SYST - VLINE | ABAP System Field: Vertical Line for List | ||
| 6 | SYST - UZEIT | ABAP System Field: Current Time of Application Server | ||
| 7 | SYST - UNAME | ABAP System Field: Name of Current User | ||
| 8 | SYST - UCOMM | ABAP System Field: PAI-Triggering Function Code | ||
| 9 | SYST - TCODE | ABAP System Field: Current Transaction Code | ||
| 10 | SYST - STARO | ABAP System Field: Top List Row Displayed | ||
| 11 | SYST - OPSYS | ABAP System Field: Operating System of Application Server | ||
| 12 | SYST - LSIND | ABAP System Field: Current List Level | ||
| 13 | SYST - LINSZ | ABAP System Field: Line Width of Current List | ||
| 14 | SYST - HOST | ABAP System Field: Name of Current Application Server | ||
| 15 | SYST - STACO | ABAP System Field: First List Column Displayed | ||
| 16 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 17 | TST04ACTLG - INFO | char120 | ||
| 18 | TST04ACTLG - PROG | ABAP Program: Current Main Program | ||
| 19 | TST04INF64 - PHYSCORR | Physical log sizing by checkpoint | ||
| 20 | TST04INF64 - PAGWRITES | Number of Buffer Pages written to Disk | ||
| 21 | TST04INF64 - PAGREADS | Number of Buffer Pages read from Disk | ||
| 22 | TST04INF64 - PAGESIZE | System page size (KB) | ||
| 23 | TST04INF64 - NUMCPUVPS | Number of user (CPU) virtual processors | ||
| 24 | TST04INF64 - NUMCKPTS | Number of checkpoints since database startup | ||
| 25 | TST04INF64 - NUMAIOVPS | Number of AIO virtual processors | ||
| 26 | TST04INF64 - MEMSORTS | Number of Sort Events in Memory | ||
| 27 | TST04INF64 - MAXSORTSPC | Max Sort Space | ||
| 28 | TST04INF64 - MAXPDQPRIO | Max PDQ Priority | ||
| 29 | TST04INF64 - LRUWRITES | Number of lru writes | ||
| 30 | TST04INF64 - DSTOTALMEM | DS Total Memory | ||
| 31 | TST04INF64 - LRUS | Number of LRU queues | ||
| 32 | TST04INF64 - PHYSFILE | Physical log file size (KB) | ||
| 33 | TST04INF64 - PHYSLOG_IO | Percentage of physical log buffer per write | ||
| 34 | TST04INF64 - RA_PCNT | Percentage of pages read ahead actually used | ||
| 35 | TST04INF64 - READQUAL | Percentage of successful reads from shared memory | ||
| 36 | TST04INF64 - SEQSCANS | Number of sequential scans | ||
| 37 | TST04INF64 - SHMMES | Shared memory communications portion | ||
| 38 | TST04INF64 - SHMRES | Resident shared menory portion | ||
| 39 | TST04INF64 - SHMTOTAL | Total size of INFORMIX shared memory | ||
| 40 | TST04INF64 - SHMVIRT | Amount of additional virtual shared memory | ||
| 41 | TST04INF64 - SHMVSEGCNT | Number of Virtual Shared Memory Segments | ||
| 42 | TST04INF64 - SQLREADLD | Load of SQL read activity: buffer reads / (isreads+isstart) | ||
| 43 | TST04INF64 - WRITEACTIV | Percentage of Write Activity over Read Activity | ||
| 44 | TST04INF64 - WRITEQUAL | Percentage of successful writes for shared memory buffer | ||
| 45 | TST04INF64 - LRUMAXDIRT | When to begin cleaning LRU queues | ||
| 46 | TST04INF64 - ACTIVESESS | Active database server sessions | ||
| 47 | TST04INF64 - BUFFERS | Number of regular shared memory buffers | ||
| 48 | TST04INF64 - BUFREADS | Number of reads from shared memory buffer | ||
| 49 | TST04INF64 - BUFSIZETOT | Total size of database shared memory buffer | ||
| 50 | TST04INF64 - BUFWRITES | Number of writes to shared memory buffer | ||
| 51 | TST04INF64 - BUFWTPCNT | Percentage of Buffer Wait Events | ||
| 52 | TST04INF64 - CHUNKWRITE | Writes resulting from a checkpoint | ||
| 53 | TST04INF64 - CKPTCORR | Checkpoint activity since bootup (100% = inactive) | ||
| 54 | TST04INF64 - CKPTINTVL | Database checkpoint interval (s) | ||
| 55 | TST04INF64 - CLEANERS | Number of database buffer cleaner processes | ||
| 56 | TST04INF64 - DBFILES | Number of disk files used for INFORMIX database | ||
| 57 | TST04INF64 - DEADLKS | Number of Deadlocks | ||
| 58 | TST04INF64 - DISKSORTS | Number of Sort Events in Memory | ||
| 59 | TST04INF64 - DSKREADS | Actual reads (I/O requests) from disk | ||
| 60 | TST04INF64 - DSKWRITES | Actual number of writes (I/O requests) to disk | ||
| 61 | TST04INF64 - DSMAXQUERY | DS Max Queries | ||
| 62 | TST04INF64 - DSMAXSCANS | DS Max Scans | ||
| 63 | TST04INF64 - FGWRITES | Number of foreground writes | ||
| 64 | TST04INF64 - KAIOTHREAD | Number of kaio threads for kernel asynchronous disk I/O | ||
| 65 | TST04INF64 - LOCKSHELD | Locks currently held | ||
| 66 | TST04INF64 - LOCKWTPCNT | Lock Wait Events per Lock Requests (ppm) | ||
| 67 | TST04INF64 - LOGLOG_IO | Percentage of logical log buffer per write | ||
| 68 | TST04INF64 - LOGSIZETOT | Total Size of Logical Log (Kb) | ||
| 69 | TST04INF64 - LONG_TX | Number of Long Transactions (aborted) | ||
| 70 | TST04INF64 - LRUMINDIRT | When to stop cleaning LRU queues | ||
| 71 | TUNESTRUCT - VERSION | INFORMIX version (short one) |