[转]常见的INFORMIX限制. Limits in IBM Informix Dynamic Server

liaosnet

Limits in IBM Informix Dynamic Server

Release Notes for IBM Informix Dynamic Server for UNIX and Linux[tr]System-Level ParametersMaximum 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)

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

Access CapabilitiesMaximum 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 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 chunk size	4 Terabytes
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

可以在
$INFORMIXDIR/release/en_us/0333/ids_unix_relnotes_xx.xx.txt 里查到相关信息..

[ 本帖最后由 liaosnet 于 2009-2-16 10:28 编辑 ]

xieweihua

我是DBA

收下了，非常感谢