SAP Knowledge Base Article - Preview

3027825 - Saphostctrl -function GetDatabaseStatus returns 'Stopped' even though DB is running - SAP ASE for BS

Symptom

  • When running the saphostctrl to monitor SAP ASE DB status, it states that database is not running even though DB is running.

    C:\Program Files\SAP\hostctrl\exe>saphostctrl -function GetDatabaseStatus -dbname <SID> -dbtype syb

    Database Status: Stopped

    Component name: Client (SYBASE Server Client Software), Status: Running (SAP ASE Server client software is configured properly.)
    Component name: Server (SYBASE Server Software), Status: Stopped (SAP ASE Server instance BWQ is not running.)
    Component name: Database (SYBASE Server Database), Status: Stopped (SAP ASEDatabase BWQ is not running.)
    Component name: Backup Server (SYBASE Backup Server Software), Status: Stopped (Backup Server is not running.)
    Component name: Job Scheduler (SYBASE Job Scheduler), Status: Stopped (Job Scheduler is not running.)
    Component name: RepAgent thread (SYBASE Replication Agent Thread), Status: Running (Running Rep Agents:  / Stopped Rep Agents:)

  • According to the dev_sapdbctrl log, saphostctrl didn't find SAP ASE process.

    SybServer::checkServerProcesses: Searched ASE path: \sybase\<SID>\
    SybServer::checkServerProcesses: Searched REP path:

    Note) If saphostctrl find the SAP ASE process, the following message will be logged.
    SybServer::checkServerProcesses:  Searched ASE path: \sybase\<SID>\
    SybServer::checkServerProcesses:  Searched REP path: 
    SybServer::checkServerProcesses:  Found dataserver running with PID 4748
    SybServer::checkServerProcesses:  Found backupserver running with PID 3876
    SybServer::checkServerProcesses:  Found job scheduler agent running with PID 2004


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • MS Windows

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

 saphostctrl,GetDatabaseStatus , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.