Table 23 describes certain Information Catalog Manager limits.
Table 23. The Information Catalog Manager limits
| Information Catalog Manager values | Limit |
|---|---|
| Longest information catalog database name | 30 characters |
| Longest information catalog physical table name (PT NAME) | 30 characters |
| Longest physical table name (PT NAME) with DB2 UDB for OS/2 | 18 characters |
| Longest physical table name (PT NAME) with DB2 UDB for OS/390 | 18 characters |
| Longest UUI property value length | 254 bytes |
| Maximum for total of five UUI property value lengths | 1270 bytes |
| Largest Information Catalog Manager object type icon | 30000 bytes |
| Most properties in an object type | 255 |
| Most properties with LONG VARCHAR data type in an Information Catalog Manager object type | 14 |
| Longest search criteria length for a LONG VARCHAR property | 3000 bytes |
| Maximum number of unique object types processed with ACTION.OBJTYPE() tags in a single tag language file | 3500 |
Maximum number of objects returned for the following API calls:
| 1600 |
Maximum number of objects returned for the following API calls:
| 5000 |