HDBNAVSYST - List of all HANAs with Database Status, Memory Size, etc.
List of all HANAs with Database Status, Memory Size, etc. information is stored in SAP table HDBNAVSYST.
It is part of development package SDBA_HDB in software component HAN-DB. This development package consists of objects that can be grouped under "DBACOCKPIT for NewDB (HDB)".
It is part of development package SDBA_HDB in software component HAN-DB. This development package consists of objects that can be grouped under "DBACOCKPIT for NewDB (HDB)".
Fields for table HDBNAVSYST
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSID | DBACOCKPIT Name | X | CHAR | 16 | ||
| STATUS_ICON | Text (length 35) | TEXT35 | CHAR | 70 | ||
| STATUS | Character 512 | CHAR512 | CHAR | 1024 | ||
| ACTIVE_HOST | Active Host | CHAR | 510 | |||
| SQL_PORT | SQL Port | CHAR | 10 | |||
| MDC | Multitenant database container | CHAR | 16 | |||
| SYSTEM_ID | SystemID | CHAR | 6 | |||
| DATABASE_NAME | Database Name | CHAR | 512 | |||
| REVISION | HANA Release | CHAR | 20 | |||
| DB_USER | DB User Name | HDB_DB_USER_NAME | CHAR | 512 | ||
| SCHEMA_NAME | Schema Name | HDB_SCHEMA_NAME | CHAR | 512 | ||
| NR_OF_HOSTS | Number of Hosts | INT2 | 2 | |||
| PLUGINS | Installed Plug-ins | CHAR | 60 | |||
| START_TIME | Start Time of the HANA | HDB_START_TIME | CHAR | 38 | ||
| ALERTS | HANA Alerts Counters | CHAR | 70 | |||
| MEM_USED | Used Memory (GB) | DEC | 11 | |||
| DISK_USED_DATA | Used Disk Data Size (GB) | DEC | 11 | |||
| DISK_USED_LOG | Used Disk Log Size (GB) | DEC | 11 | |||
| DISK_USED_TRACE | Used Disk Trace Size (GB) | DEC | 11 | |||
| CPU_USED | CPU Usage (%) | DEC | 11 | |||
| IGNORE_ENTRY | Ignore this DB during Refresh | CHAR | 2 |