What are the restrictions on the size of the DB2 Management page?

Source: Internet
Author: User

This article focuses on some restrictions on the size of the DB2 Management page, which are used in real-world DB2 database applications. We generally encounter some errors because we do not know much about the limitations of the DB2 database. Here, I would like to summarize them to share them with you.

DB2 restrictions: Database Management page size restrictions

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

DB2 Management page size limit 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

DB2 Management page size limit 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

DB2 Management page size limit 12. maximum size of a common 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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.