|
Problem |
While attempting to test connection to a database, the
connection fails with:
Failed to connect to data source.
Encountered COM.ibm.db2.jdbc.DB2Exception: (SQL State: 08001, Error Code:
-1013)
[IBM][CLI Driver] SQL1013N The database alias name or database name
"db_name" could not be found. SQLSTATE=42705 |
|
Cause |
DB2® has multiple components, that provide client and
server services. It is possible to install multiple instances of DB2
compnents on these client and server systems. In each instance, multiple
databases can be defined.
Here is an example:
- System A, an AIX® machine, has two instances defined, db2inst1 and
db2inst2.
- On db2inst1, database DB1 was created.
- On db2inst2, no databases were created.
- When logged in as db2inst2, if you want to connect to DB1, then you
need to catalog DB1 as a database on a remote node.
It is possible to create a database, which is cataloged by default. You
can uncatalog it, so that the database exists but can not be accessed,
until it is recatalogued. |
|
Solution |
Please check your instances of your DATABASE. This
particular error can occur when the database is in a different instance
than the WebSphere® Application Server. You can connect to your database
and issuing the commands:
CATALOG LOCAL NODE
node_name INSTANCE
target_instance_name
CATALOG DATABASE database_alias AT
NODE node_name
Please also refer to the Information Center for WebSphere Application
Server V4.0 at
http://publib.boulder.ibm.com/infocenter/ws40help/index.jsp
- section 6.6.14: Administering database connections
(overview), and
- section 6.6.14.6: Notes about various databases - for
valuable information on cataloging and performance
|
|
|
|
|
|
|