DB2 crashing with lower()-queries 
Author Message
 DB2 crashing with lower()-queries

Hi,

has anybody ever got the same problems as I have here?

Certain queries, triggered via JDBC, cause the DB2-instance
to shut down. it's a DB2V7.1fp1 on Solaris.

These queries always include a ... where lower(textfield) like
'%foo%'... or something like that, and the tables on which the
query is launched are rather big, >50k entries.

The error log says
* An internal processing error occurred   *
* on this DB2 instance.                   *
* ALL DB2 PROCESSES ASSOCIATED WITH       *
* THIS INSTANCE HAVE BEEN SHUTDOWN.       *

I assume there must me some kind of internal overflow, since the
same queries work on smaller tables, and queries with more selective
like-searchwords do work on the big tables. I have played around with
some db config size parameters, but no success so far.

thanks for any hints,
                Bodo

Sent via Deja.com
http://www.***.com/



Sat, 05 Jul 2003 19:30:34 GMT
 DB2 crashing with lower()-queries

Quote:

> Hi,

> has anybody ever got the same problems as I have here?

> Certain queries, triggered via JDBC, cause the DB2-instance
> to shut down. it's a DB2V7.1fp1 on Solaris.

> These queries always include a ... where lower(textfield) like
> '%foo%'... or something like that, and the tables on which the
> query is launched are rather big, >50k entries.

> The error log says
> * An internal processing error occurred   *
> * on this DB2 instance.                   *
> * ALL DB2 PROCESSES ASSOCIATED WITH       *
> * THIS INSTANCE HAVE BEEN SHUTDOWN.       *

Please contact DB2 Service - it's your best chance of solving a
problem like this.

--
Toodle-pip
Sailesh Krishnamurthy  
IBM Almaden Research Center
Ph: (408) 927-1913



Sun, 06 Jul 2003 02:23:05 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. UDB 5 on NT - large queries crash DB2

2. UDB 5 on NT - large queries crash DB2

3. DB2 OS/390 crashing after connection via DB2 Connect

4. DB2 V8.1 - insert-performance low

5. MS Query crashes when attempting to set up a pivot query in MS

6. lower and lower performance when restore logical log

7. Distributed DB2 - Oracle/Oracle - Oracle/DB2 - DB2/DB2

8. Update causes memory crash with ADO on DB2 UDB

9. db2java.zip crash on OS/2 (COM.ibm.db2.jdbc.app.DB2Driver)

10. REPOST: Re: db2 error in db2diag.log and LDAP crash

11. db2 instance crashes when load the data.

12. DB2 Crash


 
Powered by phpBB® Forum Software