DB2 - L

 View Only
Expand all | Collapse all

Do you use IBM DMC with Db2 for z/OS?

  • 1.  Do you use IBM DMC with Db2 for z/OS?

    Posted Jun 24, 2021 10:13 AM
    Hello dear audience,

    a few days ago IBM announced the new version of IBM Data Management Console 3.1.5.
    In the "What's new" section https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=new-version-315 they announce
    "Deprecated functions
    The monitoring dashboard for Db2 for z/OS® connections has been deprecated. The recommended tool for z/OS database administration is IBM Data Server Manager."

    So, if you use it and you feel now left behind, please feel free to comment here in the IBM Forum or down below, so I can point out to IBM Product Management, that it is sad they leave this terrain.

    I'm looking forward to your comments!

    Cheers

    ------------------------------
    Roland Schock
    IBM Champion and IBM Gold Consultant
    ARS Computer und Consulting GmbH
    ------------------------------


  • 2.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Jun 24, 2021 03:03 PM
    Hi Roland,

    The strategic direction is the newly announced Db2 Admin Foundation for DBA features and Db2 Developer Extension for VS Code for developer features.

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 3.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Jun 24, 2021 03:25 PM
    Hi Jørn,

    thanks for the response. I was not aware of this and just found this IBM announcement about it.
    Hmm, after a quick read, I can see, how deep the trench between Db2 for LUW and Db2 for z/OS still is.
    Also I noticed, the Db2 Admin Foundation seems to be a paid solution and not a free tool like DMC.
    So a customer having Db2 for LUW and Db2 for z/OS in his shop needs two infrastructures to manage his databases.

    Same issue is visible in the support of the Db2 extensions for VS Code, where there are also separate extensions for each platform.

    ------------------------------
    Roland Schock
    ARS Computer und Consulting GmbH
    ------------------------------



  • 4.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Jun 24, 2021 04:04 PM
    Db2 Admin Foundation is free. However, it is not yet feature rich and who knows if it will ever have the connection monitoring feature.
    Dan

    +--------------------------------------+-----------------------------------------------------------+
    | Daniel L Luksetich | IBM Certified Advanced Database Administrator – |
    | IBM GOLD Consultant | Db2 10.1 for Linux UNIX and Windows |
    | IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator – Db2 12 for z/OS |
    | IDUG DB2-L Administrator | IBM Certified System Administrator – Db2 11 for z/OS |
    | URL: https://db2expert.com | IBM Certified Application Developer – Db2 11 for z/OS |
    +--------------------------------------+-----------------------------------------------------------+




  • 5.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Jun 24, 2021 05:31 PM
    Hi Dan,

    I am not very familiar with DSM/DMC: what is the connection monitoring feature ? Is that the data coming from Omegamon Db2?

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 6.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Jun 24, 2021 06:44 PM
    I am personally not familiar with that feature. I'll be honest, I have never gotten DSM to work. It's functionality seemed limited and it crashed constantly. I gave up after several tries.

    For the Db2 Developer Extension the best way to request enhancements is via Github.

    Cheers,
    Dan

    +--------------------------------------+-----------------------------------------------------------+
    | Daniel L Luksetich | IBM Certified Advanced Database Administrator – |
    | IBM GOLD Consultant | Db2 10.1 for Linux UNIX and Windows |
    | IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator – Db2 12 for z/OS |
    | IDUG DB2-L Administrator | IBM Certified System Administrator – Db2 11 for z/OS |
    | URL: https://db2expert.com | IBM Certified Application Developer – Db2 11 for z/OS |
    +--------------------------------------+-----------------------------------------------------------+




  • 7.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Jun 24, 2021 05:30 PM
    Hi Roland,

    Admin Foundation is free but with optional S&S.

    The majority of the Db2 for z/OS features available in DS/DSM/DMC will become available in Admin Foundation or the Developer Extension over time. The order of which the features are delivered depend on customer feedback, so please open Aha ideas for the feature that you need to make the switch.

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 8.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Jun 24, 2021 09:14 PM
    DSM was such a poor product that IBM had to change it's name (to protect the guilty) to DMC.  To suggest that Db2 for z/OS users should use Db2 Admin Foundation OR DSM (when they no longer suggest that LUW users use it) is not really customer friendly.

    Joe

    ------------------------------
    Joe Geller
    ------------------------------



  • 9.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Jun 25, 2021 05:42 AM
    The deprecation of Db2 for z/OS features in DMC is the result of Db2 Admin Foundation and Db2 Developer Extension being the strategic direction for Db2 for z/OS admin and developer functionality. 

    On the positive side the development team for Db2 Admin Foundation and Db2 Developer Extension are 100% dedicated to Db2 for z/OS, so no Db2 LUW constraints. In addition, Db2 Admin Foundation is hosted on the mainframe, so no distributed server infrastructure needed.

    We'd like to know what features you need in Db2 Admin Foundation and Db2 Developer Extension to make the switch from DS/DSM/DMC ! Feel free to reach out off-list and I'll connect you to product management and architects.

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 10.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Mar 31, 2022 12:57 PM
    Does DB2 Admin Foundation even support the basic alerts that DSM does?  That is the main thing we use DSM for currently.  The last I heard, alerts were one of the features that "will become available over time".  Are alerts on the waiting list of things to add to the product?

    ------------------------------
    ThomasShimekAmerica First Credit Union
    ------------------------------



  • 11.  RE: Do you use IBM DMC with Db2 for z/OS?

    Posted Apr 01, 2022 03:40 PM

    Jørn,

    Regarding your original message regarding feature requests for Admin Foundation and Developer Extension!

     

    I don't have much idea of the domain of possible features, but here goes – based mostly on what I've seen in the two or other three IDE's which I've used, okay, for maybe ten or fifteen hours in the past ten years.

     

    ·         I've been fairly satisfied with the DS 4.1.x treatment of the SQL queries – good highlighting, line numbering, error flags and descriptions on the mouseover of the red-x

    ·         Not happy with the way DS (Eclipse) presents tabs and options – there has to be a less hidden-in-the-corner way of dealing with settings and tabs!

    ·         Visual Explain likes:

    o   The functions available with the Visual Explain

    o   The movability of the graph

    o   The things you can see with mouseover-and-hover.

    ·         Visual Explain, Not so happy with:

    o   Number of times you have to hit "enter" to work through setting one up – that seems like it could be easier

    o   Side tabs on the solution graph (showing the various components, explanations, and alternate views) are not easy to get to

    o   There's a lot of "you have to remember that this is there" about them (side tabs) – better visibility and more verbose descriptions would help here.

    o   I have a hard time understanding how the saved projects are structured and identified.  If I knew what I don't know, I maybe could describe my frustration better.

    ·         Autofills I'd Love To See:

    o   A close parenthesis after the developer types an open parenthesis

    o   same with comment [ ],

    o   Apostrophe ['],

    o   Quote ["]

    o   Structure fills - if someone types "CASE" then maybe autofill "WHEN" and "ELSE" and "END"

    o   Function fills – if the developer types [function]( then fill with descriptive word for each parameter, commas between parameters, [descriptive for optional parameter])

    ·         Help available in a mouseover for reserved words

    ·         Sidebars with things like lists of functions or syntax guides-and-prompts

    ·         Open-a-new-window and search-the-library-path-for-value and multiple windows

    ·         Stats Advisor with a pushbutton once you have a syntactically valid statement/query and a connected environment

    ·         If the underlying framework (Visual Studio?) comes with a scripting language, enable it for developers' use

     

    I'm sure I'm not done! But the well is dry at the moment.

     

    /phil

     

    Philip Sevetson

    Computer Systems Manager

    FISA-OPA

    New York, NY 10001

     

     






  • 12.  RE: Do you use IBM DMC with Db2 for z/OS?