Solution Manager (no MaxDB) - How to monitor MaxDB - Which Software?

[Private_Member_19084]

Hi experts,

I would like to monitor a MaxDB database in our Solution Manager.

However, the Solution Manager is running on SAP ASE.

I've already found the thread, which explains what has to be installed on Solution Manager

My question now is, what software-versions do I have to install exactly.

For the runtime-package, I've downloaded the newest one, is that ok?

And where can I find the database-library and which version do I have to use?
Do I have to use the same one like the kernel on Solman side?

Kind regards

[thorsten_zielke · Accepted solution]

Hello Christian,

I am not an expert with the Solution Manager, but if you want to monitor a MaxDB database, you will need to have a MaxDB client package installed on the server where the Solution Manager is running and the SAP kernel must be able to connect to MaxDB via the correct SAP kernel dbsl library.

dbsl library
The dbsl libraries are part of the SAP kernel package since they are 'SAP kernel'-dependend. There is one dbsl library for each supported SAP database. I believe the SAP kernel package already includes libraries for all supported databases, so you should already have a MaxDB library on your Solution Manager system, but I may be wrong here (if so, please check on SAP note 19466 'Download of SAP Kernel Patches' in case you do not have the MaxDB dbsl library, but keep in mind, the dbsl library must match to the SAP kernel).

MaxDB runtime package
Yes, just install the latest available MaxDB 'client runtime' package for MaxDB 7.9

Kind regards,
Thorsten

[Private_Member_19084 · Accepted solution]

Hello Thorsten,

another question regarding this.

It is written that I have to enhance the PATH and LD_LIBRARY_PATH.

How do I have to enhance it exactly? Which file is it?

It hast to be for <sid>adm and permanently, right?

Kind regards

[Private_Member_19084 · Accepted solution]

Hello Thorsten,

do you have an idea regarding the variables-thing?

Kind regards

[thorsten_zielke · Accepted solution]

Hello Christian,

PATH has to be set for Windows, LD_LIBRARY_PATH for Unix/Linux environments.

Let me point you to our (very good) selection of MaxDB FAQ notes, in this case SAP note 822271:

"14. The SAP recommendations for LIBRARYPATH are confusing and sometimes appear contradictory. How can I set these environment variables correctly?

MaxDB kernel version lower than 7.8
The environment variable LD_LIBRARY_PATH must contain INDEPPROGRAM/lib in Unix.

MaxDB Kernel Version 7.8 and higher
The environment variable LD_LIBRARY_PATH must contain ClientProgPath/lib on Unix."

Regards,
Thorsten

[Private_Member_19084 · Accepted solution]

Hello Thorsten,

I've already found that note. But for me it sounded, that the path has to be included in LD_LIBRARY_PATH...however, maybe I am wrong.

Where exactly do I set no the env-variable LD_LIBRARY_PATH, in which file is it?

I still don't see it...

Kind regards

[Former Member · Accepted solution]

Hi Christian,

Which OS your using for the solution manager. Based on that you need to adapt up the variable LD_LIBRARY_PATH.

Check for your <SID>adm user

For windows: it will be PATH

For Unix Flavours :- LD_LIBRARY_PATH

Regards,

Ram

[Private_Member_19084 · Accepted solution]

Hello Ram,

on RHEL (linux).

And there we did see, that there are more positions/files, where the library/path is maintained.

And now I don't know, where the varialbes have to be maintained exactly.

Kind regards

[Former Member · Accepted solution]

Hi Christian,

You need to maintain it in dbenv.csh, .dbenv.sh.sapenv.csh & .sapenv.sh.

There would be similar files with .*env*<host_name>.*sh where in you will see the LD_LIBRARY_PATH Do append at the last with

<existingpath>:<you max db client path>

Do let us know if you need any further help.

Do verify after changing the environment. Logout the user and login back and do

echo $LD_LIBRARY_PATH.

regards,

Ram

[Private_Member_19084 · Accepted solution]

Hello Ram,

is it the same for "PATH" variable?
Where can I find those 4 files?
I am searching with "find" but still couldn't find them...

[Former Member · Accepted solution]

Hi Christian,

You can find those files under /home/<SID>adm user home directory. those will be hidden so you need to use ls -altr command to check.

Do let me know if you need any further inputs.

Regards,

Ram