Failed to Connect To Data Source Because Database Alias or Database Name Could Not Be Found
 Technote (FAQ)
 
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:
  1. System A, an AIX® machine, has two instances defined, db2inst1 and db2inst2.
  2. On db2inst1, database DB1 was created.
  3. On db2inst2, no databases were created.
  4. 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
 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): HP-UX
Software version: 4.0
Software edition:
Reference #: 1201618
IBM Group: Software Group
Modified date: Mar 26, 2005