Thank you for all
Cordialement ________________________________________________ Marco Daturlot de Chavigny Générali France Assurances. Immeuble Wilo - W03B2088M 11-17 avenue Francois Mitterrand 93200 Saint Denis Tel: 01 58 38 59 69 [email protected] -----Message d'origine----- De : IBM Mainframe Discussion List [mailto:[email protected]] De la part de Chase, John Envoyé : vendredi 28 mai 2010 17:43 À : [email protected] Objet : Re: size max for a file DB2 > -----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 ---------------------------------------------------------------------- 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
