DB2 limit
1. The maximum number of numbers of a table <= 1012
2. Maximum number of numbers of a view <= 5000
3. The maximum length of a row (bytes) <= 32677
4. Maximum size of the table in each partition (Gigabit Number) <= 512
5. The maximum size (Gigabit Number of Gigabit Number) in each partition <= 512
6. The maximum number of lines in each partition <= 4000000000
7. The longest index keyword (number of bytes) <= 1024
8. A maximum number of columns in an index key <= 16
9. Maximum number of indexes of a table <= 32767 or memory
10. A maximum number of pies referenced in a SQL statement or view <= memory
11. The maximum host variable in a pre-compiled program declares the number <= memory
12. The maximum number of host variables referenced in a SQL statement <= 32767
13. Maximum number of host variables used to insert or update (bytes) <= 32767
14. The longest SQL statement (number of bytes) <= 65535
15. A number of elements in the list <= 1012
16. A number of predicates in a WHERE or HAVING clause <= memory
17. A largest column in a Group By sentence <= 1012
18. A maximum total length of all columns in a Group By clause (number of bytes) <= 32677
19. A maximum of the most columns in the clause of the clause of the order.
20. Maximum total length of all columns in an Order By clause (number of bytes) <= 32677
21. Maximum size of SQLDA (number of bytes) <= memory
22. Maximum number of preparatory statements <= memory
23. A number of programs can be declared in the number of cursors <= memory
24. The maximum number of cursors that open once <= memory
25. A maximum number of points in SMS tables <= 65534
26. Maximum constraint in a table <= memory
27. The highest level of subquery = memory
28. Maximum number query in a single query = memory
29. Number of most values in an insert statement <= 1012
30. The maximum number of set subscriptures in a single UPDATE statement <= 1012
31. Maximum number of columns in a unique constraint (number of bytes) <= 1024
32. Maximum number of columns quoted in the foreign key <= 16
33. The maximum number of total total lengths (bytes) referenced in a foreign key (number of bytes) <= 1024
34. A maximum number of total total lengths for checking constraints (number of bytes) <= 65535
35. The maximum number of columns in a partition key <= 500
36. Maximum number of rows that can be changed in a work unit = memory
37. Maximum number of packages = memory
38. Maximum constraint number of statements = memory
39. A server at the same time there is a maximum number of users = 64000
40. A maximum number of stored procedure parameters = 32767
41. Maximum number in a user-defined function = 32767
42. The maximum operating depth of the cascader is = 16
43. The maximum number of event monitors at the same time = 90
44. Maximum size of a conventional DMS table space (Gigabit Number) <= 512
45. Maximum size of a long DMS table space (Gigabit Number) <= 2
46. Maximum size of a temporary DMS table space (Gigabit Number) <= 2
47. The maximum number of databases can be used in both an example <= 256
48. The maximum number of users can use simultaneously in an example <= 64000
49. The maximum number of numbers exists at the same time <= 1000
50. Maximum partition <= 999
51. Number of largest table objects in a DMS table space <= 51000
52. The longest variable index key (number of bytes) <= 255
53. The maximum number of columns of data source tables or views, the number of pages in a buffer pool (32BIT) <= 524288
55. Maximum number of pages in a buffer pool (64bit) <= 2147483647
56. A number of tablespaces in a database is <= 4096
57. The maximum number of properties in a structural type <= 4082
1. The maximum number of columns in a table
4kb page size limit = 500
8kb page size limit = 1012
16kb page size limit = 1012
32KB size limit = 1012
2. The maximum length of a row
4KB page size limit = 4005
8KB page size limit = 8101
16kb page size limit = 16293
32KB page size limit = 32677
3. Maximum size of each partition of a table (Gigabit)
4KB page size limit = 64
8kb page size limit = 128
16kb page size limit = 256
32KB page size limit = 512
4. Maximum size of each partition of an index (Gigabit)
4KB page size limit = 64
8kb page size limit = 128
16kb page size limit = 256
32KB page size limit = 512
5. A maximum number of choices of list elements
4kb page size limit = 500
8kb page size limit = 1012
16kb page size limit = 1012
32KB size limit = 1012
6. A maximum number of Group By Subviews
4kb page size limit = 500
8kb page size limit = 1012
16kb page size limit = 1012
32KB size limit = 1012
7. Maximum length of a Group By Subgramination List (Number of bytes)
4KB page size limit = 4005
8KB page size limit = 8101
16kb page size limit = 16293
32KB page size limit = 32677
8. Maximum number of one order BY
4kb page size limit = 500
8kb page size limit = 1012
16kb page size limit = 1012
32KB size limit = 1012
9. Maximum length of a Order By Subview List (Number of bytes)
4KB page size limit = 4005
8KB page size limit = 8101
16kb page size limit = 16293
32KB page size limit = 32677
10. Maximum number of values in an insert statement
4kb page size limit = 500
8kb page size limit = 1012
16kb page size limit = 1012
32KB size limit = 1012
11. Maximum number of values in an UPDATE statement
4kb page size limit = 500
8kb page size limit = 1012
16kb page size limit = 1012
32KB size limit = 1012
12. Maximum size of a regular DMS table space (Gigabit Number)
4KB page size limit = 64
8kb page size limit = 128
16kb page size limit = 256
32KB page size limit = 512
1. Minimum DATE value = 0001-01-01
2. Maximum DATE value = 9999-12-31
3. Minimum Time value = 00:00:00
4. Maximum Time value = 24:00:00
5. Minimum TimeStamp value = 0001-01-01-00: 00: 00: 000000
6. The biggest timestamp value = 9999-12-31-24: 00: 000000
Char's maximum length (number of bytes) <= 254
2. VARCHAR's maximum length (number of bytes) <= 32672
3. Long varchar's maximum length (number of bytes) <= 327004. Clob's maximum length (byte) <= 2147483647
5. Graphicchar's maximum length (number of bytes) <= 127
6. VARGRAPHIC maximum length (number of bytes) <= 16336
7. Long Vargraph's maximum length (number of bytes) <= 16350
8. The maximum length of dbclob (number of bytes) <= 1073741823
9. Maximum length of BLOB (number of bytes) <= 2147483647
10. Maximum length of character constants (number of bytes) <= 32672
11. Maximum length of graphical constants (number of bytes) <= 16336
12. Maximum length of series strings (number of bytes) <= 2147483647
13. Maximum length of series chart string (number of bytes) <= 1073741823
14. Maximum length of series two into strings (number of bytes) <= 2147483647
15. The maximum length of the hexadecimal constant number (number of bytes) <= 16336
16. The maximum length of classification annotation (number of bytes) <= 254
17. The maximum length of the running structure type column object (number of bytes) <= 1
1. Minimal Integer> = -2147483648
2. The biggest integer value <= 2147483648
3. Minimum Bigint value> = -9223372036854775808
4. The biggest Bigint value <= 9223372036854775808
5. Minimum smallint value> = -32768
6. The biggest smallint value <= 32768
7. Minimum decimal accuracy <= 31
8. Minimum Double Value> = -1.79769E 308
9. The biggest double value <= 1.79769e 308
10. Minimum Double Double Value> = 2.225E-307
11. The maximum negative double value <= -2.225e-307
12. Minimum real value> = -3.402e 38
13. The biggest real value <= 3.402E 38
14. Minimum positive real value> = 1.175E-37
15. The maximum negative REAL value <= -1.175e-37
