DB2_SHOW_SYSTEM_PARM_LONG SAP (Output Structure for Dynpro 0100 of Program RSDB2CKRD) Structure details
Description: Output Structure for Dynpro 0100 of Program RSDB2CKRD
Related tables to DB2_SHOW_SYSTEM_PARM_LONG
Access table DB2_SHOW_SYSTEM_PARM_LONG
Structure field list including key, data, relationships and ABAP select examples
DB2_SHOW_SYSTEM_PARM_LONG is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Output Structure for Dynpro 0100 of Program RSDB2CKRD" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_DB2_SHOW_SYSTEM_PARM_LONG TYPE DB2_SHOW_SYSTEM_PARM_LONG.
The DB2_SHOW_SYSTEM_PARM_LONG table consists of various fields, each holding specific information or linking keys about Output Structure for Dynpro 0100 of Program RSDB2CKRD data available in SAP. These include CHECKDATE (DB2 for OS/390: Date of the check), CHECKTIME (DB2 for OS/390: Time of the check), CHECKTYPE (Type of Check for DB2 Installation Parameter(s) Check), RESULT (Result of DB2 Installation Parameter Check).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP DB2_SHOW_SYSTEM_PARM_LONG structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| CHECKDATE | DB2 for OS/390: Date of the check | DB2CHKDATE | DATS | 8 | DATUM | ||||
| CHECKTIME | DB2 for OS/390: Time of the check | DB2CHKTIME | TIMS | 6 | TIMES | ||||
| CHECKTYPE | Type of Check for DB2 Installation Parameter(s) Check | DB2CHKTEXT | CHAR | 20 | CHAR20 | ||||
| RESULT | Result of DB2 Installation Parameter Check | DB2CHKRSLT | CHAR | 10 | CHAR10 | ||||
| SYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
| SAPRL | Release of SAP System | SYSAPRL | CHAR | 4 | SYCHAR04 | ||||
| OPSYS | Operating System of Application Server | SYOPSYS | CHAR | 10 | SYOPSYS | ||||
| KERNELRL | Kernel Release | SYKERNRL | CHAR | 4 | SYCHAR04 | ||||
| PATCHLVL | DB2 for OS/390: Kernel patch level | DB2PATCHLV | INT4 | 10 | |||||
| DB2SYS | Central Database System | SYDBSYS | CHAR | 10 | SYCHAR10 | ||||
| DB2VERSION | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
| DB2RELEASE | DB2 release | DB2RELEASE | CHAR | 10 | CHAR10 | ||||
| CHECKCLASS | DB2 for OS/390 check class for system check | DB2CKCLASS | CHAR | 4 | DB2CKCLASS | ||||
| CHECKNAME | DB2 for OS/390 DB system check - name of a check | DB2CHKNAME | CHAR | 50 | CHAR50 | ||||
| CHECKSEQUENCE | Numeric 1-character | NUM1 | NUMC | 1 | NUM1 | ||||
| MODUSER | Normal SAP user or special user '#SAP#' | CKMOD_USER | CHAR | 12 | CHAR12 | ||||
| MODDATE | Date of last modification | DB2MODDATE | DATS | 8 | DATUM | ||||
| MODTIME | Time of last modification | DB2MODTIME | TIMS | 6 | TIMES | ||||
| ACTIVE | Activation Indicator for Check Condition | CHKACTIV | CHAR | 1 | CHKACTIVE | ||||
| MODFLAG | DB2/OS390: Shows if check in DB system check can be modified | DB2MODFLG | CHAR | 1 | CHAR1 | ||||
| SEVERITY | DB2 for OS/390: Severity of error detected | DB2CHKSEV | CHAR | 1 | DB2CHKSEV | ||||
| PARAM | DB2 for OS/390: Paramter to be checked in DB system check | DB2PARAM | CHAR | 50 | CHAR50 | ||||
| PARAM_UNIT | Unit of Check Value | CHKUNIT | CHAR | 1 | CHKUNIT | ||||
| OPERATOR | DB2 for OS/390: check operator (system check) | DB2CKOP | CHAR | 2 | DB2CKOP | ||||
| CHECKVALUE_R3 | DB2 for OS/390: Parameter value in DB system check | DB2CHKVAL | CHAR | 50 | CHAR50 | ||||
| CHECKVALUE | DB2 for OS/390: Parameter value in DB system check | DB2CHKVAL | CHAR | 50 | CHAR50 | ||||
| CHECKVALUE_BW | DB2 for OS/390: Parameter value in DB system check | DB2CHKVAL | CHAR | 50 | CHAR50 | ||||
| CHECK_UNIT | Unit of Check Value | CHKUNIT | CHAR | 1 | CHKUNIT | ||||
| ISNUMERIC | 'X' if parameter is numeric, ' ' otherwise | DB2NUMERIC | CHAR | 1 | AS4FLAG | ||||
| ERRORTXT | DB2 OS/390: Description of error reported by DB system check | DB2CHKDESC | CHAR | 80 | CHAR80 | ||||
| CORRTXT | DB2 OS/390: corrective action for error in DB system check | DB2CHKCORR | CHAR | 80 | CHAR80 | ||||
| CHECKTEXT | Infotype Name | ITEXT | CHAR | 25 | TEXT25 | ||||
| PARM_CHECKS | No of Checked DB2 Installation Parameters | DB2PARMCHK | NUMC | 5 | NUMC05 | ||||
| ERRORS | No of Checked DB2 Installation Parameters with Error | DB2PARMERR | NUMC | 5 | NUMC05 | ||||
| WARNINGS | No of Checked DB2 Installation Parameters | DB2PARMWAR | NUMC | 5 | NUMC05 | ||||
| OKAYS | No of Successfully Checked DB2 Installation Parameters | DB2PARMOK | NUMC | 5 | NUMC05 | ||||
| NOT_CHECKED | No of unchecked DB2 Installation Parameters | DB2PARMNOCHK | NUMC | 5 | NUMC05 |
| Key field | Non-key field |
How do I retrieve data from SAP structure DB2_SHOW_SYSTEM_PARM_LONG using ABAP code?
As DB2_SHOW_SYSTEM_PARM_LONG is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB2_SHOW_SYSTEM_PARM_LONG as there is no data to select.How to access SAP table DB2_SHOW_SYSTEM_PARM_LONG
Within an ECC or HANA version of SAP you can also view further information about DB2_SHOW_SYSTEM_PARM_LONG and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects