You can validate installation of the IBM® Data Server Driver Package for the most popular interfaces, such as CLI/ODBC, ADO.NET and Visual Studio.
You can download the IBM Data Server Driver Package by using the following link: https://www-304.ibm.com/support/docview.wss?rs=4020&uid=swg27016878.
After installing IBM Data Server Driver Package, you can validate the installation for CLI / ODBC using the db2cli validate command.
The following sample db2dsdriver.cfg file is configured with DSN alias as sampledsn, database name as sample, hostname as samplehost.domain.com and port as 19766.
<configuration>
<dsncollection>
<dsn alias="sampledsn" name="sample" host="samplehost.domain.com" port="19766"/>
</dsncollection>
<databases>
<database name="sample" host="samplehost.domain.com" port="19766">
</database>
</databases>
</configuration>
IBM data server clients (the IBM Data Server Client or the IBM Data Server Runtime Client), you can use the db2cli validate command to list the installed client packages on a Windows operating system. When you issue the db2cli validate command from the IBM data server clients, the list is limited to theIBM data server clients that are installed on the Windows operating system. To list IBM Data Server Driver for ODBC and CLI packages and the IBM data server client packages that are installed on a Windows operating system, you must issue the db2cli validate command from the IBM Data Server Driver for ODBC and CLI installation. The list indicates the current copy name as [C] and the default copy name as [D].
C:\CLIDRIVER\bin>db2cli validate
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------
[ CLI Driver Version : 10.0X.0000 ]
[ Informational Tokens : "DB2 v10.X.XXX.XXX","nXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Driver for ODBC and CLI ]
IBM Data Server client packages on the current workstation:
Copyname Version Installed Location
---------------------------------------------------------------------
C_CLIDRIVER[C] 09.07.0600 C:\CLIDRIVER
DB2COPY1[D] 09.07.0500 E:\SQLLIB
DB2COPY2 09.01.0700 C:\Program Files\IBM\SQLLIB_01\
DB2COPY3 09.07.0301 C:\Program Files\IBM\SQLLIB\
DSCOPY 09.07.0500 C:\IBM\IBM DATA SERVER DRIVER\
---------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Success: The schema validation operation completed successfully.
The configuration file C:\Documents and Settings\All Users\Application Data\IBM\
DB2\C_CLIDRIVER\cfg\db2dsdriver.cfg is valid
The validation completed.
On a 64-bit Windows system, both db2cli32.exe and db2cli.exe have
same output.The location of the db2dsdriver.cfg file differs between IBM Data Server Client and IBM Data Server Driver.
You can find the location of the db2dsdriver.cfg file by using the db2cli command with the validate parameter.
db2cli.exe validate -dsn dummy
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------------
[ CLI Driver Version : 10.XX.0000 ]
[ Informational Tokens : "DB2 v10.X.X.X","sXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Driver For ODBC and CLI ]
---------------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Success: The schema validation operation completed successfully.
The configuration file ../cfg/db2dsdriver.cfg is valid
Note: The validation operation utility could not find the
configuration file named db2cli.ini.
The file is searched at ../cfg/db2cli.ini
db2dsdriver.cfg Validation :
---------------------------------------------------------------------------
[ DB2DSDRIVER_CFG_PATH env var : unset ]
[ db2dsdriver.cfg Path : ../cfg/db2dsdriver.cfg ]
---------------------------------------------------------------------------
[ Valid keywords used for DSN : alias1 ]
Keyword Value
--------------------------------------------------
DATABASE name1
HOSTNAME server1.net1.com
PORT 50001
CURRENTSCHEMA OWNER1
[ Parameters used for WLB ]
Parameter Value
--------------------------------------------------
enableWLB true
maxTransports 50
[ Parameters used for ACR ]
Parameter Value
--------------------------------------------------
enableACR true
[ Keywords UNKNOWN for DSN : alias1 ]
Keyword Value
--------------------------------------------------
GlobalParam Value
---------------------------------------------------------------------------
The validation completed.
You can issue the db2cli validate -dsn sampledsn command to validate the DSN alias sampledsn that is configured in the db2dsdriver.cfg file. All valid entries are listed in the command output.
db2cli validate -dsn alias1
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------------
[ CLI Driver Version : 10.0X.0000 ]
[ Informational Tokens : "DB2 v10.X.XXX.XXX","nXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Client ]
[ db2diag.log Path : C:\Documents and Settings\All Users\Application Data\IBM\DB2\db2build\DB5\db2diag.log ]
---------------------------------------------------------------------------
IBM Data Server Client packages on the current workstation :
Copyname Version Installed Location
---------------------------------------------------------------------------
db2build[C] 10.XX.XXXX E:\sqllib
IBMDBCL1[D] 10.XX.XXXX C:\Program Files\IBM\IBM DATA SERVER DRIVER
---------------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Success: The schema validation operation completed successfully.
The configuration file C:\Documents and Settings\All Users\Application Data\IBM\DB2\db2build\cfg\db2dsdriver.cfg is valid
Note: The validation operation utility could not find the configuration file named db2cli.ini.
The file is searched at C:\Documents and Settings\All Users\Application Data\IBM\DB2\db2build\cfg\db2cli.ini
db2dsdriver.cfg Validation :
---------------------------------------------------------------------------
[ DB2DSDRIVER_CFG_PATH env var : unset ]
[ db2dsdriver.cfg Path : C:\Documents and Settings\All Users\Application Data\IBM\DB2\db2build\cfg\db2dsdriver.cfg ]
---------------------------------------------------------------------------
[ List of Keywords used for DSN : alias1 ]
Keywords Valid For Value
----------------------------------------------------------
DATABASE CLI,.NET,ESQL STLEC1
HOSTNAME CLI,.NET,ESQL INEC002.svldev.svl.ibm.com
PORT CLI,.NET,ESQL 446
CURRENTSCHEMA CLI,.NET **DUPLICATE**
DISABLEAUTOCOMMIT CLI FALSE
COMMPROTOCOL CLI TCPIP
COMMITONEOF CLI,.NET TRUE
COLUMNWISEMRI CLI TRUE
DISABLEPOOLING .NET TRUE
csmbuffersize **UNKNOWN**
XMLDeclaration **UNKNOWN**
[ Parameters used for WLB ]
Parameter Value
----------------------------------------------------------
enableWLB true
maxTransports 50
[ Parameters used for ACR ]
Parameter Value
----------------------------------------------------------
enableACR true
enableSeamlessACR true
Alternate Server List :
Name - S1 Hostname - jcc.svl.ibm.com Port - 446
Name - S2 Hostname - host1_placeholder Port - 446
Name - S3 Hostname - host2_placeholder Port - 446
Affinity List :
Name - list1 Serverorder - S1,S2,S3
Name - list2 Serverorder - S2,S1,S3
---------------------------------------------------------------------------
The validation completed.
db2cli validate -dsn sampledsn
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------------
[ CLI Driver Version : 10.XX.XXXX ]
[ Informational Tokens : "DB2 v10.X.XXX.XXX","sXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Driver Package ]
[ CLI Copy Name : IBMDBCL1 ]
---------------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Warning: The schema validation operation completed successfully.
The following data source name was not found in the db2cli.ini file: "sampledsn".
The file is at C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2cli.ini
db2dsdriver.cfg Validation :
-----------------------------------------------------------------------------------
[ DB2DSDRIVER_CFG_PATH env var : unset ]
[ db2dsdriver.cfg Path : C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg ]
-----------------------------------------------------------------------------------
[ Keywords used by CLI for DSN : sampledsn ]
Keyword Value
------------------------------------------
DATABASE sample
HOSTNAME samplehost.domain.com
PORT 19766
------------------------------------------
The validation completed.
db2cli validate -all
===============================================================================
Client information for the current copy (copy name: IBMDBCL1):
===============================================================================
Client Package Type : IBM Data Server Driver Package
Client Version (level/bit): DB2 v10.XX.XXX.XXX (nXXXXXX/XX-bit)
Client Platform : NT
Install/Instance Path : C:\SQLLIB\clidriver
Common App Data Path : C:\Documents and Settings\All Users\Application Data
\IBM\DB2\db2build
DB2DSDRIVER_CFG_PATH value: <not-set>
db2dsdriver.cfg Path : <Common App Data Path>\cfg\db2dsdriver.cfg
DB2CLIINIPATH value : <not-set>
db2cli.ini Path : <Common App Data Path>\cfg\db2cli.ini
db2diag.log Path : <Common App Data Path>\db2diag.log
===============================================================================
List of all IBM Data Server client packages on the current workstation:
===============================================================================
Copy name Version Package Language Installed Location
--------------------------------------------------------------------------------
DB2COPY1 10.X.XX ESE EN C:\Program Files\IBM\SQLLIB
IBMDBCL1[C,D] 10.X.XX DSD ALL_LANG C:\Program Files\IBM\IBM DATA SERVER DRIVER
--------------------------------------------------------------------------------
ESE : IBM DB2 Enterprise Server Edition
DSD : IBM Data Server Driver Package
--------------------------------------------------------------------------------
===============================================================================
db2dsdriver.cfg schema validation for the entire file:
===============================================================================
Success: The schema validation completed successfully without any errors.
===============================================================================
db2cli.ini validation for data source name "dsnName":
===============================================================================
Note: The validation utility could not find the configuration file db2cli.ini.
The file is searched at "C:\Documents and Settings\All Users\Application
Data\IBM\DB2\db2build\cfg\db2cli.ini".
===============================================================================
db2dsdriver.cfg validation for data source name "dsnName":
===============================================================================
[ Parameters used for the connection ]
Keywords Valid For Value
---------------------------------------------------------------------------
DATABASE CLI,.NET,ESQL sample
HOSTNAME CLI,.NET,ESQL localhost
PORT CLI,.NET,ESQL 50000
COMMITONEOF CLI,.NET 1
ISOLATIONLEVEL CLI,.NET readcommitted
CURRENTSCHEMA CLI,.NET test1
COMMPROTOCOL CLI tcpip
AUTHENTICATION CLI,.NET server_encrypt
ClientAplicationName **UNKNOWN**
isolatonlevel **UNKNOWN**
isolationlevl **UNKNOWN**
[ Parameters used for WLB ]
Parameter Value
---------------------------------------------------------------------------
enablewlb true
maxtransports 25
enableSeamlessAcr **UNKNOWN**
[ Parameters used for ACR ]
Parameter Value
---------------------------------------------------------------------------
enableacr true
maxacrretries 3
acrRetryIntrval **UNKNOWN**
Connecting to: sample:localhost:50000 [SUCCESS]
===============================================================================
db2cli.ini validation for database "prod:localhost:50000":
===============================================================================
Note: The validation utility could not find the configuration file db2cli.ini.
The file is searched at "C:\Documents and Settings\All Users\Application
Data\IBM\DB2\db2build\cfg\db2cli.ini".
===============================================================================
db2dsdriver.cfg validation for database "prod:localhost:50000":
===============================================================================
[ Parameters used for the connection ]
Keywords Valid For Value
---------------------------------------------------------------------------
CURRENTSCHEMA CLI,.NET test2
COMMPROTOCOL CLI tcpip
AUTHENTICATION CLI,.NET server_encrypt
isolationlevl **UNKNOWN**
[ Parameters used for WLB ]
Parameter Value
---------------------------------------------------------------------------
enablewlb true
maxtransports 15
[ Parameters used for ACR ]
Parameter Value
---------------------------------------------------------------------------
enableacr true
Connecting to: prod:localhost:50000 [FAILED]
[IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USE
RNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
===============================================================================
db2cli.ini validation for database "sample:localhost:50000":
===============================================================================
Note: The validation utility could not find the configuration file db2cli.ini.
The file is searched at "C:\Documents and Settings\All Users\Application
Data\IBM\DB2\db2build\cfg\db2cli.ini".
===============================================================================
db2dsdriver.cfg validation for database "sample:localhost:50000":
===============================================================================
[ Parameters used for the connection ]
Keywords Valid For Value
---------------------------------------------------------------------------
CURRENTSCHEMA CLI,.NET test1
COMMPROTOCOL CLI tcpip
AUTHENTICATION CLI,.NET server_encrypt
isolatonlevel **UNKNOWN**
isolationlevl **UNKNOWN**
[ Parameters used for WLB ]
Parameter Value
---------------------------------------------------------------------------
enablewlb true
maxtransports 25
enableSeamlessAcr **UNKNOWN**
[ Parameters used for ACR ]
Parameter Value
---------------------------------------------------------------------------
enableacr true
maxacrretries 3
acrRetryIntrval **UNKNOWN**
Connecting to: sample:localhost:50000 [SUCCESS]
===============================================================================
The validation is completed.
===============================================================================
[IBM][CLI Driver] SQL1598N An attempt to connect to the database server
failed because of a licensing problem. SQLSTATE=42968
If you are using DB2 Connect Unlimited Edition for z/OS®, you can use a server-based license key. This one step prevents the need for client-based license keys. For details, see the topic about activating the license key for DB2 Connect Unlimited Edition for System z®.
If you are unable to use the server-based license key, take the DB2 Connect license key from the DB2 Connect Edition that you have purchased (eg: db2conpe.lic) and type it in the C:\Program Files\IBM\IBM DATA SERVER DRIVER\license license directory, underneath the installation location for the IBM Data Server Driver Package.
db2cli bind "@<ds driver install path> \bnd\db2cli.lst" -dsn sampledsn -user <userid> -passwd <password> -options "grant public collection nullid"
After the db2dsdriver.cfg file is populated with the correct database connection information, register the DSN alias with the ODBC driver manager as a datasource. You can make the data source available to all users of the system (a system data source), or only to the current user (a user data source).
To test the CLI connection that uses DSN and database section entries in the db2dsdriver.cfg file, issue db2cli validate -dsn dsnName -connect -user userID -passwd password, as shown in the following example:
db2cli validate -dsn sample -connect -user userID -passwd password
IBM DATABASE 2 Interactive CLI Sample Program
(C) COPYRIGHT International Business Machines Corp. 1993,1996
All Rights Reserved
Licensed Materials - Property of IBM
US Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
---------------------------------------------------------------------------
[ CLI Driver Version : 10.0X.XXXX ]
[ Informational Tokens : "DB2 v10.X.XXX.XXX","sXXXXXX","IPXXXXX","Fixpack X" ]
[ CLI Driver Type : IBM Data Server Driver Package ]
[ CLI Copy Name : IBMDBCL1 ]
---------------------------------------------------------------------------
db2dsdriver.cfg Schema Validation :
Success: The schema validation operation completed successfully.
The configuration file C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg is valid
Note: The validation operation utility could not find the
configuration file named db2cli.ini.
The file is searched at C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2cli.ini
db2dsdriver.cfg Validation :
---------------------------------------------------------------------------
[ DB2DSDRIVER_CFG_PATH env var : unset ]
[ db2dsdriver.cfg Path : C:\Documents and Settings\All Users\Application Data\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg ]
---------------------------------------------------------------------------
[ Valid keywords used for DSN : sample ]
Keyword Value
--------------------------------------------------
DATABASE STLEC1
HOSTNAME TOREC48.ibm.com
PORT 446
---------------------------------------------------------------------------
Connection Section :
---------------------------------------------------------------------------
Connecting to: sample
Connect Status: success
End Connection Section
---------------------------------------------------------------------------
The validation completed.
C:\>clpplus db2admin@sampledsn
CLPPlus: Version 1.4
Copyright (c) 2009, 2011, IBM CORPORATION. All rights reserved.
Enter password: **********
Database Connection Information :
---------------------------------
Hostname = samplehost.domain.com
Database server = DB2/NT SQLXXXXX
SQL authorization ID = db2admin
Local database alias = SAMPLEDSN
Port = 19766
Create a system data source name (DSN) for DSN alias sampledsn by using the db2cli registerdsn -add sampledsn -system command.
db2cli32 registerdsn -add sampledsn -system
You can test the newly created ODBC DSN by using Microsoft applications, such as MS Excel.
Procedure
C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn20 -dtc
"database=sampledsn;uid=username;pwd=password"
adding MSDTC step
Step 1: Printing version info
.NET Framework version: X.X.XXXXX.XXXX
DB2 .NET provider version: X.X.X.X
DB2 .NET file version: XX.X.X.X
Capability bits: ALLDEFINED
Build: sXXXXXX
Factory for invariant name IBM.Data.DB2 verified
Elapsed: 1.2969165
Step 2: Validating db2dsdriver.cfg against db2dsdriver.xsd schema file
C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg against
C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.xsd
Elapsed: 0
Step 3: Connecting using "database=sampledsn;uid=username;pwd=password"
Server type and version: DB2/NT 09.07.0003
Elapsed: 2.8594665
Step 4: Selecting rows from SYSIBM.SYSTABLES to validate existence of packages
SELECT * FROM SYSIBM.SYSTABLES FETCH FIRST 5 rows only
Elapsed: 0.3281355
Step 5: Calling GetSchema for tables to validate existence of schema functions
Elapsed: 0.906279
Step 6: Creating XA connection
DB2TransactionScope: Connection Closed.
Elapsed: 3.2657295
Test passed.
You can ignore the VSAI is not installed
properly error. This error is displayed because VSAI is
only available in 32-bit, and is not detected by a 64-bit testconn20.
The 32-bit version of testconn20 should properly
report VSAI information.C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn20 -dtc
"database=sample;server=samplehost.domain.com:19766;uid=username;pwd=password"
C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn20_32 -dtc
"database=sampledsn;uid=username;pwd=password" adding MSDTC step
Step 1: Printing version info
.NET Framework version: X.X.XXXXX.XXXX
DB2 .NET provider version: X.X.X.X
DB2 .NET file version: XX.X.X.X
Capability bits: ALLDEFINED
Build: sXXXXXX
Factory for invariant name IBM.Data.DB2 verified
Elapsed: 1.2969165
Step 2: Validating db2dsdriver.cfg against db2dsdriver.xsd schema file
C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg against
C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.xsd
Elapsed: 0
Step 3: Connecting using "database=sampledsn;uid=username;pwd=password"
Server type and version: DB2/NT 09.07.0003
Elapsed: 2.8594665
Step 4: Selecting rows from SYSIBM.SYSTABLES to validate existence of packages
SELECT * FROM SYSIBM.SYSTABLES FETCH FIRST 5 rows only
Elapsed: 0.3281355
Step 5: Calling GetSchema for tables to validate existence of schema functions
Elapsed: 0.906279
Step 6: Creating XA connection
DB2TransactionScope: Connection Closed.
Elapsed: 3.2657295
Test passed.
Microsoft Excel 2003 |
|
Microsoft Excel 2007/2010/2013 | Select . |
There are two types of PHP builds available. One PHP build is TS (thread safe) and other is NTS (non-thread safe). It is necessary to use corresponding build type of PHP drivers. To check the installed PHP build type, run the following command:
$ php -i | findstr "Thread Safety"
Only the 32-bit version of the PHP drivers are shipped in the DS drivers.
The following steps need to be followed to install the PHP driver:
$ copy IBM DS Driver Install Path/php32/ibm_db2_XX[ts/nts].dlllocal_php_directory/php/ext
$ copy IBM DS Driver Install Path/php32/pdo_db2_XX[ts/nts].dlllocal_php_directory/php/ext
The
two PHP drivers are ibm_db2 and pdo_db2.
Also, The local_php_directory refers to the path
where PHP is installed.extension=ibm_db2_XX_[ts/nts].dll
extension=pdo_ibm_XX_[ts/nts].dll
You can verify that you
successfully configured the IBM PHP
driver modules by running the validate program validate_install.php,
which is in the bin directory of the installed
DS driver. To validate the IBM PHP
drivers with the validate_install.php program,
you can either connect to the DSN alias sampledsn as
specified in the db2dsdriver.cfg file. You can also
specify the connection details as arguments to the validate_install.php program.
The validate_install.php program connects to a
database on a specified server and returns a message that notifies
you of a successful or unsuccessful connection. Run the following
command to run the validate_install.php program:$php validate_install.php database name DSN alias port number username password
The
following sample output is an example of what is returned after a
successful connection is established:$ cd IBM DS Driver Install Path/
$ php bin/validate_install.php sampledsn
Connection to database sampledsn, using ibm_db2 module, is successful.
Connection to database sampledsn, using pdo_ibm module, is successful.
[OR]
$ php bin/validate_install.php sample samplehost.domain.com
50000 username password
Connection to database sample, using ibm_db2 module, is successful.
Connection to database sample, using pdo_ibm module, is successful.
The Program cannot start because phpx<ts>.dll is missing from your computer. Try reinstalling the program to fix this problem
This
message means that the PHP is built for 64-bit architecture or that
the PHP driver modules were not properly copied.The DS driver contains the 32-bit version of the Python driver. To install the 32-bit Python driver components, run following commands:
$ easy_install IBM DS Driver Install Path/python32/ibm_db-xx-xx.egg$
easy_install IBM DS Driver Install Path/python32/ibm_db_django-xx-xx.egg
$ easy_install IBM DS Driver Install Path/python32/ibm_db_sa-xx-xx.egg
You can run the validate_install.py program to verify the successful installation of the python driver. The validate_install.py program is in the directory where the DS driver is installed. To validate the Python driver with the validate_install.py program, you can connect to the DSN alias sampledsn as defined in the db2dsdriver.cfg file. You can also specify the connection details as argument to the validate_install.py program. This Python program connects to a database on the specified server and prints whether the connection was successful or not. Run the validate_install.py program by running the following command:
$python validate_install.py database name DSN alias port number username password
The
following sample output is an example of what is returned after a
successful connection is established:$ cd IBM DS Driver Install Path/
$ python bin/validate_install.py sampledsn
Connection to database sampledsn is successful.
[OR]
$ python bin/validate_install.py sample samplehost.domain.com
50000 username password
Connection to database sample is successful.