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 for Me (Login required).

Search for additional results

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