Db2 for z/OS & Db2ZAI

Db2 for z/OS and its ecosystem

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

Data Server Manager can not use "EXPLAIN" feature for SQL tuning

  • 1.  Data Server Manager can not use "EXPLAIN" feature for SQL tuning

    Posted Tue November 02, 2021 11:38 PM
    Hello, a customer who is using DSM for DB2 FOR Z/OS type connection, but failed to do "EXPLAIN" for SQL tuning. Is it the limitation of DSM Base Edition? Or, is it related to configuration issue?BTW, based on the doc - https://community.ibm.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=31aa3d11-a951-ccb0-264b-13bf21b469f1&forceDialog=0, I saw "Visualize access plan (EXPLAIN)" is supported in base edition, but not able to do tuning operation related to "Manage performance". So, my understanding for the customer problem maybe related to the limitation of Base Edition.Do need kindly advice. Thanks!


    ------------------------------
    KEVIN LIN
    ------------------------------

    #Db2forz/OS