Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: blk_init and image columns
Date: Sep 4 2002 3:05PM

[I'm traveling - currently in England - so email access is spotty... ]

CS_PACKETSIZE must be set in a power of 2, starting at 512 (so 512,
1024, 2048, etc). I think there's a max, and of course the server has to
be configured to handle larger packet sizes (at least up to 12.0 - 12.5
*may* handle this dynamically).

However, I'm pretty sure that the packet size has nothing to do with the
SEGV that you are seeing. I suspect instead that it may be linked with
the TEXTSIZE value. You can set this via SET TEXTSIZE xxxx or via a
ct_option() call.


On Fri, 2002-08-30 at 13:39, wrote:
> sorry. last email for the weekend.  I set CS_PACKETSIZE => 9000 via
> CON_PROPS and I still SEGV'ed on the blk_init.
> Time to set this thing down and grab a beer.
> Cheers,
> Steve
> On Fri, 30 Aug 2002 @ 4:23pm, an entity claiming to be Stephen.Sprague@morg...:
> Stephe :Ahhh. Digging further I'm pretty sure this can be solved  by  increasing
> Stephe :the CS_PACKETSIZE connection property. Now if only I had sa priv to bump
> Stephe :the max size up from 512 on the server...
> Stephe :
> Stephe :Thanks,
> Stephe :Steve
> Stephe :
> Stephe :cf,6904,954,00.html
> Stephe :
> Stephe :On most platforms, the packet size defaults to 512 bytes.  This  default
> Stephe :is provided for backward compatibility. Larger packet sizes 2048 to 4096
> Stephe :bytes, for example almost  always  yield  better  performance.  This  is
> Stephe :generally true for applications that fetch rows with large columns, rows
> Stephe :with lots of columns, or lots of rows with a few small  columns.  It  is
> Stephe :especially true for applications that do bulk  copy  data  transfers  or
> Stephe :that handle text and image data.
> Stephe :
> Stephe :To increase a connection's packet size, set the CS_PACKETSIZE connection
> Stephe :property, via ct_con_props, prior to opening the connection.
> Stephe :
> Stephe :--------------------------------------------------------------------------------
> Stephe :Note
> Stephe :You may have to reconfigure  SQL  Server  to  accept  a  larger  maximum
> Stephe :network packet size. See the SQL Server System Administration Guide  for
> Stephe :instructions on reconfiguring the maximum network packet size.
> Stephe :
> Stephe :
> Stephe :On Fri, 30 Aug 2002 @ 3:34pm, an entity claiming to be Stephen.Sprague@morg...:
> Stephe :
> Stephe :Stephe :hi folks. I'm using Michael's BLK routines to do bulk inserts. Should  I
> Stephe :Stephe :be able to use blk_init on a table with an image column?
> Stephe :Stephe :
> Stephe :Stephe :Currently I'm getting a Signal SEGV.
> Stephe :Stephe :
> Stephe :Stephe :Here's the versions:
> Stephe :Stephe :   Perl          v5.6
> Stephe :Stephe :   Sybase::CTlib v2.14
> Stephe :Stephe :   OpenClient    v12.0
> Stephe :Stephe :
> Stephe :Stephe :I couldn't find any doc to the contrary and I see Sybase's command  line
> Stephe :Stephe :bcp references switch -T [image size] so I think it's possible. The question
> Stephe :Stephe :is does the Perl API support something analogous?
> Stephe :Stephe :
> Stephe :Stephe :Any pointers welcome.
> Stephe :Stephe :
> Stephe :Stephe :Thanks,
> Stephe :Stephe :Steve
> Stephe :Stephe :
> Stephe :Stephe :
> Stephe :
> Stephe :
Michael Peppler / / / ZetaTools, Inc /
ZetaTools: Call perl functions as Sybase stored procedures!