Table/Structure Field list used by SAP ABAP Program LSDB2CCMS_TOOLSBPT (DB2 z/OS: Buffer Pool Tuning)
SAP ABAP Program
LSDB2CCMS_TOOLSBPT (DB2 z/OS: Buffer Pool Tuning) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ALV_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | ||
| 2 | ALV_S_FCAT - COL_POS | ALV control: Output column | ||
| 3 | ALV_S_FCAT - SELTEXT | ALV control: Column identifier for dialog functions | ||
| 4 | ALV_S_FCAT - ROLLNAME | ALV control: Data element for F1 help | ||
| 5 | ALV_S_FCAT - OUTPUTLEN | ALV control: Column width in characters | ||
| 6 | ALV_S_FCAT - NO_OUT | ALV control: Column is not output | ||
| 7 | ALV_S_FCAT - LOWERCASE | Lowercase letters allowed/not allowed | ||
| 8 | ALV_S_FCAT - KEY | ALV control: Key field | ||
| 9 | ALV_S_FCAT - INTTYPE | ABAP data type (C,D,N,...) | ||
| 10 | DB2BPTUNE - CATEGORY | DB2 for OS/390: Table category | ||
| 11 | DB2BPTUNE - CREATOR | Creator of BP tuning settings ( = SAP for default settings ) | ||
| 12 | DB2BPTUNE - QDBPCAST | CASTOUT attribute | ||
| 13 | DB2BPTUNE - QDBPDWQT | The deferred write threshold for the virtual buffer pool | ||
| 14 | DB2BPTUNE - QDBPHPSH | The sequential steal threshold for the hiperpool | ||
| 15 | DB2BPTUNE - QDBPHPSZ | The size of the hiperpool | ||
| 16 | DB2BPTUNE - QDBPNM | Name of buffer pool | ||
| 17 | DB2BPTUNE - QDBPVDQT | The vertical deferred write threshold for the virtual BP | ||
| 18 | DB2BPTUNE - QDBPVPSH | The sequential steal threshold for the virtual buffer pool | ||
| 19 | DB2BPTUNE - QDBPVPSZ | The size of the virtual buffer pool | ||
| 20 | DB2BPTUNE - VPTYPE | DB2BPTUNE-VPTYPE | ||
| 21 | DB2BPTUNE1 - CSTOTOT | DB2/390: Total central storage available for all bufferpools | ||
| 22 | DB2IXDETL - INDEXSPACE | Name of the indexspace that contains the index | ||
| 23 | DB2IXDETL - NAME | Name of a DB2 for OS/390 index | ||
| 24 | DB2IXDETL - CREATOR | DB2 creator name | ||
| 25 | DB2QDBP - QDBPNM | Name of buffer pool | ||
| 26 | DB2QDBP - QDBPVPTY | Type of virtual buffer pool | ||
| 27 | DB2SAPSYS - DBSCHEMA | DB2 creator name | ||
| 28 | DB2STATDEC - DBNAME | Database name | ||
| 29 | DB2STATDEC - TSNAME | Name of the tablespace | ||
| 30 | DB2STATDEC - TNAME | DB2 table name | ||
| 31 | DB2STATDEC - SIZE_KB | DB2 for OS/390: Table size ( pages * reclength / 1024 ) | ||
| 32 | DB2STATDEC - CATEGORY | DB2 for OS/390: Table category | ||
| 33 | DB2STATDEC - BPSUG | Suggested DB2 buffer pool | ||
| 34 | DB2STATDEC - BPOOL | Name of the DB2 buffer pool currently used for the TS | ||
| 35 | DB2STATDEC - ACCESS_FR | DB2 OS/390: Access frequency: max(executes , affected rows) | ||
| 36 | DB2TDUMMY - DB2REL | DB2 release | ||
| 37 | DBCON - CON_NAME | Logical name for a database connection | ||
| 38 | DBSTATDEC - UPDCNT | No. of UPDATE commands | ||
| 39 | DBSTATDEC - TNAME | Table name | ||
| 40 | DBSTATDEC - SEQ_ROW | Number of records read at sequential read operations | ||
| 41 | DBSTATDEC - SEQ_FETCH | Number of FETCHes for sequential read commands | ||
| 42 | DBSTATDEC - INSCNT | No. of INSERT attempts | ||
| 43 | DBSTATDEC - REF | Table type (short text) | ||
| 44 | DBSTATDEC - BUF | Buffer mode of an SAP table | ||
| 45 | DBSTATDEC - DIR_FETCH | Number of FETCHes for direct read commands (SELECT SINGLE) | ||
| 46 | DBSTATDEC - DELCNT | No. of DELETE attempts | ||
| 47 | DD06L - SQLTAB | Name of Pool/Cluster in the Database | ||
| 48 | LINETAB - LINE | The SQL statement text | ||
| 49 | LVC_S_FCAT - LOWERCASE | Lowercase letters allowed/not allowed | ||
| 50 | LVC_S_FCAT - SELTEXT | ALV control: Column identifier for dialog functions | ||
| 51 | LVC_S_FCAT - ROLLNAME | ALV control: Data element for F1 help | ||
| 52 | LVC_S_FCAT - OUTPUTLEN | ALV control: Column width in characters | ||
| 53 | LVC_S_FCAT - NO_OUT | ALV control: Column is not output | ||
| 54 | LVC_S_FCAT - KEY | ALV control: Key field | ||
| 55 | LVC_S_FCAT - INTTYPE | ABAP data type (C,D,N,...) | ||
| 56 | LVC_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | ||
| 57 | LVC_S_FCAT - EDIT | ALV control: Ready for input | ||
| 58 | LVC_S_FCAT - COL_POS | ALV control: Output column | ||
| 59 | LVC_S_FCAT - COLTEXT | ALV control: Column heading | ||
| 60 | LVC_S_ROW - INDEX | ALV control: Row number (index of internal table) | ||
| 61 | MSXXLIST - NAME | Application Server Instance | ||
| 62 | SAPWLACCTP - PERIODTYPE | SAP Workload: Period type | ||
| 63 | SAPWLACCTP - STARTDATE | SAP Workload: Start date of meas. period | ||
| 64 | SAPWLSERV - HOSTSHORT | Abbreviated Host Name | ||
| 65 | SAPWLSERV - HOST | Host Name | ||
| 66 | SAPWLTADIR - STARTDATE | Start day for period | ||
| 67 | SAPWLTASTR - INSTNOCHAR | Version Number Component | ||
| 68 | SCXTAB_CONTROL - CURRENT_LINE | SCXTAB_CONTROL-CURRENT_LINE | ||
| 69 | SCXTAB_CONTROL - LINES | SCXTAB_CONTROL-LINES | ||
| 70 | SCXTAB_CONTROL - TOP_LINE | SCXTAB_CONTROL-TOP_LINE | ||
| 71 | STB_BUTTON - BUTN_TYPE | Toolbar button type | ||
| 72 | STB_BUTTON - DISABLED | STB_BUTTON-DISABLED | ||
| 73 | STB_BUTTON - FUNCTION | Function code | ||
| 74 | STB_BUTTON - ICON | Name of an Icon | ||
| 75 | STB_BUTTON - QUICKINFO | Quickinfo for an icon | ||
| 76 | STB_BUTTON - TEXT | Text, 40 Characters Long | ||
| 77 | STU3COTABS - COMMNAME | Logical name of DB2/390 or OS/390 command | ||
| 78 | STU3COTABS - COMMTYPE | Type of DB2/390 or OS/390 command | ||
| 79 | STU3COTABS - COMMTEXT4 | Text of logical command for DB2/390 or OS/390 | ||
| 80 | STU3COTABS - COMMTEXT3 | Text of logical command for DB2/390 or OS/390 | ||
| 81 | STU3COTABS - COMMTEXT2 | Text of logical command for DB2/390 or OS/390 | ||
| 82 | STU3COTABS - COMMTEXT1 | Text of logical command for DB2/390 or OS/390 | ||
| 83 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 84 | SYST - SAPRL | ABAP System Field: SAP System Release | ||
| 85 | SYST - STEPL | ABAP System Field: Current Step Loop or Table Control Line | ||
| 86 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 87 | SYST - UCOMM | ABAP System Field: PAI-Triggering Function Code | ||
| 88 | SYST - UZEIT | ABAP System Field: Current Time of Application Server |