From: Taylor, David (DTaylor@WBMI.COM)
Date: Fri May 02 2003 - 11:51:10 EDT
Make sure that you have the database in instance A cataloged properly in instance B. That would explain why it is looking for it locally.
# db2 catalog tcpip node <nodename> remote <hostname> server <portnumber>
# db2 catalog db <spm_name> at node <nodename>
<nodename> = alias name of the database to which you're connecting. <server> = internet address of the DB2 server (example: db2server.wbmi.com)
<port number> = check SVCENAME in database manager configuration, then match it with /etc/services listing is if isn't a number;usually 50000
<spm_name> = SPM_NAME database alias from database manager configuration.
HTH
David
-----Original Message-----
From: RANGI, JAI [mailto:JAI_RANGI@SDSTATE.EDU]
Sent: Friday, May 02, 2003 10:35 AM
To: aix-l@Princeton.EDU
Subject: About DB2
Question for DB2 Gurus how can help me with this...
My application in webshere is trying to access database in instance A. and it gives the error SQl1013N, Database not found. Instance A username and password are provided properly and Database is there.
Somehow it is looking for database in instance B, I check this, when I give the username and password for instance B, and create a sample database in instance B, it can access the database in instance B with no problem
Now I am concerned is that why it is not accessing the database in instance A even after providing instance A username and password and giving the right database existing in instance A.
DB2 ad WebSphere are installed on AIX 5.1
Any hint will be appreciated.
Thanks
Jai Rangi
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:48 EDT