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?
