Re: DBD::Sybase misleads me?

This topic really has nothing to do with DBD::Sybase.
Truth be known, DBD::Sybase would never mislead
anyone.

Sybase ASE configuration parameter "max network packet
size" is a static parameter; the dataserver needs to
be restarted for it to take effect. The same applies
to "default network packet size".

Related to "max network packet size" is the
configuration parameter "additional network memory",
which controls the total amount of memory available to
connections using a larger than default packet size.
Sybase ASE configuration parameters "addition network
memory" and "number of user connections" are dynamic
parameters and so do not require ASE restart.

If you want a 16k packet size, set "max netowrk packet
size" correctly, allocate suffcient "additional
network memory" as well as "number of user
connections" and cycle your server.

regards,

David

--- michael.peppler@xxxxxxxxxxxxxx wrote:

The sp_configure option is dynamic, but only affects
future connections. It
is an upper limit, and the client has to
specifically request the larger
packet size to get it. Otherwise the default 512
byte packet size is used.

Michael




Extranet
alexander@xxxxxxxx - 23/06/2006 14:48

To: matthew.persico

cc: dbi-users


Subject: Re: DBD::Sybase misleads me?


What does "sp_configure max network packet size"
affect? The current
connection or the entire server?

If it's the connection, it simply can't work: The
commercial app is
forked, and has no relation to DBI's connection, so
it creates and uses
its own connection (though it seems to fail to set
the desired size by
itself).

It it's the entire server, does the client library
assume a certain size
or does it asks the server for the current max.
packet size?


(And why would you want to change that setting?)

Alexander

On 23.06.2006 14:36, Matthew Persico wrote:

I have a commercial program that accesses a Sybase
12.5 server. It has
an option to change the packet size of the
communucation frame with
the server, but you have to know what size you
want.

Sooo, in my perl program, I connect to the
database with DBD::Sybase,
execute a
sp_configure 'max network packet size' and then I
system() the
commercial program with the argument
-zpkt=whatever I got back.

Occasionally, the program responds with

DB-Lib ERROR: 20201: Packet size of 16384 not
supported -- size of
13824 used instead. severity is 1

The program then dies, but that is their problem -
it should
disconnect and reconnect properly and I will
register te bug with them

My question is this what causes this? One minute
16384 is ok and the
next its not. DBD::Sybase is CT-LIb based and
their program is DB-Lib
based. Is that a problem?
--
Matthew O. Persico



--
Alexander Foken
mailto:alexander@xxxxxxxx
http://www.foken.de/alexander/




This message and any attachments (the "message") is
intended solely for the addressees and is
confidential.
If you receive this message in error, please delete
it and
immediately notify the sender. Any use not in accord
with
its purpose, any dissemination or disclosure, either
whole
or partial, is prohibited except formal approval.
The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.


---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le

"message") sont etablis a l'intention exclusive de
ses
destinataires et sont confidentiels. Si vous recevez
ce
message par erreur, merci de le detruire et d'en
avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute
diffusion
ou toute publication, totale ou partielle, est
interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et
ses
filiales) decline(nt) toute responsabilite au titre
de ce
message, dans l'hypothese ou il aurait ete modifie.



.

Relevant Pages

  • Re: blob and network packet size
    ... In general the network packet size setting should be left alone, ... Please do not send email directly to this alias. ... > 1) For performance of BLOB only data that will have at least 100 KB per ...
    (microsoft.public.sqlserver.connect)
  • Re: bcp out fails with CTLIB Message: - L5/O1/S5/N18/5/0 when using -A
    ... Were there any errors reported in the ASE error log? ... where client applications would get the error you reported ... 'kbfalloc' may be reported in the error log when using network packet ...
    (comp.databases.sybase)
  • Re: blob and network packet size
    ... If your database application sends or receives large amounts of BLOB data, ... To change or set the packet ... use the network packet size option in Configuration Options. ... performance in SQL Server 2000 and SQL Server 7.0. ...
    (microsoft.public.sqlserver.connect)
  • Re: network packet size
    ... Enterprise Manger -> On the "tools" menu ... > Tibor Karaszi, SQL Server MVP ... >> I was wondering is the following is correct with the network packet size. ...
    (microsoft.public.sqlserver.server)
  • Re: weird scans from port 80
    ... > with a RST packet. ... > server which has clients with dynamic IP address. ... > How many open connections of this kind can the server ...
    (comp.os.linux.security)