-
Non-Product Related Assistance
Request for existing cases, user IDs, Portal navigation support and more
Request for existing cases, user IDs, Portal navigation support and more
Currently the following monitoring application are supported for SAP ASE databases:
| Task | Actions |
|---|---|
| Install ASE DB 15.7 or higher | You need at least ASE DB 15.7, optionally install the latest ASE DB and latest Patches from support.sap.com/swdc -> Databases -> SAP Adaptive Server Enterprise To check details which ASE DB monitoring feature is requiring which SAP Hostagent version please see SAP Note 2577046(opens in new tab). Check Security Guide and especially SAP Note 2236137(opens in new tab) - SYB: saphostctrl/sapdbctrl - enable discovery for native ASE database installations.
|
| Run Outside Discovery on the Host | As prerequisites, you shall install the SAP Host Agent and run Outside Discovery as described in page Preparing Outside Discovery. Be aware the hostname interpreted as DB Hostname by Outside Discovery is the first entry set in file in $ASE_HOME$/interfaces Note: This hostname should be the same as SLDSYSTEMHOME set in SAP NetWeaver ABAP or j2ee/dbhost in SAP NetWeaver JAVA (see also SAP Note 1052122(opens in new tab)). ASE HADR cluster: The configuration of outside discovery for ASE HADR cluster is described in SAP Note 2577046(opens in new tab) "SYB: saphostctrl - Changelog for ListDatabaseMetrics function of SAP Host Agent" in section “Setup”. |
Check Needed Data Suppliers The SAP ASE DB can be used in stand-alone or associated to an ABAP or Java Stack | The SAP ASE DB can be used in stand-alone or associated to an ABAP or Java Stack. Therefore, the corresponding Data Supplier needs to be setup. See the SAP NetWeaver Application Server ABAP Preparation or SAP NetWeaver Application Server Java Preparation pages. |
Create DB monitoring user and provide connection credentials SAP Focused Run utilizes SAP Host Agent Web methods to get DB monitoring data from sapsa as in rsecssfs secure store with key DB_CONNECT/SYB/SADB_USER. |
If the ASE DB monitoring was not initialized with the Transaction "DBACockpit" do the following: For all ASE DB, the execution of the SAP Host Agent method saphostctrl -function SetDatabaseProperty -dbname <SID> -dbtype syb SETUP_LIST_METRICS=saptools is recommended (easier than to configure a remote DBA Cockpit Connection to a remote ABAP System). Note: All SAP Host Agent methods can be executed and scripted local or remote by a saphostctrl or any other webservice client. Alternative process: The monitoring user can be created by ASE user management sqls using ISQL. The secure store can be maintained by OS command rsecssfx. |
| Support of ASE HADR scenario | In order to get the replication scenario correctly reported by the Outside Discovery and registered in the LMDB, following prerequisite steps are required:
Maintain the SLDSYSTEMHOME parameter on SAP NetWeaver ABAP or j2ee/dbhost on SAP NetWeaver JAVA to match the hostname of a floating IP.
Note: The failover detection feature was introduced with SAP Host Agent 7.22 PL70. This ensures that, after a failover event, a new payload containing the updated replication roles is sent to SAP Focused Run and the System Monitoring reconfiguration is triggered accordingly. *SAP Host Agent 7.21 PL64 must only be applied in combination with all other minimum versions listed above. Applying it in isolation may result in grey metrics on some replication hosts. If upgrading all components simultaneously is not feasible, use a patch level below PL64 until the full set of minimum versions can be deployed. |
|