SAP MaxDB Monitoring via CCMS

[Former Member]

I would like to monitor SAP MaxDB 7.6.06.17 (Content Server) from SAP Web AS 6.40 running on DB2 via CCMS. SAP MaxDB is installed on the same host with AIX 6.1 as SAP Web AS 6.40 and DB2. I already adjusted the following two environment variables:

- LD_LIBRARY_PATH to accommodate also /sapdb/programs/lib/lib64

- PATH to accommodate also /sapdb/programs/bin

But still receiving errors (from WP trace file):

B  Loading DB library '/usr/sap/SID/SYS/exe/run/dbadaslib.o' ...
M  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/SID/SYS/exe/run/dbadaslib.o") FAILED
  "#0509-022 Cannot load module /usr/sap/SID/SYS/exe/run/dbadaslib.o.
#0509-150   Dependent module libSQLDBC76.so could not be loaded.
#0509-022 Cannot load module libSQLDBC76.so.
#0509-026 System error:"  (errno=2,No such file or directory) [dlux.c       445]
B  *** ERROR => Couldn't load library '/usr/sap/SID/SYS/exe/run/dbadaslib.o'
 [dbcon.c      4868]
B  ***LOG BYG=> could not load library for database connection SDB        [dbds#4 @ 1047] [dbds    1047 ]

I found SAP Note 1066891 - SAP Kernel 46D_EX2/640_EX2 on systems with MaxDB/liveCache, to which two files are attached:

- DBENV.CSH

- DBENV.SH

And SAP advice to use files from the Note instead of files in <sid>adm home directory. But in my case it is not possible to easily replace files in <sid>adm home directory.

Don't you know what exactly is needed from DBENV.CSH and DBENV.SH files to be able to successfully load dbadaslib.o and libSQLDBC76.so?

Edited by: Milan Sadil on Feb 16, 2012 10:08 AM

[Former Member]

I found a solution for my situation. In addition to two environment variables, which I had added previously, I had to add one more:

- LD_LIBRARY_PATH to accommodate also /sapdb/programs/lib/lib64

- PATH to accommodate also /sapdb/programs/bin

- (new one) LIBPATH to acommodate also /sapdb/programs/lib/lib64

Not sure if all three are needed, I didn't find any clear recommendation from SAP. I found two documents and LIBPATH is mentioned in none of them:

- [Environment Variable in Documentation of SAP MaxDB Database Version 7.8 |Environment Variable in Documentation of SAP MaxDB Database Version 7.8]

- SAP Note 822271 - FAQ: SAP MaxDB client software

[former_member229109]

Hello,

1. Did you install the MAXDB client software on this application server?

2. Please post output as the <appl-SID>adm on the application server:

sdbregview -l

ldd /usr/sap/SID/SYS/exe/run/dbadaslib.o

Please review the notes:

822239 FAQ: SAP MaxDB Interfaces

822271 FAQ: SAP MaxDB client software

3. You have option to create the SAP message & get SAP support

Regards, Natalia Khlopina