Db2 for z/OS & Db2ZAI

 View Only

  • 1.  Maximum Partition Size of a Partitioned (non-UTS) tablespace defined with DSSIZE 2G LARGE keyword

    Posted Mon September 02, 2024 01:45 AM

    Hi,

    We have a partitioned (non-UTS) tablespace defined with DSSIZE 2GB & LARGE keyword with 64 partitions in our Db2 for z/OS subsystem. The partitions of this tablespace are about 90% full and are growing every day. Will Db2 allocate & use a second dataset for each partition once the first dataset of the partition becomes full? We are planning to convert this tablespace to UTS, but, it has to wait a few months per prioritization. 

    I appreciate your responses in this regard.

    Best,

    Srini Atmakur

    atmakur@us.ibm.com



    ------------------------------
    Srini Atmakur
    ------------------------------


  • 2.  RE: Maximum Partition Size of a Partitioned (non-UTS) tablespace defined with DSSIZE 2G LARGE keyword

    Posted Mon September 02, 2024 09:30 PM

    Have a look at Limits in DB2 for z/OS



    ------------------------------
    Bruce Williamson
    ------------------------------

    Original Message


  • 3.  RE: Maximum Partition Size of a Partitioned (non-UTS) tablespace defined with DSSIZE 2G LARGE keyword

    Posted Tue September 03, 2024 02:19 AM

    Simple answer is - No

    Partitioned opbjects cannot get a second dataset as they are, by definition, single dataset partitions. Your best hope is to convert to PBR RPN and then you can very simply change the DSIZE of any part or part index with an ALTER. On-line, instantly with no rebind or reorg required!

    Cheers!



    ------------------------------
    Roy Boxwell
    Senior Software Architect
    Software Engineering GmbH
    Duesseldorf
    +4921196149675
    ------------------------------

    Original Message


  • 4.  RE: Maximum Partition Size of a Partitioned (non-UTS) tablespace defined with DSSIZE 2G LARGE keyword

    Posted Tue September 03, 2024 11:44 AM

    Hi Roy,

    Thank you for your response. We will plan to convert our tablespace to PBR RPN accordingly. 

    Best Regards,

    Srini



    ------------------------------
    Srini Atmakur
    ------------------------------

    Original Message


  • 5.  RE: Maximum Partition Size of a Partitioned (non-UTS) tablespace defined with DSSIZE 2G LARGE keyword

    Posted Wed September 04, 2024 12:52 AM

    Thats not good....One idea might be to COMPRESS the tablespace, this might get you out of trouble. 

    Also you might be able lower freespace and freepage then REORG, this obviosuly might hurt performance but it's alot better than running out of space.

    Good Luck.



    ------------------------------
    Phill Baker
    Software Consultant
    BMC
    ------------------------------

    Original Message


  • 6.  RE: Maximum Partition Size of a Partitioned (non-UTS) tablespace defined with DSSIZE 2G LARGE keyword

    Posted Mon November 04, 2024 10:09 AM

    a bit late response!

    ALTER TABLESPACE DSSIZE might help but need to consider that the change is treated as a pending DDL change, requiring an online reorganization to apply. 



    ------------------------------
    Karthikeyan Dhanapal
    ------------------------------

    Original Message