Page size

Adaptive Server Enterprise 12.5 supports logical page sizes of 2K, 4K, 8K, and 16K. Open Client/Open Server uses the Bulk-Library (blklib) routines to populate these pages. Until the release of 12.5, blklib only supported the Adaptive Server page size of 2K.

The following table lists the new bulk library constants and their values.

Table 2-7: Page size values

blk_pagesize

blk_maxdatarow

blk_maxcolsize

blk_maxcolno

blk_boundary

2K

1962

1960

1962

1960

4K

4010

4008

4010

4008

8K

8106

8104

8106

8104

16K

16298

16296

16298

16298

Increased page size limits allow for increased number of columns, depending upon the type of table. The limits are:

No changes have been made to the existing blklib APIs, nor have any new APIs been added to accommodate the larger page size support in Adaptive Server 12.5.


Compatibility

Support for wide data and a larger number of columns is automatically enabled if:

If Open Client/Open Server 12.5 blklib is linked to a version 12.5 bcp application that communicates with a pre-12.5 Adaptive Server, the bcp utility assumes that Adaptive Server has the 2K page size.

If the blklib is linked to a bcp application that was built with a version of the utility earlier than 12.5 (the version string is not set to CS_VERSION_125), it cannot support the copy of large pages.