Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Performance problem on Sybase connection

3 posts in General Discussion Last posting was on 2009-10-12 15:40:42.0Z
shida Posted on 2009-10-10 07:51:58.0Z
Sender: 504f.4ad03ae3.1804289383@sybase.com
From: ShiDa
Newsgroups: sybase.public.ase.general
Subject: Performance problem on Sybase connection
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ad03d1e.506c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Oct 2009 00:51:58 -0700
X-Trace: forums-1-dub 1255161118 10.22.241.41 (10 Oct 2009 00:51:58 -0700)
X-Original-Trace: 10 Oct 2009 00:51:58 -0700, 10.22.241.41
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28446
Article PK: 77689

Hi Experts,

I am using federation server which is used to establish
connection to sybase server via ctlib client. I met such
error when enlarge the connection number to more than 450:

---------------------------------------------------------
2009-10-10-10.30.36.703611-300 I155688645A479 LEVEL: Error
PID : 254164 TID : 115138 PROC : db2fmp (C)
INSTANCE: db2inst4 NODE : 000
EDUID : 115138 EDUNAME: db2fmp (C)
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string
(secondary logging fu, probe:0
MESSAGE : cs_ctx_alloc failed
DATA #1 : String, 112 bytes

The context allocation routine failed.

The following problem caused the failure:

Creating a TSD/TLS failed.
--------------------------------------------
The statement I used to specify the connection value:
netio_type = MAX_CONNECT;
retcode = ct_config(context, CS_SET, CS_MAX_CONNECT,
(CS_VOID *)&netio_type, CS_UNUSED, NULL);
--------------------------------------------
Who can tell me what's the possible cause of this error?
What would impact the creation of TSD/TLS? Thanks!

Btw, I write a separate program using ctlibrary language to
test multiple thread connection, seems when the connection
number is smaller than 800 on the testing machine, then it
would work successfully. If I set connection to 1000, it
would report below error:
*****************************************************
Thread_842:Open Client Message:
Thread_842:Message number: LAYER = (5) ORIGIN = (3) SEVERITY
= (5) NUMBER = (6)
Thread_842:Message String: ct_connect(): network packet
layer: internal net library error: Net-Library operation
terminated due to disconnect
Thread_842:ERROR: ct_connect failed
*********************************************************
Who knows this error and how to get the reason out?

Thank you very much!
ShiDa


Michael Peppler [Team Sybase] Posted on 2009-10-11 14:43:07.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: Performance problem on Sybase connection
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2009.10.11.14.43.02.236479@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4ad03d1e.506c.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 11 Oct 2009 07:43:07 -0700
X-Trace: forums-1-dub 1255272187 10.22.241.152 (11 Oct 2009 07:43:07 -0700)
X-Original-Trace: 11 Oct 2009 07:43:07 -0700, vip152.sybase.com
Lines: 61
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28447
Article PK: 77688

Hi,

There is a limit to the number of connections a dataserver can handle.
This limit is configurable (see sp_configure 'number of user connections').

The error message might be due to you hitting this limit.

Michael

On Sat, 10 Oct 2009 00:51:58 -0700, ShiDa wrote:

> Hi Experts,
>
> I am using federation server which is used to establish
> connection to sybase server via ctlib client. I met such
> error when enlarge the connection number to more than 450:
>
> ---------------------------------------------------------
> 2009-10-10-10.30.36.703611-300 I155688645A479 LEVEL: Error
> PID : 254164 TID : 115138 PROC : db2fmp (C)
> INSTANCE: db2inst4 NODE : 000
> EDUID : 115138 EDUNAME: db2fmp (C)
> FUNCTION: DB2 UDB, trace services, sqlt_logerr_string
> (secondary logging fu, probe:0
> MESSAGE : cs_ctx_alloc failed
> DATA #1 : String, 112 bytes
>
> The context allocation routine failed.
>
> The following problem caused the failure:
>
> Creating a TSD/TLS failed.
> --------------------------------------------
> The statement I used to specify the connection value:
> netio_type = MAX_CONNECT;
> retcode = ct_config(context, CS_SET, CS_MAX_CONNECT,
> (CS_VOID *)&netio_type, CS_UNUSED, NULL);
> --------------------------------------------
> Who can tell me what's the possible cause of this error?
> What would impact the creation of TSD/TLS? Thanks!
>
> Btw, I write a separate program using ctlibrary language to
> test multiple thread connection, seems when the connection
> number is smaller than 800 on the testing machine, then it
> would work successfully. If I set connection to 1000, it
> would report below error:
> *****************************************************
> Thread_842:Open Client Message:
> Thread_842:Message number: LAYER = (5) ORIGIN = (3) SEVERITY
> = (5) NUMBER = (6)
> Thread_842:Message String: ct_connect(): network packet
> layer: internal net library error: Net-Library operation
> terminated due to disconnect
> Thread_842:ERROR: ct_connect failed
> *********************************************************
> Who knows this error and how to get the reason out?
>
> Thank you very much!
> ShiDa


J Posted on 2009-10-12 15:40:42.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Performance problem on Sybase connection
Reply-To: J@bogusemailAddress.com
Message-ID: <4ad34cd3.1760601@forums.sybase.com>
References: <4ad03d1e.506c.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 12 Oct 2009 08:40:42 -0700
X-Trace: forums-1-dub 1255362042 10.22.241.152 (12 Oct 2009 08:40:42 -0700)
X-Original-Trace: 12 Oct 2009 08:40:42 -0700, vip152.sybase.com
Lines: 58
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28449
Article PK: 77691

On 10 Oct 2009 00:51:58 -0700, ShiDa wrote:\

Um. What's a TDS/TLS? Are you acquiring a cs_context for each
connection? How about threads and handles? I think you should run
your ctlib program at some level like 400 and then compare the
resources that are used with the other application at the same level.
Look at thread, handles, memory etc.

Jay

>Hi Experts,
>
>I am using federation server which is used to establish
>connection to sybase server via ctlib client. I met such
>error when enlarge the connection number to more than 450:
>
>---------------------------------------------------------
>2009-10-10-10.30.36.703611-300 I155688645A479 LEVEL: Error
>PID : 254164 TID : 115138 PROC : db2fmp (C)
>INSTANCE: db2inst4 NODE : 000
>EDUID : 115138 EDUNAME: db2fmp (C)
>FUNCTION: DB2 UDB, trace services, sqlt_logerr_string
>(secondary logging fu, probe:0
>MESSAGE : cs_ctx_alloc failed
>DATA #1 : String, 112 bytes
>
>The context allocation routine failed.
>
>The following problem caused the failure:
>
>Creating a TSD/TLS failed.
>--------------------------------------------
>The statement I used to specify the connection value:
>netio_type = MAX_CONNECT;
>retcode = ct_config(context, CS_SET, CS_MAX_CONNECT,
>(CS_VOID *)&netio_type, CS_UNUSED, NULL);
>--------------------------------------------
>Who can tell me what's the possible cause of this error?
>What would impact the creation of TSD/TLS? Thanks!
>
>Btw, I write a separate program using ctlibrary language to
>test multiple thread connection, seems when the connection
>number is smaller than 800 on the testing machine, then it
>would work successfully. If I set connection to 1000, it
>would report below error:
>*****************************************************
>Thread_842:Open Client Message:
>Thread_842:Message number: LAYER = (5) ORIGIN = (3) SEVERITY
>= (5) NUMBER = (6)
>Thread_842:Message String: ct_connect(): network packet
>layer: internal net library error: Net-Library operation
>terminated due to disconnect
>Thread_842:ERROR: ct_connect failed
>*********************************************************
>Who knows this error and how to get the reason out?
>
>Thank you very much!
>ShiDa