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.
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:
1024 for fixed-length columns in both all-pages locking (APL) and data-only locking (DOL) tables
254 for variable-length columns in an APL table
1024 for variable-length columns in an DOL table
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.
Support for wide data and a larger number of columns is automatically enabled if:
The client is set to CS_VERSION_125 or higher,
It is linked with Open Client Server 125 library, and
The Adaptive Server to which it is connected has the capabilities to handle wide tables. To determine the version of Adaptive Server:
1> select @@version
2> go
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.