Limits in IBM Informix Dynamic Server

Appendix F.
The following sections list selected capacity limits and system defaults for IBM
Informix Dynamic Server.
Limitations on UNIX Operating Systems
System-Level Parameter Limits (UNIX)
System-Level Parameters Maximum Capacity per Computer System
IBM Informix Dynamic Server systems per
computer (Dependent on available system
resources)
255
Maximum number of accessible remote sites Machine specific
Maximum virtual shared memory segment
(SHMVIRTSIZE)
2GB (32-bit platforms) or 4TB (64-bit
platforms)
Maximum address space 1.7GB if boot.ini file not modified to 3GB
2.7GB if boot.ini file is modified to 3GB
Table-Level Parameter Limits (UNIX)
Table-Level Parameters (based on 2K page
size) Maximum Capacity per Table
Data rows per fragment 4,277,659,295
Data pages per fragment 16,775,134
Data bytes per fragment (excludes Smart
Large Objects (BLOB, CLOB) and Simple
Large Objects (BYTE, TEXT) created in
Blobspaces)
33,818,671,136
Binary Large Object BLOB/CLOB pages 4*2*40
Binary Large Objects TEXT/BYTE bytes 4*2*40
Row length 32,767
Number of columns 32K
Key parts per index 16
Columns per functional index 102 (for C UDRs) 341 (for SPL or Java
UDRs)
Maximum bytes per index key (for a given
page size):
2K page size = 387
4K page size = 796
8K page size = 1615
12K page size = 2435
16K page size = 3254
Maximum size of an SQL statement 64K

Access Capabilities (UNIX)
Access Capabilities
Maximum Capacity per
System
Maximum databases per Dynamic Server system 21 million
Maximum tables per Dynamic Server system 477,102,080
Maximum active users per Dynamic Server (minus the
minimum number of system threads)
32K user threads
Maximum active users per database and table (also limited
by the number of available locks, a tunable parameter)
32K user threads
Maximum number of open tables per Dynamic Server
system
Dynamic allocation
Maximum number of open tables per user and join Dynamic allocation
Maximum locks per Dynamic Server system and database Dynamic allocation
Maximum number of page cleaners 128
Maximum number of partitions per dbspace 4K page size: 1048445, 2K
page size: 1048314 (based on
4-bit bitmaps)
Maximum number of recursive synonym mappings 16
Maximum number of tables locked with LOCK TABLE per
user
32
Maximum number of cursors per user Machine specific
Maximum Enterprise Replication transaction size 4 TB
Maximum dbspace size 4 TB with 2K page size8 TB
with 4K page size
Maximum sbspace size 4 TB with 2K page size8 TB
with 4K page size
Maximum chunk size 4 TB
Maximum number of chunks 32,766
Maximum number of 2K pages per chunk 2 billion
Maximum number of open Simple Large Objects (applies
only to TEXT and BYTE data types)
20
Maximum number of B-tree levels 20
Maximum amount of decision support memory Machine specific
Maximum size of a Dynamic Server instance 8 PB
Utility support for large files 17 billion GB
Maximum number of storage spaces (dbspaces, blobspaces,
sbspaces, or extspaces)
2047
IBM Informix Dynamic Server System Defaults (UNIX)
Table lock mode Page
Initial extent size 8 pages
Next extent size 8 pages
Read-only isolation level (with database
transactions)
Committed Read
F-2 IBM Informix Dynamic Server Administrator’s Reference
Read-only isolation level (ANSI-compliant
database)