DB2 - L

 View Only
  • 1.  Why UTS

    Posted Dec 20, 2021 07:11 AM
    Hi All,

    Since simple table spaces were depreciated we are converting them to UTS any other reason why we need to go with UTS conversion.

    Thanks in advance
    Sekhar.

    ------------------------------
    Sekhar
    ------------------------------


  • 2.  RE: Why UTS

    Posted Dec 20, 2021 07:21 AM

    Simple tablespace, segmented tablespaces and "classic" partitioned tablespaces have all been deprecated.  Once you get to Db2 v12 FL 504, UTS (either partition-by-range or partition-by-growth) is your only option for CREATE TABLESPACE (unless you set your CURRENT APPLICATION COMPATIBILITY to a lower function level).

     

    Bill Gallagher | Senior Systems Engineer, DBA

     






  • 3.  RE: Why UTS

    Posted Dec 20, 2021 06:08 PM

    For completeness:  one place where UTS is discouraged is for workfile tablespaces (DSNDB07 or whatever).  DSNTIJTM / DSNTWFG will set application compatibility back to V11R1 if it creates them.

    One of the 'Apollo'  presentations mentioned that there was work to 'do something' about this situation for Apollo.   



    ------------------------------
    James Campbell
    ------------------------------



  • 4.  RE: Why UTS

    Posted Dec 20, 2021 08:27 AM
    All of the new whizz bang features and extras are *only* for UTS spaces... so it pays to get there!

    Roy Boxwell

    SOFTWARE ENGINEERING GmbH and SEGUS Inc.
    -Product Development-

    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




  • 5.  RE: Why UTS

    Posted Dec 20, 2021 09:14 AM
    I had a whizz bang feature once. It was quite painful.




  • 6.  RE: Why UTS

    Posted Dec 21, 2021 06:58 AM
    The real question is, why WOULDN'T you?

    It can be tricky if you have multiple tables in a tablespace to single them out (I think IBM provides a methodology for this in M508??). But other than that...why would you NOT want to have BOTH the operational advantage of space-maps AND the scalability of partitions in a tablespace??

    There's also the support-issue. Right now IBM would probably still support you if you had an issue with simple tablespaces. Sooner or later they'll get to a point where Lvl1 is going to say, "before we take a crack at this, try REORGing these objects into UTSes". It's not just access to the whizz-bangs, it's avoiding the snap-crackle-pops.

    ------------------------------
    MarkWieczorkowski...
    ------------------------------



  • 7.  RE: Why UTS

    Posted Dec 22, 2021 08:53 AM

    Speaking of snap-crackle-pop, the news this morning is that the Kellogg's strike has been settled.  The union has voted to accept and is officially pleased with the results.  All of us union folks can buy our Pop-Tarts again!

     

    /phil

     

     

    Philip Sevetson

    Computer Systems Manager

    FISA-OPA

    5 Manhattan West

    New York, NY 10001

    psevetson@fisa-opa.nyc.gov

    917-991-7052 m

    212-857-1659 f

    image001.png@01D261E4.BE68E970

     






  • 8.  RE: Why UTS

    Posted Mar 10, 2022 03:41 PM
    Edited by Rich Gatanis Mar 10, 2022 04:00 PM
    Besides all the performance reasons to convert to UTS, some orgs do not want to convert to UTS due to inspired platform change initiatives.   

    So,  is it safe to say that applications can create segmented multi-table tablespaces while having Db2v12 FL508 active,  if the EXEC SQL SET CURRENT APPLICATION COMPATIBILITY = VvvRrMmmm (FL503 or lower) during creation?

    And as a follow-up, can segmented multi-table tablespaces be maintained and function properly while Db2v12 FL508+ is active?

    ------------------------------
    RichGatanis
    ------------------------------



  • 9.  RE: Why UTS

    Posted Mar 11, 2022 02:31 AM
    Yes to both questions, but as mentioned in an earlier post - At some point in time these deprecated tablespaces will no longer be supported. I have no idea when, maybe even never, but I hate the thought of being the only shop in the world running production workload on deprecated spaces when you know that IBM are probably not really testing that thoroughly anymore...

    Roy Boxwell

    SOFTWARE ENGINEERING GmbH and SEGUS Inc.
    -Product Development-



    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