Limits on the size of Management pages in DB2

In actual DB2 applications, you may often encounter some errors, which are caused by a lack of understanding of DB2 restrictions. Here I would like to briefly summarize, to share with you.

Limits in DB2: Limits on the data volume Management page size

In actual DB2 applications, you may often encounter some errors because of

This restriction is caused by a lack of understanding. Here I will summarize it to share it with you ﹐

The following uses DB2 7.x as an example:

1. Maximum number of columns in a table

Size limit of 4 kb pages = 500

Size Limit of 8 KB pages = 1012

Size limit of 16 KB pages = 1012

Size limit of 32 KB pages = 1012

2. Maximum length of a row

Size limit of 4 kb pages = 4005

Size Limit of 8 KB pages = 8101

Size limit of 16 KB pages = 16293

32 KB limit page size = 32677

3. maximum size of each partition in a table (GB)

Size limit of 4 kb page = 64

Size Limit of 8 KB pages = 128

Size limit of 16 KB pages = 256

Size limit of 32 KB pages = 512

4. maximum size of each partition of an index (GB)

Size limit of 4 kb page = 64

Size Limit of 8 KB pages = 128

Size limit of 16 KB pages = 256

Size limit of 32 KB pages = 512