> -----Original Message-----
> From: IBM Mainframe Discussion List On Behalf Of DATURLOT DE CHAVIGNY
Marc
>
> Hello
>
> What 's the maximum size for a file db2 in v8 please for a partitioned
tablespace ?
>From DB2 Limits - DB2 for z/OS SQL Reference
Maximum size of a partition (table space or index):
For table spaces that are not defined with LARGE or a DSSIZE greater
than 2 GB:
4 GB, for 1 to 16 partitions
2 GB, for 17 to 32 partitions
1 GB, for 33 to 64 partitions
For table spaces that are defined with LARGE:
4 GB, for 1 to 4096 partitions
For table spaces that are defined with a DSSIZE greater than 2 GB:
64 GB, depending on the page size (for 1 to 256
partitions for 4-KB pages, for 1 to 512
partitions for 8-KB pages, for 1 to 1024
partitions for 16-KB pages, and 1 to 2048
partitions for 32-KB pages)
2 GB is still the max simple or segmented data set size.
-jc-
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
