check_tablespace_size

[deek]

Hello Team ,
Does anyone know how the calculation is done in the check_tablespace_size script https://github.com/angoca/monitor-db2-w ... space_size .

Because when I gave warning and critical value of 1 and 2 for testing I got an OK alert with the below message . I thought tweaking the thresholds would generate a critical alert .
[nagios@abc ~]$ /usr/local/nagios/libexec/check_by_ssh -o StrictHostKeyChecking=no -o LogLevel=ERROR -o UserKnownHostsFile=/dev/null -H hostname -l username -C "/home/username/nagios/check_tablespace_size -i '/home/db2inst1' -d 'XMETA' -n XMETA -w 1 -c 2"
Tablespace size is getting bigger (13% - Auto resize).|'Tablespace'=72351744B
Tablespace XMETA has allocated 500 MB and its watermark is at 69|'Allocated'=524288000B
'Watermark'=72351744B

[gsmith]

Hi

This is what the help is showing for that open source plugin:

Code: Select all

[root@gs-cent8-23-82 libexec]# ./check_tablespace_size -h
Andres Gomez Casanova - AngocA
v1.1 2015-10-15
Usage: check_tablespace_size { -i instanceHomeDirectory -d databaseName
[-n tablespaceName | -I tablespaceId] [-E][-c][-w][-K] | -h | -V } [-T][-v]
-------------------------------------------------------------------------------
This script check the usage of a tablespace.
-c | --critical INTEGER
   Critical percentage of usage.
   Default 90.
-d | --database STRING
   Database name.
-E | --exist
   Returns OK if the given tablespace does not exist.
-h | --help
   Shows the current documentation.
-i | --instance STRING
   Instance home directory. It is usually /home/db2inst1.
-I | --id
   ID of the tablespace. This should be usage when the name is unknown.
-K | --mk
   Changes the output to be compatible with Check_MK.
-n | --name STRING
   Tablespace name to check.
-T | --trace
   Trace mode: writes date and output in /tmp.
-v | --verbose
   Executes the script in verbose mode (multiple times).
-V | --version
   Shows the current version of this script.
-w | --warning INTEGER
   Warning level of usage.
   Default 80.
In AIX, the long name options are not supported.
Note: The test was not executed.|

I don't have a db2 database to test against, but you could see if the -v (lower case v) verbose mode sheds any light.
Outside of that you could try reaching out to the author.

Thanks!

[deek]

Thanks Team . We are good to close the ticket .