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.

Recordsize?

3 posts in Internet Server Last posting was on 2006-07-28 08:16:01.0Z
Jim Gabriel Posted on 2006-07-27 17:08:48.0Z
From: "Jim Gabriel" <btreecs@earthlink.net>
Newsgroups: Advantage.Internet_Server
Subject: Recordsize?
Date: Thu, 27 Jul 2006 10:08:48 -0700
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 71.104.241.226
Message-ID: <44c8f258@solutions.advantagedatabase.com>
X-Trace: 27 Jul 2006 11:05:28 -0700, 71.104.241.226
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!71.104.241.226
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:656
Article PK: 1120918

I've been testing an app under XP and everything is running smoothly. All
tables are accessible without a problem.

However, on 1 win2k machine, one of the tables hangs the application (same
exe acessing the exact same tables as the XP machine over the internet). It
works fine on OTHER win2k machines. From the win2k machine, I can't even
run a SQL statement against that one table without it locking up the
application.

Now, the tables that I have no problem with are fairly small in size and
only a couple hundred records. The table I'm having problems with is 2370
bytes in length and about 600 records. Some fields are memo fields and I
haven't made any configuration default changes.

Any ideas how to trace down the actual problem with this win2k machine?

Thanks
Jim


Joachim Duerr (ADS Support) Posted on 2006-07-28 08:16:01.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Recordsize?
Newsgroups: Advantage.Internet_Server
References: <44c8f258@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <44c9b9b1@solutions.advantagedatabase.com>
Date: 28 Jul 2006 01:16:01 -0700
X-Trace: 28 Jul 2006 01:16:01 -0700, 195.2.185.25
Lines: 32
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:659
Article PK: 1120920


Jim Gabriel wrote in <44c8f258@solutions.advantagedatabase.com>:

> I've been testing an app under XP and everything is running smoothly.
> All tables are accessible without a problem.
>
> However, on 1 win2k machine, one of the tables hangs the application
> (same exe acessing the exact same tables as the XP machine over the
> internet). It works fine on OTHER win2k machines. From the win2k
> machine, I can't even run a SQL statement against that one table
> without it locking up the application.
>
> Now, the tables that I have no problem with are fairly small in size
> and only a couple hundred records. The table I'm having problems
> with is 2370 bytes in length and about 600 records. Some fields are
> memo fields and I haven't made any configuration default changes.
>
> Any ideas how to trace down the actual problem with this win2k
> machine?

we've seen some network issues where large packets where divided into
multiple packets and then sent one-by-one to the target machine. The
packets where received in a wrong order and so it took multiple cycles
to get all the packets. Limiting the packet size in ads.ini (search
help file for packet_size) to 512 solved the issues. You might need to
play around with different values (start with 200, then 200, 400, 500,
...) until you reach the critical limit.

--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de


Alex Wong (ADS) Posted on 2006-07-27 17:31:32.0Z
From: "Alex Wong \(ADS\)" <alexw@sybase.com>
Newsgroups: Advantage.Internet_Server
References: <44c8f258@solutions.advantagedatabase.com>
Subject: Re: Recordsize?
Date: Thu, 27 Jul 2006 11:31:32 -0600
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 10.24.38.166
Message-ID: <44c8f5b2@solutions.advantagedatabase.com>
X-Trace: 27 Jul 2006 11:19:46 -0700, 10.24.38.166
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.166
Xref: solutions.advantagedatabase.com Advantage.Internet_Server:658
Article PK: 1120921

Are the working machines using the exact same configuration with respect to
the connection type, Remote, internet, or local, as the troubled machine? If
they are, then I would look for environment issue. Is the troubled machine
connect to the network the same way? Sniff the network to see if there is
communication between the client and the server while the application looks
locked up. It could be that the communication between the client and the
server is slow for some reason.

Alex

"Jim Gabriel" <btreecs@earthlink.net> wrote in message
news:44c8f258@solutions.advantagedatabase.com...
> I've been testing an app under XP and everything is running smoothly. All
> tables are accessible without a problem.
>
> However, on 1 win2k machine, one of the tables hangs the application (same
> exe acessing the exact same tables as the XP machine over the internet).
> It works fine on OTHER win2k machines. From the win2k machine, I can't
> even run a SQL statement against that one table without it locking up the
> application.
>
> Now, the tables that I have no problem with are fairly small in size and
> only a couple hundred records. The table I'm having problems with is 2370
> bytes in length and about 600 records. Some fields are memo fields and I
> haven't made any configuration default changes.
>
> Any ideas how to trace down the actual problem with this win2k machine?
>
> Thanks
> Jim
>