Db2 Tools for zOS

Db2 Tools for z/OS

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Information Xchange - 2nd Topic

  • 1.  Information Xchange - 2nd Topic

    Posted 10/19/21 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 10/19/21 11:24 AM
    Visual Explain is definitely used the most.

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



  • 3.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 11:25 AM
    Visual Explain
    Building and testing Stored Procedures
    Administering IDAA

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



  • 4.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 11:28 AM
    Edited by System Admin 01/20/23 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
    ------------------------------

    Original Message


  • 5.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 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
    ------------------------------

    Original Message


  • 6.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 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
    ------------------------------

    Original Message


  • 7.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 11:26 AM
    Query tunning

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



  • 8.  RE: Information Xchange - 2nd Topic

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

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

    Original Message


  • 9.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 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
    ------------------------------

    Original Message


  • 10.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 11:35 AM
    Visual Explain at the moment....

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

    Original Message


  • 11.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 11:59 AM
    We user Optim Query Workload Tuner, mostly for the Index Advisor.

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

    Original Message


  • 12.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 11:28 AM
    IDAA administration and Visual Explain.

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



  • 13.  RE: Information Xchange - 2nd Topic

    Posted 10/19/21 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 10/19/21 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

    Posted 10/20/21 05:43 AM
    IDAA administration
    IDAA Monitor
    Application Object in particular stored procedure.
    REgards Chiara

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



  • 16.  RE: Information Xchange - 2nd Topic

    Posted 10/28/21 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 11/01/21 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
    ------------------------------



Related Content