Symptom
SAP Host Agent reports the DB instance and DB status as "stopped", although the database is up and running.
You have virtual host name maintained in db2nodes.cfg.
dev_sapdbctrl (default trace level 1)
TIME: 2018 Nov 11 11:11:11
DESCRIPTION:
SAP_DB_ListDatabaseSystems failed: no more memory for struct SAP_DB_DatabaseSystem
LAST OS-ERROR: (2) : No such file or directory.
[PID 11111111]
*** ERROR => List database systems failed:
SAP_DB_ListDatabaseSystems failed: no more memory for struct SAP_DB_DatabaseSystem [sapdbctrl.cp 3611]
./saphostctrl -function ListDatabases
Instance name: db2abc, Hostname: AAA012R3, Vendor: IBM, Type: db6, Release: 10.05.0008
Database name: ABC, Status: Stopped Component name: db2abc (DB2 instance), Status: Stopped (DB2 instance stopped)
Component name: ABC (DB2 database), Status: Stopped (DB2 connect not possible)
If you increase SAP Host Agent trace level to 3 (wiki), you find the following error.
dev_sapdbctrl (trace level 3)
[PID 22222222] (dbdb6ctrlux.cpp:973 in DB6ControllerImplux::getDB2NodesCfg(const SAP_UC *, DB2NodesCfg *, SQL_PDB_NODE_TYPE *)): entry
[PID 22222222] (dbdb6ctrlux.cpp:992 in DB6ControllerImplux::getDB2NodesCfg(const SAP_UC *, DB2NodesCfg *, SQL_PDB_NODE_TYPE *)): db2nodes.cfg=/db2/db2abc/sqllib/db2nodes.cfg
...
[PID 22222222] (dbdb6ctrl.cpp:2075 in DB6Controller::getDatabaseStatus(SAP_DB_STATUS_CODE *, SAP_DB_Component *, int *, DB6DatabaseInstance *, const char *)):
Executing db2gcf to get db status
...
[PID 22222222] '/db2/db2abc/sqllib/bin/db2gcf' terminated normally with exit code '1'
[PID 22222222] (dbdb6ctrl.cpp:2097 in DB6Controller::getDatabaseStatus(SAP_DB_STATUS_CODE *, SAP_DB_Component *, int *, DB6DatabaseInstance *, const char *)):
DB2 is stopped but operable
fdas
Read more...
Environment
- SAP on IBM Db2 for Linux, UNIX, and Windows
- Db2 10.5 lower than 10.5 FP9, or Db2 11.1 lower than 11.1 FP1SAP
Product
SAP NetWeaver 7.5
Keywords
SAP_DB_ListDatabaseSystems, ListDatabases, stopped, db2gcf , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-CCM , CCMS/Database Monitors , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview