SAP Knowledge Base Article - Preview

2725551 - DB6: Stopped DB status reported by SAP Host Agent

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.