MAXDB connectivity to Solman 7.1

[former_member226400]

Hi,

I have standalone MAXDB 7.7 database on Linux. I want to connect it to Solman7.1 for monitoring. I have pushed the data of server to SLD after installing diagnostic agent and hostcontrol agent . XUSER entry is also mentained on server.  But SLD is only able identify host detail and not the maxdb database present on th servers.

On server, i could see log in file /usr/sap/hostctrl/work/XCMDOUT.LOG as:

"

Start subprocess as user with uid: sapadm

--------------------------------------------------------------

> Subprocess starts at 20150410144138

Execute Command : /sapdb/programs/bin/dbmcli -U SDB -U SDB -n <hostname> db_state

Error! Connection failed to node <hostname> for database SDB:

database instance not found

> Subprocess stops at 20150410144138

> Subprocess call failed

"

But when i directly execute command /sapdb/programs/bin/dbmcli -U SDB -U SDB -n <hostname> db_state on server, It able to fetch the db detail fine as:

OK

State

ONLINE

Please help me understand how to proceed and how to fix this issue.

[Former Member · Accepted solution]

hi Nitin,

You need to have a max db client installed on the Solution manager host and then you can use dbacockpit to add up the MAx db database in the Monitroing the database for any log area, db_state and other alerts.

Also once u have smdagent configured you can try to monitor the dbm process for same.

You can refere below links / OSS notes for help on same.

DBACOCKPIT and Solman Monitoring for MaxDB Database : How to Setup -I

DBACOCKPIT and Solman Monitoring for MaxDB Database : How to Setup -II

990602     FAQ: CCMS for MaxDB/SAP liveCache technology

822239      FAQ: SAP MaxDB Interfaces

822271          FAQ: SAP MaxDB client software

Let me know if this helped you.

Regards,

Ram

[former_member226400 · Accepted solution]

HI Ram,

Thanks for the Links.

I have followed them in configuring the monitoring in first place

For time being i have added the entry for database manually in LMDB and then configured the technical monitoring in solman_workcenter for MAXDB database. It seems to be working fine and able to trigger alerts and populate correct data.

[JamesZ]

Hi Nitin,

I think the problem may be <hostname> was wrongly passed. You may need check the potential fields where
<hostname> is from and passed to the command.

Best regards,
James

[former_member226400]

Hi James,

I have checked <hostname> was correctly passed in command. xuser entry created are also correct and working with hostname.

[JamesZ]

Hi Nitin,

The error explicitly shows hostname should have problem:

"Connection failed to node <hostname> for database SDB:"

How did you check the <hostname> was correctly password? Can you show some screenshots to me?

Best regards,
James

[former_member226400]

Hi James,

Please find the screen shot attached

You can see that hostname passed is a011470t300, which is my host on which maxdb is present.

[JamesZ]

What is the output of manually executing the same command with the same os user?

[former_member226400]

when I execute this command manually from sapadm user on server the command is successful

and the output is :

OK

State

ONLINE

[JamesZ]

which os user you were? can you show me a screenshot about this? it is weird?

[former_member226400]

Hi James,

Please find the screenshot. Yes, Its weird.

[JamesZ]

Hi Nitin,

I have no idea now, I would like suggest you to open a ticket for SAP with system connection opened, so SAP support team can have a direct look at the target system.

Best regards,

James