Extended-Limit Capabilities

SAP ASE extended-limit capabilities vary by type of table and the database logical page size.

Allpages-Locked (APL)Tables

Maximum APL table limits

Number of columns

Column size 2K page

Column size 4K page

Column size 8K page

Column size 16K page

Fixed-length column

1024

1960 bytes

4008 bytes

8104 bytes

16296 bytes

Variable-length column

254

1948 bytes

3988 bytes

8068 bytes

16228 bytes

Data Row and Data Page Tables for Data-Only-Locked (DOL) Tables

Maximum DOL table limits

Number of columns

Column size 2K page

Column size 4K page

Column size 8K page

Column size 16K page

Fixed-length column

1024

1958 bytes

4006 bytes

8102 bytes

16294 bytes

Variable-length column

1024

1954 bytes

4002 bytes

8098 bytes

16290 bytes

Database Requirements for Varying Page Sizes

Database space requirements depend on the logical page size of the server. If your model database is larger than the minimum size listed below, then the minimum size of the database is equal to the model database.

Databases

2K page

4K page

8K page

16K page

Default database size

3MB

6MB

12MB

24MB

master database

13MB

26MB

52MB

104MB

model database

3MB

6MB

12MB

24MB

tempdb database

4MB

6MB

12MB

24MB

sybpcidb database

24MB

48MB

96MB

192MB

Data Limits for Tables According to Page Size

Larger logical page sizes can contain more data.

Tables

2K page

4K page

8K page

16K page

Bytes per index key

600

1250

2600

5300

User-visible row length DOL table

1958

4006

8102

16294

User-visible row length APL table

1960

4008

8104

16296