Monitoring MaxDB Instance from SAP CCMS

[Former Member]

Hi,

I've ERP 6.0 installed on z/OS & DB2. I've also installed content server 6.4 and MaxDB 7.6 on Intel/Linux. I've linked my ERP with CS and Maxdb through customizing.

Question : Is it possible to monitor Maxdb instances from SAP WAS CCMS along with DB2? If yes, How?

Appreciate any hint ...

Rgds,

Sheikh

[lbreddemann]

> I've ERP 6.0 installed on z/OS & DB2. I've also installed content server 6.4 and MaxDB 7.6 on Intel/Linux. I've linked my ERP with CS and Maxdb through customizing.

> Question : Is it possible to monitor Maxdb instances from SAP WAS CCMS along with DB2? If yes, How?

Sure, use the DBACOCKPIT or transaction DB59 to integrate and monitor the MaxDB.

regards,

Lars

[Former Member]

Dear Lars,

Thanks for yr reply.

I've created a connection DB in DB59 successfully. However, test connection is failing saying that "No MaxDB client installed".

Could you elaborate more on how to do it Pls? or if you have any document that explains such thing.

Rgds,

Sheikh

[lbreddemann]

You may want to check

SAP Note 649814 Updating MaxDB/liveCache client software.

SAP Note 822271 FAQ: SAP MaxDB client software

regards,

Lars

[Former Member]

Hello Lars,

As already I connect to remote DB2 server on z/Os from my application server using DB2-connect 9.5, Can I still install MaxDB client sw on the same aplication server host? Will there be any potential confilicts between the two ?

Rgds,

Sheikh

[lbreddemann]

> As already I connect to remote DB2 server on z/Os from my application server using DB2-connect 9.5, Can I still install MaxDB client sw on the same aplication server host? Will there be any potential confilicts between the two ?

No problem with that.

There won't be any conflicts and it will work in parallel.

You could even add e.g. a Oracle client as well.

For more information on that you may want to read the documentation/sap notes that are found when looking for "db multiconnect".

regards,

Lars

[Former Member]

Thanks Lars for your valuable input.

I'v installed Maxdb client sw as instructed. When I try to connect from SM59 or DB59, connection fails again!

The following error found in dev_* trace file

*******************************************************************

Wed Dec 30 19:23:40 2009

create_con (con_name=JCDMS)

Loading DB library '/usr/sap/IDS/SYS/exe/run/dbsdbslib.so' ...

• ERROR => DlLoadLib: dlopen()= libSQLDBC76.so: cannot open shared object file: No such file or directory -> DLENOACCESS (0,Suc

• ERROR => Couldn't load library '/usr/sap/IDS/SYS/exe/run/dbsdbslib.so'

dbcon.c 4731]

***LOG BYG=> could not load library for database connection JCDMS [dbds#1 @ 1035] [dbds 1035 ]

Rgds,

Sheikh

[lbreddemann]

> I'v installed Maxdb client sw as instructed. When I try to connect from SM59 or DB59, connection fails again!

>

> The following error found in dev_* trace file

> *******************************************************************

> Wed Dec 30 19:23:40 2009

> create_con (con_name=JCDMS)

> Loading DB library '/usr/sap/IDS/SYS/exe/run/dbsdbslib.so' ...

> *** ERROR => DlLoadLib: dlopen()= libSQLDBC76.so: cannot open shared object file: No such file or directory -> DLENOACCESS (0,Suc

> *** ERROR => Couldn't load library '/usr/sap/IDS/SYS/exe/run/dbsdbslib.so'

> dbcon.c 4731]

> ***LOG BYG=> could not load library for database connection JCDMS [dbds#1 @ 1035] [dbds 1035 ]

Ok, so the MaxDBclient software is installed, but you still need to copy the dbssdbslib.so to the work-directory of the NetWeaver instance.

The whole db connectivity stuff of NetWeaver is always split into these two parts:

1. the DB<...>SLIB shared library/objekct. That's what the workprocess loads when it needs to access a database.

this is pure SAP code.

and

2. the client software of the database which is used by the DB<...>SLIB library. This is mostly thrid party code (except for MaxDB/liveCache of course.

You can find the dbsdblib for your NetWeaver in the service Marketplace where the Kernel patches are available.

regards,

Lars

[former_member229109]

Hello,

You need to install on the application server the MAXDB database-dependent part of the SAP kernel,

which is known as the DBSL (dbadaslib). Then restart the application server.

Please review the SAP notes::

990602 FAQ: CCMS for MaxDB/SAP liveCache technology

1371928 DBA Cockpit: SAP MaxDB/liveCache as remote database

822239 FAQ: SAP MaxDB Interfaces

You need to install on the application server the MAXDB database-dependent part of the SAP kernel,

which is known as the DBSL (dbadaslib).

This question on monitor the database on your Solution Manager system, for example,

also was discussed at the threads:

&&

Please see more details in those threads.

Thank you & best regards, Natalia Khlopina

[Former Member]

Hi,

Thanks all for your help.

As I mentioned earlier, my application server is running on IBM zSeries/Linux, DB2 z/OS, and content server with Maxdb on x86 and when searching for application server's MAXDB database-dependent part of the SAP kernel for my environment in service Marketplace as per your instruction , I could not find it ! (It's there for x86, for example but not for s390 !)

Does it mean that SAP does not support it for this environment combination ? If yes, then How come the MaxDB server/client sw is supported for my same environment but not DBSL library !!! To me, it looks very strange ! Doesn't it?

Shall I take it up with SAP? What do you suggest ? Thx

Rgds,

Sheikh