UDB NT - Java Stored Procedures 
Author Message
 UDB NT - Java Stored Procedures
I'm still having seemingly sporadic problems with DB2 locking up when
running my stored procedures.  Is there a common cause for this problem?
All my procedures are NON-FENCED.  All my procedures ONLY commit when
INSERTING or UPDATING values.  ...and all my procedures seem to lockup the
DB after I run them a few times.  The catch is that it doesn't always lock
the DB up.  Any ideas?  This is really starting to bother me.


Sun, 31 Jul 2005 05:04:19 GMT
 UDB NT - Java Stored Procedures

Brien Schultz wrote on Tuesday 11 February 2003 22:04:

Quote:
> I'm still having seemingly sporadic problems with DB2 locking up when
> running my stored procedures.  Is there a common cause for this problem?
> All my procedures are NON-FENCED.  All my procedures ONLY commit when
> INSERTING or UPDATING values.  ...and all my procedures seem to lockup the
> DB after I run them a few times.  The catch is that it doesn't always lock
> the DB up.  Any ideas?  This is really starting to bother me.

Do you have something in the db2diag.log?

You are sure that your procedures are 100% ok?  How about the underlying JVM?  
If not, you might want to try running the procedures FENCED for a while to
further isolate where the "lock up" (whatever you exactly mean with this) is.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena



Sun, 31 Jul 2005 15:19:07 GMT
 UDB NT - Java Stored Procedures
Try moving the sps to fenced (depending on the JVM in use there might be
issues with interop). If the problem persists, collect a db2 trace and
contact service.


Quote:
> I'm still having seemingly sporadic problems with DB2 locking up when
> running my stored procedures.  Is there a common cause for this problem?
> All my procedures are NON-FENCED.  All my procedures ONLY commit when
> INSERTING or UPDATING values.  ...and all my procedures seem to lockup the
> DB after I run them a few times.  The catch is that it doesn't always lock
> the DB up.  Any ideas?  This is really starting to bother me.



Sun, 31 Jul 2005 21:51:00 GMT
 UDB NT - Java Stored Procedures
What I meant is that the DB stopped responding to my requests in the Command
Center.  I checked out the log right away, there's nothing suspicious in
there.  I should also mention that if I "lock up" DB2 from my Command Center
executing an SP it "locks up" the DB for all other users connected remotely.


Quote:
> Brien Schultz wrote on Tuesday 11 February 2003 22:04:

> > I'm still having seemingly sporadic problems with DB2 locking up when
> > running my stored procedures.  Is there a common cause for this problem?
> > All my procedures are NON-FENCED.  All my procedures ONLY commit when
> > INSERTING or UPDATING values.  ...and all my procedures seem to lockup
the
> > DB after I run them a few times.  The catch is that it doesn't always
lock
> > the DB up.  Any ideas?  This is really starting to bother me.

> Do you have something in the db2diag.log?

> You are sure that your procedures are 100% ok?  How about the underlying
JVM?
> If not, you might want to try running the procedures FENCED for a while to
> further isolate where the "lock up" (whatever you exactly mean with this)
is.

> --
> Knut Stolze
> Information Integration
> IBM Germany / University of Jena



Mon, 01 Aug 2005 00:27:16 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Problems running Java stored procedures in UDB 6.1 on NT

2. Calling a Java Stored Procedure from another Java Stored Stored Procedure

3. Gettting SQL0751N trying to call java stored procedure from a java stored procedure

4. Calling Java Stored Procedure from SQL Stored Procedure

5. NT Java call to OS/390 Stored Procedure

6. DB2 V7.1 NT fixpack2 Java Stored Procedure

7. Error in Java Program, when it accesses DB2 UDB 7.2 from DB2 UDB 5.2 Client

8. Transfer UDB/NT table to UDB/os390 v6

9. Compatibility UDB NT and UDB AS/400 V4R4

10. Calling Java code on disc from a Java Stored Procedure

11. Deleting UDB/JDBC Stored Procedures

12. VC++ 6.0 vs VC++.NET and IBM UDB Stored Procedures


 
Powered by phpBB® Forum Software