Sybase – BALDR problem

From Version 16.0 SP03 of SAP Adaptive Server Enterprise (ASE), the database has the option of integrated monitoring. The new functionality is called Built-In ASE Longterm Monitoring Data Repository (BALDR). This replaces the data collection framework (DCF) injected by the DBA cockpit when monitored by an SAP DBA Cockpit or Solution Manager System. Sometimes in SM21 You can find below ASE Error SQL156:

Solution

Probably the problem is the wrong version BALDR. You should upgrade to latest version as per 2502193 – SYB: BALDR – New Monitoring Persistency Layer for SAP ASE.

But first, we check current BALDR release. How to do this:

use saptools
go

select [KEY], [VALUE] from DBH_CONFIG where [KEY] like 'BALDR%'
go
--------------------------------------------------------------------------------------------------
BALDR_MSG_LEVEL 3 
BALDR_RELEASE 16.0.03.00 
BALDR_VERSION 20191121105602

How to update BALDR

You have two possibilities:

using saphosctrl – but here pay attention to the SAP Host Agent version which You use (agent version should be newer that Youf BALDR_VERSION.
using script instbaldr.sql – check note: 2502193.

First option:

server:/usr/sap/hostctrl/exe # ./saphostctrl -function SetDatabaseProperty -dbname SID -dbtype syb SETUP_LIST_METRICS=saptools
Webmethod returned successfully
Operation ID: 02A255B0BB081EDC8CEFDC31A94841B7 

----- Log messages ----
Info: saphostcontrol: Executing SetDatabaseProperty
Info: saphostcontrol: SetDatabaseProperty successfully executed

BALDR_MSG_LEVEL 3 
BALDR_RELEASE 16.0.03.00 
BALDR_VERSION 20200814121817

Second option:

server> /sybase/SID% isql -Usapsa -X -SSID -Ppassword -w999 -i instbaldr.sql
Database option 'allow wide dol rows' turned ON for database 'saptools'.
Running CHECKPOINT on database 'saptools' for option 'allow wide dol rows' to take effect.
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------ ----------- ------------- -------------- ------------ ------ -------
enable compression 0 0 1 1 switch dynamic
Resulting configuration value and memory use have not changed from previous values: new configuration value 1, previous value 1.
Parameter Name Default Memory Used Config Value Run Value Unit Type
...
...
delete from tempdb..saptools_indexes where indname = 'DBH_THRESHOLDEVENT~0'
delete from tempdb..saptools_indexes where indname = 'DBH_THRESHOLDEVENT~1'
delete from tempdb..saptools_indexes where indname = 'DBH_THRESHOLDEVENT_SQLTEXT~0'
Warning: Row size (16400 bytes) could exceed row size limit, which is 16300 bytes.
Warning: Row size (16400 bytes) could exceed row size limit, which is 16300 bytes.
BALDR Script to install data collectors and ATM finished
BALDR can be activated with stored procedure saptools..SP_BALDR_ACTIVATE
successful: BALDR is now active

BALDR_MSG_LEVEL 3 
BALDR_RELEASE 16.0.03.00 
BALDR_VERSION 20210903134909

That’s all 😉

Solution

Cancel Reply