The below problem with occurring because we cannot see
db2dsdriver.xsd in the desired location -- hence I believe the
error is thrown. Yes, error message is not accurate and should
be fixed.
db2dsdriver.cfg (for all instance)
<configuration>
<dsncollection>
<dsn alias="DB9G" name="DB9ALOC" host="host1.ibm.com"
port="50000">
<parameter name="DisableAutoCommit" value="TRUE"/>
</dsn>
</dsncollection>
<databases>
<database name="DB9ALOC" host="host1.ibm.com"
port="50000">
<wlb>
<parameter name="enableWLB" value="true" />
</wlb>
</database>
</databases>
</configuration>
DB2 connect 9.7 fixpack 6 (db2inst1)
$ db2cli validate -dsn db9g -connect -user XYS -passwd XYS
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 : 09.07.0000 ]
[ Informational Tokens: "DB2
v9.7.0.6","s120629","IP23414","Fixpack 6" ]
[ CLI Driver Type : IBM Data Server Runtime Client ]
[ db2diag.log Path :
/home/db2inst1/sqllib/db2dump/db2diag.log ]
----------------------------------------------------------------
-----------
db2dsdriver.cfg Schema Validation :
Note: The validation operation utility could not find the
configuration file named db2dsdriver.cfg.
The file is searched at
/home/db2inst1/sqllib/cfg/db2dsdriver.cfg
db2cli.ini Validation :
Note: The validation operation utility could not find the
configuration file named db2cli.ini.
The file is searched at /home/db2inst1/sqllib/cfg/db2cli.ini
db2dsdriver.cfg Validation :
----------------------------------------------------------------
-----------
[ DB2DSDRIVER_CFG_PATH env var : /home/db2inst1/sqllib/cfg ]
[ db2dsdriver.cfg Path :
/home/db2inst1/sqllib/cfg/db2dsdriver.cfg ]
----------------------------------------------------------------
-----------
[ List of keywords used for DSN : db9g ]
Keywords Valid For Value
-------------------------------------------------------
DATABASE CLI,.NET,ESQL DB9ALOC
HOSTNAME CLI,.NET,ESQL host1.ibm.com
PORT CLI,.NET,ESQL 50000
DISABLEAUTOCOMMIT CLI TRUE
----------------------------------------------------------------
-----------
Connection Section :
----------------------------------------------------------------
-----------
Connecting to: db9g
[IBM][CLI Driver] SQL30061N The database alias or database
name "DB9ALOC " was not found at the remote node.
SQLSTATE=08004
Connect Status: failure
End Connection Section
----------------------------------------------------------------
-----------
Error: The validation operation failed.
DB2 client 9.7 (fixpack 6)
$ db2cli validate -dsn db9g -connect -user XYS -passwd XYS
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 : 09.07.0000 ]
[ Informational Tokens: "DB2
v9.7.0.6","s120629","IP23414","Fixpack 6" ]
[ CLI Driver Type : IBM Data Server Client ]
[ db2diag.log Path :
/home/db2inst2/sqllib/db2dump/db2diag.log ]
----------------------------------------------------------------
-----------
db2dsdriver.cfg Schema Validation :
Note: The validation operation utility could not find the
configuration file named db2dsdriver.cfg.
The file is searched at
/home/db2inst1/sqllib/cfg/db2dsdriver.cfg
db2cli.ini Validation :
Note: The validation operation utility could not find the
configuration file named db2cli.ini.
The file is searched at /home/db2inst2/sqllib/cfg/db2cli.ini
db2dsdriver.cfg Validation :
----------------------------------------------------------------
-----------
[ DB2DSDRIVER_CFG_PATH env var : /home/db2inst1/sqllib/cfg ]
[ db2dsdriver.cfg Path :
/home/db2inst1/sqllib/cfg/db2dsdriver.cfg ]
----------------------------------------------------------------
-----------
[ List of keywords used for DSN : db9g ]
Keywords Valid For Value
-------------------------------------------------------
DATABASE CLI,.NET,ESQL DB9ALOC
HOSTNAME CLI,.NET,ESQL host1.ibm.com
PORT CLI,.NET,ESQL 50000
DISABLEAUTOCOMMIT CLI TRUE
----------------------------------------------------------------
-----------
Connection Section :
----------------------------------------------------------------
-----------
Connecting to: db9g
Connect Status: success
End Connection Section
----------------------------------------------------------------
-----------
The validation completed. |
