最近在400组交流中,有朋友有提到*NOMAX members of a PF的值是多少?
按照他说的实际值是3000多,但是没有确定这个*NOMAX实际上应该多少?
偶针对这个提问查询了资料,有本IBM Redbook,
iSeries
DB2 Universal Database for iSeries Database
Programming
Version 5
有这方面的技术指标:
Description Maximum Value
Number of bytes in a record 32,766 bytes
Number of fields in a record format 8,000 fields
Number of key fields in a file 120 fields
Size of key for physical and logical files 2000 characters1
Size of key for ORDER BY (SQL) and KEYFLD (OPNQRYF) 10,000 bytes
Number of records contained in a file member 4,294,967,294 records2
Number of bytes in a file member 266,757,734,400 bytes3
Number of bytes in an access path 1,099,511,627,776 bytes3 5
Number of keyed logical files built over a physical file member 3,686 files
Number of physical file members in a logical file member 32 members
Number of members that can be joined 32 members
Size of a character or DBCS field 32,766 bytes4
Size of a zoned decimal or packed decimal field 31 digits
Maximum number of constraints per physical file 300 constraints
Maximum number of triggers per physical file 6 triggers
Maximum number of recursive insert and update trigger 200 calls
The value *NOMAX has the same effect as specifying 32767. If the value is
*NOMAX, the Retrieve System Value (RTVSYSVAL) command retrieves
32767 even though the value is displayed as *NOMAX through the Work
with System Value (WRKSYSVAL) and the Display System Value
(DSPSYSVAL) commands.
Record format sharing limitation with physical and logical database files
A record format can only be shared by 32K objects. Error messages are issued when you reach the limitation. You may encounter this limitation in a circumstance where you are duplicating the same database object multiple times.
Note: Format sharing is performed for files that are duplicated. The format is shared up to 32,767 times. Beyond that, if a file that shares the format is duplicated, a new format will be created for the duplicated file.
根据上述技术指标,*NOMAX members of a PF,应该是:
Number of keyed logical files built over a physical file member 32,767
阅读(1208) | 评论(1) | 转发(0) |