What are the limits on the DB2 Management page size? The following describes in detail the limits on the DB2 Management page size. If you are interested in the DB2 Management page size, take a look.
1. Maximum number of columns in a table
Size Limit = 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 = 4005I
Size Limit of 8 KB pages = 8101
Size limit of 16 KB pages = 16293
Size limit of 32 KB pages = 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 = 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. Maximum number of elements in a selection list
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 KB page = 1012
9. Maximum length of an order by substatement column (number of bytes)
Size Limit of KB page = 4005
Size Limit of 8 KB pages = 8101
Size limit of 16 KB pages = 16293
Limit of 2 kb page size = 3267
10. Maximum number of values in an INSERT 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
11. Maximum number of values in an UPDATE statement
Size limit of 4 kb pages = 500
Size Limit of 8 KB pages = 1012
6 kb page size limit = 1012
Limit of 2 kb page size = 1012
12. The maximum size of a regular 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 preceding section describes the limits on the DB2 Management page size.
DB2 database startup failure Solution
Several Simple DB2 operation statements
Read stability at the DB2 isolation level
Use of DB2 dynamic SQL
DB2 query Management Utility