multithread with sqleAttachToCtx SQL1224N 
Author Message
 multithread with sqleAttachToCtx SQL1224N

I have written a multithreaded application which alread runs under AIX and
NT.
Under NT i get the error:
SQL1224N  A database agent could not be started to service a request, or
was terminated as a result of a database system shutdown or a force
command.  SQLSTATE=55032

I think some configuration are wrong.
In the error description is mentioned:
o   The application is using multiple contexts with local
    protocol.  In this case the number of connections is limited
    by the number of shared memory segments to which a single
    process can be attached.  For example, on AIX, the limit is
    ten shared memory segments per process.

How can i check under RedHat 7.2 with DB2 7.2
what limit i have of shared memory segments?



Sat, 07 Aug 2004 21:58:08 GMT
 multithread with sqleAttachToCtx SQL1224N

You can bypass the shared memory segments problem altogether by cataloging
an alias that connects through loopback, this way it communicates through IP
rather than shared memory.

db2 catalog tcpip node LOOPBACK remote loopback server XXXXXX
db2 catalog database REALNAME as ALIAS at node LOOPBACK

We haven't done any formal benchmarks, however the performance hit seems
insignificant


Quote:
> I have written a multithreaded application which alread runs under AIX and
> NT.
> Under NT i get the error:
> SQL1224N  A database agent could not be started to service a request, or
> was terminated as a result of a database system shutdown or a force
> command.  SQLSTATE=55032

> I think some configuration are wrong.
> In the error description is mentioned:
> o   The application is using multiple contexts with local
>     protocol.  In this case the number of connections is limited
>     by the number of shared memory segments to which a single
>     process can be attached.  For example, on AIX, the limit is
>     ten shared memory segments per process.

> How can i check under RedHat 7.2 with DB2 7.2
> what limit i have of shared memory segments?



Mon, 09 Aug 2004 21:31:12 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DB2 - SQL1224N - WebSphere 4.0.1

2. SQL1224N on v8 AIX

3. Linux 2.4.14 + DB2 = SQL1224N

4. SQL1040N + SQL1224N

5. SQL1224N on "db2 list applications"

6. SQL1224N

7. SQL1224N

8. error SQL1224N

9. VB+DSO to process cubes multithread okay?

10. Multithread & Asp

11. MultiThread Database App won't release User Connections

12. multithread queries on local tables question


 
Powered by phpBB® Forum Software