Db2 Tools for zOS

 View Only
  • 1.  Information Xchange - Final thoughts -

    Posted Tue October 19, 2021 11:55 AM

    Thanks for participating.  We will leave the discussion open for one week and then compile the results. So keep responding, we'll keep watching for results.

    Sorry about the delay - but overall. how did you feel about this exchange?  Would you do it again?  Any other topics you'd like to discuss?

    Every time you responded to a post, you were entered into a raffle for an IBM swag gift!  If you are selected, an email will be sent asking for mailing instructions. 



    ------------------------------
    CALENE JANACEK
    ------------------------------

    #Db2Toolsforz/OS


  • 2.  RE: Information Xchange - Final thoughts -

    Posted Tue October 19, 2021 12:02 PM
    It liked the exchange. Some questions where a bit to complex to reply to properly. I would absolutely do it again.

    ------------------------------
    Martin Ålund
    ------------------------------



  • 3.  RE: Information Xchange - Final thoughts -

    IBM Champion
    Posted Wed October 20, 2021 05:22 AM
    Hello Calene,
    love this 'Jam innovation' sessions.
    Think it is useful to share ideas, needs , user's preferences and also hear what developers have to share with us!
    Love to read the answers from other customers, it gives us the opportunity to see also other points of view .
    Regards Chiara


    ------------------------------
    Chiara Baldan
    ------------------------------



  • 4.  RE: Information Xchange - Final thoughts -

    IBM Champion
    Posted Wed October 20, 2021 06:05 AM
    Calene, 
    a Final Thoughts as you should already know we are having some issues to get the Zowe installed on a pre-production system. It was installed on a test system where I do not have any Db2s. It is months I am sking z/Os system programer to have zowe installed where I have my test db2s to be able to install Db2 Foundation admin tool. 
    Installing zowe it is not one priority for them one of the reason could be that there is not yet a date where Data studio will be no more supported and we will have to pass to Db2 foundation toll.
    My worried is not to be ready when this date will come out, especially my main concern is for IDAA administration and monitor (since it is the only tool we have fot that) while for Db2 we have other tools.
    Said that will there be a plan to have a Db2 Foundation tool 'stand alone'  that will not require zowe? 
    Availabe for further discussion

    ------------------------------
    Chiara Baldan
    ------------------------------



  • 5.  RE: Information Xchange - Final thoughts -

    IBM Champion
    Posted Thu October 21, 2021 05:15 AM
    Hi Chiara,

    UMS and Admin Foundation leverages many features from the Zowe platform, e.g., security and virtual desktop, so a standalone version is very unlikely.

    ------------------------------
    Jørn Thyssen
    ------------------------------



  • 6.  RE: Information Xchange - Final thoughts -

    IBM Champion
    Posted Fri October 22, 2021 04:58 AM
    Thanks Jørn

    ------------------------------
    Chiara Baldan
    ------------------------------



  • 7.  RE: Information Xchange - Final thoughts -

    Posted Thu October 21, 2021 09:38 AM
    Edited by System Fri January 20, 2023 04:25 PM
    Not sure this is the correct place for this topic. I can move it if need be.

    We have been looking at the runstats clean  . In DB2 v12 fl 507, as part of the function level, Db2 is cleaning up the SYSIBM catalog tables and the SYSIBM.Profile_Table. I would like to discuss if possible 

    1.  I would like to know if others have gone through this process, and have they seen performance Gains?
    2. How do you determine if the Clean up of a Tables statistics is really going to  help at Runtime
    3. In function level 507 it is stated that the profile table runstats control  is going to be cleaned up if some control cards are needed anymore, or if there are old statistics in the catalog tables that in function level 507, it will also remove old stats.

    4. Is there notification when stats are cleaned up?

    We have been investigating the clean up for quite a while but are gun show because you really have no way of knowing the impact if and when you do this in production

    ------------------------------
    carol goldberg
    ------------------------------



  • 8.  RE: Information Xchange - Final thoughts -

    Posted Mon October 25, 2021 05:13 PM
    Hi Carol - please post this in the Db2 for z/OS Group.  Thanks!

    ------------------------------
    CALENE JANACEK
    ------------------------------