|
Home > Archive > WebSphere Application Server > October 2004 > Websphere DB2 Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Websphere DB2 Error
|
|
| nauman 2004-09-28, 11:25 pm |
| Hi,
we are using one WAS 5.0 application server to access two DB2 databases.
Folliwng are the details:
Application Server: 1 server, WAS 5.0.2
Applications: 2, Appl-1, Appl-2
Database Client: 1, DB2 7.2
Database Server: 2, DB28.0 (catalouged on database instance DB28I)& DB27.2 (catalouged on database instance DB272I)
Appl-1 access DB28.0 and Appl-2 access DB27.2
We have catalouged the databases and bound the packages on the application server. But after starting the servers, anyone of the two applications which first access the database runs successfully the other application throws the error "SQL10013N".
The sequence of steps is as follows:
1. Appl-1 access the database DB28.0 successfully (by executing the stored procedure STORED PROCEDURE "DB28SCH.APP1SP1"
2. Appl-2 tries to access the DB27.2 database but got the "SQL10013N" error with the following error message:
Error in executing the jdbc query SQLState:HY000[root cause:COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/SUN] SQL10013N The specified library "/usr/local/db2/DB28I/sqllib/function/DB272SCH.APP2SP1" could not be loaded.
Please note that the Appl-2 is trying to find its stored procedures in the first database instance (DB28I) instead of its own database instance (DB272I).
If we change the sequence of above steps then in that case the Appl-2 runs sussessfully but then Appl-1 throws the same error (Appl-1 tries to find its stored procedures in the other database instance DB272I instead of its catalouged instance DB28I).
We have uncatalouged/recatlouged and rebound the stored procedures several times but still getting the same error.
Any help in this regard would be highly appreciated.
Thanks
Nauman | |
| Doug Breaux 2004-09-29, 8:11 pm |
| You're using the "DB2 Legacy CLI-based Type 2 JDBC Driver", right? I've
certainly never tried the combination of things you're describing, so it's
possible it doesn't work :-( It seems as though the client is somehow
communicating to the server where it should load the stored procedure from.
I'd definitely ask on the DB2 forum as I expect it's more of an issue with the
JDBC driver than with WebSphere.
A possible workaround, though, is to start using the new Type 4 driver for you
v8 server (DB2 Universal JDBC Driver Provider). It doesn't connect through
the local client, but directly over the network. I'd bet that your
applications would then no longer interfere with each other.
If you do this, you'll want to regression test your v8 application since a few
datatypes seem to be differently supported between the versions (CLOBs, in our
case).
BTW, you probably already know this, but DB2 v7 is no longer supported as of
Sep 30th. That's why we're upgrading.
<http://www-1.ibm.com/support/docvie...7Z&context=SSLQ
WS&context=SSRTQH&context=SS6HAH&context=SS6MVZ&context=SSEMCY&context=SSLQSW&context=SS4NVZ&context=SSRTM7&context=SSSH7C&context=SSSGZS&context=SSKJJR&context=SSCRLG&context=SSNW5W&context=SSCVQTU&context=SSRTHY&context=SSEPFB&context=SSYUVL&context=SSK
JKE&context=SSEPGG&context=SSKJL2&context=SS6E56&context=SSEPH2&context=SSGHZP&context=SSHPYE&context=SSVT2J&context=SSEPHG&context=SSCRW7&context=SSKJG3&context=SSKJJZ&context=SSVT37&context=SSKJMP&context=SSCRY4&context=SSEPK9&context=SSJQXX&q1=end+of+s
ervice&uid=swg21168270&loc=en_US&cs=utf-8&lang=en>
Doug
nauman wrote:
> Hi,
> we are using one WAS 5.0 application server to access two DB2
> databases.
> Folliwng are the details:
> Application Server: 1 server, WAS 5.0.2
> Applications: 2, Appl-1, Appl-2
> Database Client: 1, DB2 7.2
> Database Server: 2, DB28.0 (catalouged on database instance DB28I)&
> DB27.2 (catalouged on database instance DB272I)
>
> Appl-1 access DB28.0 and Appl-2 access DB27.2
>
> We have catalouged the databases and bound the packages on the
> application server. But after starting the servers, anyone of the two
> applications which first access the database runs successfully the
> other application throws the error "SQL10013N".
>
> The sequence of steps is as follows:
> 1. Appl-1 access the database DB28.0 successfully (by executing the
> stored procedure STORED PROCEDURE "DB28SCH.APP1SP1"
> 2. Appl-2 tries to access the DB27.2 database but got the "SQL10013N"
> error with the following error message:
> Error in executing the jdbc query SQLState:HY000[root
> cause:COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/SUN]
> SQL10013N The specified library
> "/usr/local/db2/DB28I/sqllib/function/DB272SCH.APP2SP1" could not be
> loaded.
>
> Please note that the Appl-2 is trying to find its stored procedures in
> the first database instance (DB28I) instead of its own database
> instance (DB272I).
>
> If we change the sequence of above steps then in that case the Appl-2
> runs sussessfully but then Appl-1 throws the same error (Appl-1 tries
> to find its stored procedures in the other database instance DB272I
> instead of its catalouged instance DB28I).
>
> We have uncatalouged/recatlouged and rebound the stored procedures
> several times but still getting the same error.
>
> Any help in this regard would be highly appreciated.
> Thanks
> Nauman
--
Doug
| |
| nauman 2004-10-06, 4:02 pm |
| Hi Doug,
I aplogize for late reply.
Thank You Very Much for your response.
The issue was with the 3rd part code.The third party component was loading the datasource for the database which was first called by any application. e,g, if there are 2 databases(database1,datasource1,apps1, database2,datasource2,apps2, ) then the third party component was loading datasource1 for both databases (instead of the 2 separate datasources for 2 applications) if the app1 was trying to hit the database1.
So, this was because of the singleton implementation. Once that error is fixed everything is weorking fine. No issue with the database/drivers.
Kind Regards
nauman |
|
|
|
|