Nagios Support Forum

Code: Select all

[root@localhost iSeriesAccess]# isql

**********************************************
* unixODBC - isql                            *
**********************************************
* Syntax                                     *
*                                            *
*      isql DSN [UID [PWD]] [options]        *
*                                            *
* Options                                    *
*                                            *
* -b         batch.(no prompting etc)        *
* -dx        delimit columns with x          *
* -x0xXX     delimit columns with XX, where  *
*            x is in hex, ie 0x09 is tab     *
* -w         wrap results in an HTML table   *
* -c         column names on first row.      *
*            (only used when -d)             *
* -mn        limit column display width to n *
* -v         verbose.                        *
* -lx        set locale to x                 *
* -q         wrap char fields in dquotes     *
* -3         Use ODBC 3 calls                *
* -n         Use new line processing         *
* -e         Use SQLExecDirect not Prepare   *
* -k         Use SQLDriverConnect            *
* --version  version                         *
*                                            *
* Commands                                   *
*                                            *
* help - list tables                         *
* help table - list columns in table         *
* help help - list all help options          *
*                                            *
* Examples                                   *
*                                            *
*      isql WebDB MyID MyPWD -w < My.sql     *
*                                            *
*      Each line in My.sql must contain      *
*      exactly 1 SQL command except for the  *
*      last line which must be blank (unless *
*      -n option specified).                 *
*                                            *
* Please visit;                              *
*                                            *
*      http://www.unixodbc.org               *
*      [email protected]                      *
*      [email protected]              *
**********************************************

[root@localhost iSeriesAccess]# isql AS400 nagios nagios -v
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect

Code: Select all

[AS400]
Description=IBM i Access for Linux ODBC Driver
Driver=/opt/ibm/iSeriesAccess/lib/libcwbodbc.so
Setup=/opt/ibm/iSeriesAccess/lib/libcwbodbcs.so
Driver64=/opt/ibm/iSeriesAccess/lib64/libcwbodbc.so
Setup64=/opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so
Threading=0
DontDLClose=1
UsageCount=1

[AS400_64]
Description=IBM i Access for Linux 64-bit ODBC Driver
Driver=/opt/ibm/iSeriesAccess/lib64/libcwbodbc.so
Setup=/opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so
Threading=0
DontDLClose=1
UsageCount=1

Code: Select all

# cat /etc/odbc.ini
[DEFAULT]
Driver = DEFAULT

Code: Select all

# cat /etc/odbcinst.ini
[DEFAULT]
Description = Default Driver
Driver = /opt/ibm/db2/V10.5/lib64/libdb2.so
fileusage=1
dontdlclose=1

Code: Select all

# isql DB2 nagios nagios -v
[58031][unixODBC][IBM][CLI Driver] SQL1031N  The database directory cannot be found on the indicated file system.  SQLSTATE=58031

[ISQL]ERROR: Could not SQLConnect

Code: Select all

# ./db2licm -l
Product name:                     "IBM Data Server Client"
Product identifier:               "db2client"
Version information:              "10.5"

Code: Select all

# ./check_db2_health --port  *** --hostname kpms01.*******.** --username nagios --password nagios --database ********  --mode connection-time
CRITICAL - cannot connect to kpms01.********.**. [IBM][CLI Driver] SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968