Hi HANA colleagues,
I would like to suggest using a "hdbcons" utility for SAP HANA troubleshooting.
The "hdbcons" is a HANA kernel utility.
There are many options in that utility.
For example,
1) To get threads list,
hdbcons "context list -s" > thread_callstack_test.txt
2) To generate runtime dump (see the Note 1813020 - How to generate a runtime dump on SAP HANA)
hdbcons "runtimedump dump -f /test/rte_dump.txt"
Also for a suspected memory issue, please see the below two Notes for more details.
1. Note 1786918 - SAP HANA Database: Provide Information with hdbcons
2. Note 1804811 - SAP HANA Database: Kernel Profiler Trace
The SAP HANA is a database, therefore if some issue occurs then the initial action is really important to solve that issue without any business impact.
Perhaps the worst case, for example not easy to log in due to bad performance, the "hdbcons" might be helpful for troubleshooting HANA issues.
Please see the below table of "hdbcons" options.
You can also find all options in help of "hdbcons".
Options | Description | Options | Description |
bye | Exit console client | mutex | Mutex management |
cd | ContainerDirectory management | pageaccess | PageAccess management |
checktopic | CheckTopic management | page | Converter management |
cnd | ContainerNameDirectory management | pcm | Performance Counter Monitor management |
context | Execution context management (i.e., threads) | profiler | Profiler |
converter | Converter management | quit | Exit console client |
crash | Crash management | resman | ResourceManager management |
debug | Debug management | runtimedump | Generate a runtime dump. |
dvol | DataVolume management | savepoint | Savepoint management |
ELF | ELF symbol resolution management | snapshot | Snapshot management |
event | Event management | statreg | Statistics registry command |
exit | Exit console client | stat | Statistics management |
help | Display help for a command or command list | tracetopic | TraceTopic management |
log | Show information about logger and manipulate logger | trace | Trace management |
mm | Memory management | version | Version management |
monitor | Monitor view command | vf | VirtualFile management |
mproxy | Malloc proxy management | | |
- Hyungsang Park
