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.