Using SA, I'm trying to figure out an application problem ("post-mortem").

In the server's message log (dbsrv12 -o ...) there's a hint than the particular application has been disconnected abnormally. As this app runs locally and uses shared memory to connect, I'm puzzled that two messages tell me that

  • a client socket was deactivated and
  • a TCP/IP client has been disconnected, with the local IP address.

Is that simply a not correct wording in the error message, or should I conclude the app may have connected differently than expected?

I assume the former: Starting a local app makes sa_conn_info() lists the CommLink as "local" but killing the process still tells about a disconnected TCP/IP client.

asked 09 Mar '12, 05:01

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

For me the message for a shared memory client reads:

Disconnecting shared memory client, process id not found
Disconnected SharedMemory client's AppInfo: ...

and for a tcp client:

Connection terminated abnormally
Disconnected TCPIP client's AppInfo: ...

Tested with

permanent link

answered 09 Mar '12, 06:05

Martin's gravatar image

accept rate: 14%

edited 09 Mar '12, 06:05


Yes, I verified this with - the messages are obviously correct.

I have figured out the problem is a different one:

When migrating to v12, I have specified the new v12 HOST parameter, and that makes even local connections using TPC/IP - which I was not aware of...

So the particular app is not using ShMem at all (in contrast to what I had expected), and the log messages are correct.

(09 Mar '12, 07:22) Volker Barth
Replies hidden

That is really unexpected! I also thought, that shared memory is preferred always over tcpip if possible.

(09 Mar '12, 08:28) Martin

Yep, see my new question:)

(09 Mar '12, 08:32) Volker Barth

This is expected behaviour. See my response to your question.

(09 Mar '12, 09:11) Mark Culp

Well, "expected behaviour" isn't a NPOV: Obviously developers and users of the product may have different ideas:)

(09 Mar '12, 09:20) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 09 Mar '12, 05:01

question was seen: 4,060 times

last updated: 09 Mar '12, 09:20