[Chak Kwok Yin]

Hi Garry

Is allocating input and output parameters important as this is what is missing from my tcl. Also, I’m not familiar with this type of store procedure, can you break this syntax for me?

clinicom =

ict_chi_search =

get_by_dsf =

# Setup SP Call

set SQLCmd “begin clinicom.ict_chi_search.get_by_dsf(?,?,?,?,?,?,?,?,?,?,?); end;”

[Chak Kwok Yin]

Hi Richard Hart

Finally, our database administrator have the database fine tuned and the slowness is resolved. The tables are growing huge and monthly maintenance needs to be in place besides regular archiving.

We’ve returned back to mlp_tcp.pdl because the ACK didn’t return in time and causing pending messages with tcp_acknak.pdl.

Also, I find that thread using tcl to insert messages to database, can be rather unstable. Sometime, thread can be not responsive to shut down or start up command and some how later it’s back to normal again.

Appreciate for all your help.

Regards

Chak

[Chak Kwok Yin]

Hi Richard Hart

Yes, we’re using resend after 60 secs timeout at sender thread. Ok, will removed the resend tcl and test it out too.

Currently, we’re also find that one of the connection to database in the same process of the receiver thread would’ve cause this slowness due to database performance.

[Chak Kwok Yin]

Hi Richard Hart

Really appreciate your help. We’ve tested it on our testing environment for those internal connections and the ACK for each received message is pretty good; 98.92% of 5,000 messages falls within 1 sec latency.

However, we did encounter this issue where sender could not sent:

[pdl :PDL :ERR /0:     AOB_ADTP] Length encoding wrong?: read len of 100663296

09/27/2007 15:26:19

[pdl :PDL :ERR /0:     AOB_ADTP] DFA_BLOCK/internal:: could not decode length field (2.0)

09/27/2007 15:26:19

[pdl :PDL :ERR /0:     AOB_ADTP] no-match: no more phrases to try

(RESEND_OB_MSG/AOB_ADTP) No saved msg to resend.  Resending using new copy…

We suppect that the sender is sending blank reply so we’ve change the TCL to a better handle this. We’ll continue to monitor on this. By the way, are we on the right track to suspect this?

Regards,

Chak

[Chak Kwok Yin]

Hi

I would like very much to test out William Betera advise at some of the sites inbound threads. I tried to configure an inbound thread (server) to multi-server but received this error message upon startup.

04/04/2007 16:30:19 [tcp :init:ERR /0:   NSAP3_ADTP] Multi Server is not licensed, can not start thread.

Anyone face this restriction even though our company paid for each connections and its maintenance?

Regards

Chak

[Chak Kwok Yin]

Hi Robert

Those steps are applicable to MS window platform too. I’ll include these 2 commands for site cleanup in the future.

Cleanup memory region (hcimsiutil -R)

Cleanup site (hcisitecleanup)

Thank you!

Regards

Chak

[Chak Kwok Yin]

It is a very good appeal. Anyone can help? It is soooooo useful!

[Chak Kwok Yin]

hi, James,

Can I alert with the current queue depth? and dynamic include the problem thread list?

[Author]

Replies