Db2 Tools for zOS

 View Only
Expand all | Collapse all

Information Xchange - 2nd Topic

ADRIAN COLLETT

ADRIAN COLLETTTue October 19, 2021 11:31 AM

  • 1.  Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:22 AM

     

    As a Db2 for z/OS Data Studio user, which features today do you use and/or need the most?

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

    #Db2Toolsforz/OS


  • 2.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:24 AM
    Visual Explain is definitely used the most.

    ------------------------------
    George Ross
    ------------------------------



  • 3.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:25 AM
    Visual Explain
    Building and testing Stored Procedures
    Administering IDAA

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



  • 4.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:28 AM
    Edited by System Fri January 20, 2023 04:49 PM
    Who writes your stored procedures, developers, DBAs, a mix (application stored procedures)?  Are they stored in an SCM like git?
    What languages are your stored procedures written in?

    ------------------------------
    Patrick Bossman
    ------------------------------



  • 5.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:32 AM
    They are written by developers and DBAs. We try to get the developers to write all of them.
    Most of the new ones are Native SQL Procedures. We also use Cobol Stored Procedures for special purposes.

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



  • 6.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:58 AM
    All of our stored procedures are written by developers, but with guidance from the DBAs as needed.   All stored procs in written in SQL PL whenever possible, though we have many legacy COBOL stored procs.   The source code for all native stored procs is stored in the Db2 Catalog, not an SCM.

    ------------------------------
    Perry Shindle
    ------------------------------



  • 7.  RE: Information Xchange - 2nd Topic

    IBM Champion
    Posted Tue October 19, 2021 11:26 AM
    Query tunning

    ------------------------------
    Guillaume VENTRE
    IT Specialist IBM Z
    Sopra Banking Software
    Paris, France
    ------------------------------



  • 8.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:29 AM
    Do you use Optim Query Workload Tuner, or mostly Visual Explain / statistics advisor?

    ------------------------------
    Patrick Bossman
    ------------------------------



  • 9.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:34 AM
    We didn't get Optim Query Worklload Tuner to work properly, so we just use Visual Explain, statistics advisor and index advisor

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



  • 10.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:35 AM
    Visual Explain at the moment....

    ------------------------------
    George Ross
    ------------------------------



  • 11.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:59 AM
    We user Optim Query Workload Tuner, mostly for the Index Advisor.

    ------------------------------
    Perry Shindle
    ------------------------------



  • 12.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:28 AM
    IDAA administration and Visual Explain.

    ------------------------------
    Larry Jardine
    ------------------------------



  • 13.  RE: Information Xchange - 2nd Topic

    IBM Champion
    Posted Tue October 19, 2021 11:31 AM

    Visual Explain and Query Tuning
    IDAA
    IDAA Loader


    Ciao
    ADrian

    Virus-free. www.avast.com





  • 14.  RE: Information Xchange - 2nd Topic

    Posted Tue October 19, 2021 11:58 AM
    SQL tuning using the Query Workload Tuner, developing and testing native sored procedures, and native stored procedure deployment.

    ------------------------------
    Perry Shindle
    ------------------------------



  • 15.  RE: Information Xchange - 2nd Topic

    IBM Champion
    Posted Wed October 20, 2021 05:43 AM
    IDAA administration
    IDAA Monitor
    Application Object in particular stored procedure.
    REgards Chiara

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



  • 16.  RE: Information Xchange - 2nd Topic

    Posted Thu October 28, 2021 09:35 AM
    IDAA administration
    SQL tuning using the Query Workload Tuner
    To develop and test stored procedures

    ------------------------------
    Johnatan Ariotti
    DB2 z/OS Support
    BANCO DO BRASIL
    Brasilia
    ------------------------------



  • 17.  RE: Information Xchange - 2nd Topic

    Posted Mon November 01, 2021 09:06 AM

    We use Visual Explain, statistics advisor and index advisor.

    Index advisor is essential for tuning queries from fx. Hibernate, where developer is unaware of SQL and indexes.



    ------------------------------
    Jesper Krommes
    ------------------------------