DB2 - L

 View Only
  • 1.  DB2 z/os alter maxpartitions based on percentage full last partition

    Posted Jul 14, 2022 05:26 AM
    Is there somebody who has automated the process of altering the maxpartition size base of the utilisation of the last partition for a PBG?

    Maybe some kind of rexx based on systablespacstats information?

    Kind regards, Paul

    ------------------------------
    PaulJansenATOS
    ------------------------------


  • 2.  RE: DB2 z/os alter maxpartitions based on percentage full last partition

    Posted Jul 14, 2022 12:18 PM
    Yes, but it is commercial software called SAX from my company. I doubt a REXX can cut the mustard with the amount of data...

    Roy Boxwell 


    SOFTWARE ENGINEERING GmbH and SEGUS Inc.
    -Product Development-
     


    IBM Champion 2022


    Vagedesstrasse 19
    40479 Dusseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: 
    R.Boxwell@seg.de
    Web  http://www.seg.de

    Link zur Datenschutzerklärung


    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert, Ulf Heinrich






  • 3.  RE: DB2 z/os alter maxpartitions based on percentage full last partition

    Posted Jul 18, 2022 01:32 AM
    Roy,

    I saw your SAX procudt. But we only want the alter for MAXPARTITIONS, and SAXxxxxx is doing much more.

    So we are looking for a free solution ;-)

    ------------------------------
    PaulJansenATOS
    ------------------------------



  • 4.  RE: DB2 z/os alter maxpartitions based on percentage full last partition

    Posted Jul 22, 2022 11:18 AM
    instead of setting maxpartitions = partitions, set it to partitions + 1.   Then a simple SQL comparing partitions to maxpartitions will let you know you're on the last one.

    now, when they're equal, you can increase maxpartions by 1.   Also, look into the table to ensure there's a purge process. It's rare, but sometimes that is forgotten.

    ------------------------------
    Ed Krisiewicz
    ------------------------------



  • 5.  RE: DB2 z/os alter maxpartitions based on percentage full last partition

    Posted Jul 22, 2022 12:22 PM
    Ed,

    that's what we are already do right now. ;-)

    Kind regards, Paul

    ------------------------------
    PaulJansenATOS
    ------------------------------



  • 6.  RE: DB2 z/os alter maxpartitions based on percentage full last partition

    Posted Nov 03, 2022 09:48 AM

    Hi Paul,

    You could use REXX or JCL to query the catalogue tables to get candidates for increased maxpartitions. I however think it's a better approach to look at total space used for the table and aim use less than a certain percentage of max allowed space, and when that threshold is passed, increase the maxpartitions. If you only look at the utilization of the last partition your table can easily be filled by a load before an increase is triggered.

    But like Ed was saying, always make sure there is a data maintenance/clean up routine in place ;)


    Regards
    Johan



    ------------------------------
    Johan Sundborg, Swedbank AB
    ------------------------------



  • 7.  RE: DB2 z/os alter maxpartitions based on percentage full last partition

    Posted Nov 03, 2022 10:09 AM
    Discussion topic on same 2 years ago.

    DB2 - L
    Idug remove preview
    DB2 - L
    Hello,We run daily capacity reports (similar to the one found in the Code Place), but we now need a better process to track growth throughout the day in case of
    View this on Idug >


    Hope this helps.

    Regards,
    Manoj K Jadwani

    ------------------------------
    ManojJadwaniBMC
    ------------------------------