Shulou(Shulou.com)06/01 Report--

I think you all know that Nagios monitors the DB2 database using the check_db2_oracle plug-in, but before you can use it, you need to install the runtime on the Nagios server. Combined with many of my own tests, I focus on how to install the plug-in check_db2_oracle runtime environment in the CenOS6.7 64bit environment. Ok, cut the crap. Let's do it!

The running environment in which the plug-in check_db2_oracle is installed in the 1.CenOS6.7 environment.

Step 1: install DBI, using the command: perl-MCPAN-e 'install DBI'

Step 2: install libstdc++, using command: yum install libstdc++-devel.i686

Step 3: install pam, using the command: yum install pam-devel.i686

Step 4: install IBM Data Server Runtime Client. The corresponding version is Linux AMD64 and Intel EM64T,Version XX.X. The default installation DB2_HOME is: / opt/ibm/db2/VXX.X

Step 5: add the environment variable: export DB2_HOME=/opt/ibm/db2/VXX.X;export LD_LIBRARY_PATH=/opt/ibm/db2/VXX.X/lib64

Step 6: create groups and accounts:

1) groupadd db2grp1

2) groupadd db2fgrp1

3) groupadd dasadm1

4) useradd-g db2grp1-m-d / home/db2inst1 db2inst1

5) useradd-g db2fgrp1-m-d / home/db2fenc1 db2fenc1

6) useradd-g dasadm1-m-d / home/dasusr1 dasusr1

7) / opt/ibm/db2/V11.1/instance/db2icrt db2inst1

Step 7: install ibm_data_server_driver_package_linuxx64

1) tar zxf ibm_data_server_driver_package_linuxx64_v11.1.tar.gz

2) cd dsdriver

3). / installDSDriver

4) mv include / opt/ibm/db2/VXX.X/ Note: this step mainly prevents errors like the following when installing DBD-DB2-1.85:

> Constants.xs:16:20: sqlcli.h: No such file or directory

> Constants.xs:16:20: sqlcli1.h: No such file or directory

> Constants.xs:16:20: sqlext.h: No such file or directory

Step 8: install DBD-DB2-1.85

1) tar zxf DBD-DB2-1.85.tar.gz

2) cd DBD-DB2-1.85

3) perl Makefile.PL

4) make

5) make test

6) make install

The successful completion of the above eight steps means that the running environment for check_db2_oracle is complete. Next we will run check_db2_oracle.

two。 Install check_db2_oracle in the appropriate directory, mine is under / usr/local/nagios/libexec. To run check_db2_oracle, you need to load the environment variable: export DB2_HOME=/opt/ibm/db2/VXX.X;export LD_LIBRARY_PATH=/opt/ibm/db2/VXX.X/lib64

. / check_db2_health-hostname xxxx-port 50000-username=xxxx-password=xxxx-database=xxxx-mode=lock-waits

Results:

OK-0.001567 lock waits / sec | lock_waits_per_sec=0.001567;10;100

In addition, for the download of check_db2_health and the introduction of its own functions, please refer to https://labs.consol.de/nagios/check_db2_health/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.