DB2 database restrictions, that is, database management page size restrictions. If you are interested in understanding the DB2 Management page size restrictions, you can use the following articles to learn more about it.
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
5. Select the maximum number of list elements
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
6. Maximum number of columns in a group by substatement
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
7. Maximum length (in bytes) of a group by substatement Column)
Size limit of 4 kb pages = 4005
Size Limit of 8 KB pages = 8101
Size limit of 16 KB pages = 16293
Size limit of 32 KB pages = 32677
8. Maximum number of orders BY substatement Columns
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
9. Maximum length of an order by substatement column (number of bytes)
The size limit of 4 kb Limit = 4005
Size Limit of 8 KB Tib = 8101
16 KB limit size = 16293
32 KB limit size = 32677
10. Maximum number of values in an INSERT into sentence
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
11. Maximum number of values in an UPDATE statement
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
12. The maximum size of a normally scheduled DMS tablespace (in gigabytes)
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
The above content is an introduction to the limitation on the DB2 Management page size. I hope you will have some gains.
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
