DB6NAVSYST - DB6: System Registration Table
DB6: System Registration Table information is stored in SAP table DB6NAVSYST.
It is part of development package SDBA_RUNTIME in software component BC-DB-MON. This development package consists of objects that can be grouped under "DBA Cockpit: Runtime".
It is part of development package SDBA_RUNTIME in software component BC-DB-MON. This development package consists of objects that can be grouped under "DBA Cockpit: Runtime".
Fields for table DB6NAVSYST
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSID | Name of SAP System | X | SYSYSID | CHAR | 16 | |
| SAPREL | Release of SAP System | SYSAPRL | CHAR | 8 | ||
| DBREL | DB6: Database Release Level | DB6DBREL | CHAR | 20 | ||
| RFCDEST | Logical destination (specified in function call) | RFCDEST | CHAR | 64 | ||
| DBHOST | DBA Cockpit: Server Name | DBA_SERVER | CHAR | 510 | ||
| SCHEMANAME | DB6: Schema Name | DB6SCHEMA | CHAR | 40 | ||
| ENTRYSTATE | State of entry: 1=INITIAL,2=COMPLETE,3=DISABLED | INT4 | 4 | |||
| ENTRYTYPE | kind of system: 1=R/3 ,2=Non R/3 | INT4 | 4 | |||
| DBCNAME | Logical name of a database connection | DBCON_NAME | CHAR | 60 | DBCON | |
| DBSYS | Database system | DBCON_DBMS | CHAR | 6 | ||
| DB_OPSYS | Operating System of Application Server | SYOPSYS | CHAR | 20 | ||
| COCKREL | Release of SAP System | SYSAPRL | CHAR | 8 | ||
| REALSID | Name of SAP System | SYSYSID | CHAR | 16 | ||
| DBSID | DBA Cockpit: Database Name | DBA_DBNAME | CHAR | 256 | ||
| RZ20_MON | Remote Alert Monitoring active ('X')/inactive (' ') | CHAR | 2 | |||
| HIST_MON | Remote History Collection active('X')/inactive(' ') | CHAR | 2 | |||
| DESCRIPTION | Text (80 Characters) | TEXT80 | CHAR | 160 | ||
| CHANGEDATE | System Date | SYDATUM | DATS | 16 | ||
| CHANGETIME | System Time | SYUZEIT | TIMS | 12 | ||
| CHANGED_BY | User Name | SYUNAME | CHAR | 24 | ||
| SYSTEMTYPE | SAP DB: Instance Type | SDB_ITYPE | CHAR | 14 | ||
| RFCDEST_2 | Logical destination (specified in function call) | RFCDEST | CHAR | 64 | ||
| REMOTE_COLL | Collect data remote('X') or local (' ') | CHAR | 2 | |||
| DBCON_VIA_RFC | DB Connection via RFC Destination | CHAR | 2 | |||
| PROMPT_USER_DATA | Store password permanent | CHAR | 2 | |||
| SLD_NAME | CHAR | 510 | ||||
| SLD_UPDATE | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 28 | ||
| DB13C_MON | DB13C Integration active('X')/inactive('') | CHAR | 2 | |||
| KPI_MON | A1S KPI Monitoring active('X')/inactive('') | CHAR | 2 | |||
| LICENSE_EXT | Platform specific license extension | CHAR | 20 | |||
| SCHEDULER_TYPE | Scheduler Type | INT4 | 4 | |||
| BACKEND_STATE | Back-End State | INT4 | 4 | |||
| BACKEND_CHK_TIME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 28 | ||
| HIST_DBH | Remote History Collection based on STPs | CHAR | 2 | |||
| BACKEND_TPL_ID | Template ID | INT4 | 4 | |||
| LSID | Landscape ID (Solution Manager) | CHAR | 16 | |||
| AUTO_UPDATE | Auto Update active('X')/inactive('') | CHAR | 2 | |||
| DBOSC_ID | ID in TMC Topology | CHAR | 16 |