Sybase 15.x recommended default page size

[TobiMc3]

Is there an industry standard recommended page size for new 15.x
installations? My client is using 2K page size, and is having problems
with applications that access the database as follows:

Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Attempt to update or
insert row failed because resultant row of size 2493 bytes is larger
than the maximum size (1964 bytes) allowed for this table.

Thanks!

Tobi

[b***@msn.com]

Post by TobiMc3
Is there an industry standard recommended page size for new 15.x
installations? My client is using 2K page size, and is having problems
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Attempt to update or
insert row failed because resultant row of size 2493 bytes is larger
than the maximum size (1964 bytes) allowed for this table.
Thanks!
Tobi

The default value was raised to 4K some time back.

You do need to set the page size large enough to handle the largest
row
length your applications will require. This will be somewhat less
than the page size as there is some overhead used for the page
header of each page, and INSERT log records need to be able
to store the whole row plus some additional overhead for the row.
The "dbcc serverlimits" command gives the exact values for
various page sizes, lock schemes, etc.