Topic
2 replies Latest Post - ‏2012-12-12T06:41:39Z by lianggz1010
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic Error on Visual Explain

‏2012-11-23T08:30:30Z |
I can't get Access Plan Diagram for DB2 10 for z/OS.
What are the possible causes of error?

Trace the rendering of the access plan diagram:

5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_DETCOST_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_PREDICAT_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_STRUCT_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_FILTER_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_SORT_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_SORTKEY_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_PGROUP_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_PTASK_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_PGRANGE_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_VIEWREF_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.PLAN_TABLE WHERE BIND_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_STATEMNT_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator removeExplainData DELETE FROM KRK.DSN_FUNCTION_TABLE WHERE EXPLAIN_TIME='2012-11-23-11.43.46.870000' AND QUERYNO= 100
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace Time consumption] [ After Explainer
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Entry http://com.ibm.datatools.dsoe.explain.zos.impl.ExplainUtil getApgXml(ExplainInfo epInfo) Starts to get the XML string for APG
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Trace http://com.ibm.datatools.dsoe.explain.zos.impl.apg.DVNTrace write(String s) In generating XML for APG: Before APG, Runtime.getRuntime().totalMemory():79824384
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Trace http://com.ibm.datatools.dsoe.explain.zos.impl.apg.DVNTrace write(String s) In generating XML for APG: Before APG, Runtime.getRuntime().freeMemory():23182416
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Entry http://com.ibm.datatools.dsoe.explain.zos.impl.apg.ApgResultSet parseInMemory() Starts to parses the xml content in memory.
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Trace http://com.ibm.datatools.dsoe.explain.zos.impl.apg.DVNTrace write(String s) In generating XML for APG: Read EPContent.xml successfully...
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Trace Time consumption] [ Start to gather data from Explainer
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Trace Time consumption] [ Start to import data to DOM
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Entry http://com.ibm.datatools.dsoe.explain.zos.impl.ExplainInfoImpl save(String fileName) Starts to save the explain info to a file: C:\Users\Администратор\IBM\Data Studio 3.1 stand-alone\workspace\.metadata\.plugins\com.ibm.datatools.dsoe.resource\temp_xml\epInfo_2012_11_23_11_41_41_237.xml
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Entry http://com.ibm.datatools.dsoe.explain.zos.impl.ExplainInfoImpl saveWithFileName(String fileName) Starts to save the explain info to a file: C:\Users\Администратор\IBM\Data Studio 3.1 stand-alone\workspace\.metadata\.plugins\com.ibm.datatools.dsoe.resource\temp_xml\epInfo_2012_11_23_11_41_41_237.xml
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Entry http://com.ibm.datatools.dsoe.explain.zos.impl.EPResultSet addEPInfoToXML(ExplainInfoImpl epInfo) Starts to add the ExplainInfo to XML.
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Exit http://com.ibm.datatools.dsoe.explain.zos.impl.EPResultSet addEPInfoToXML(ExplainInfoImpl epInfo) Finishes to add the ExplainInfo to XML.
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Entry http://com.ibm.datatools.dsoe.explain.zos.impl.EPResultSet save(String xmlFileName) Starts to save the XML content to a XML file: C:\Users\Администратор\IBM\Data Studio 3.1 stand-alone\workspace\.metadata\.plugins\com.ibm.datatools.dsoe.resource\temp_xml\epInfo_2012_11_23_11_41_41_237.xml
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Exit http://com.ibm.datatools.dsoe.explain.zos.impl.EPResultSet save(String xmlFileName) Succeeds to save the XML content to a XML file: C:\Users\Администратор\IBM\Data Studio 3.1 stand-alone\workspace\.metadata\.plugins\com.ibm.datatools.dsoe.resource\temp_xml\epInfo_2012_11_23_11_41_41_237.xml
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Exit http://com.ibm.datatools.dsoe.explain.zos.impl.ExplainInfoImpl saveWithFileName(String fileName) Succeeds to save the explain info to a file: C:\Users\Администратор\IBM\Data Studio 3.1 stand-alone\workspace\.metadata\.plugins\com.ibm.datatools.dsoe.resource\temp_xml\epInfo_2012_11_23_11_41_41_237.xml
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Exit http://com.ibm.datatools.dsoe.explain.zos.impl.ExplainInfoImpl save(String fileName) Succeeds to save the explain info to a file: C:\Users\Администратор\IBM\Data Studio 3.1 stand-alone\workspace\.metadata\.plugins\com.ibm.datatools.dsoe.resource\temp_xml\epInfo_2012_11_23_11_41_41_237.xml
5072 ModalContext 11/23/12 11:41:41 AM MSK Infrastructure Entry http://com.ibm.datatools.dsoe.common.XMLParser XMLParser() Began to create the DOM parser.
5072 ModalContext 11/23/12 11:41:41 AM MSK Infrastructure Entry http://com.ibm.datatools.dsoe.common.XMLParser XMLParser() succeed to create the DOM parser.
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Entry http://com.ibm.datatools.dsoe.explain.zos.impl.apg.ApgResultSet importData() Failed to parse ep.xml.
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Trace http://com.ibm.datatools.dsoe.explain.zos.impl.apg.DVNDAGenXML String genXML() Failed to parse the XML content in memory
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Exit http://com.ibm.datatools.dsoe.explain.zos.impl.ExplainUtil getApgXml(ExplainInfo epInfo) Succeeds to get the XML string for APG
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator http://getAPGInformation(...) INFO: Began to invoke user exit to modify APG, if any extender found.
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace AccessPlanGenerator http://getAPGInformation(...) INFO: No user exit extender found.
5072 ModalContext 11/23/12 11:41:41 AM MSK Access Plan Graph Trace Time consumption] [ Finish generating APG XML
5072 ModalContext 11/23/12 11:41:41 AM MSK Input SQL Entry http://com.ibm.datatools.dsoe.common.input.SQLImpl void release() Began to reset the SQL object.
5072 ModalContext 11/23/12 11:41:41 AM MSK Input SQL Trace http://com.ibm.datatools.dsoe.common.input.SQLImpl void release() Began to dispose the objects of com.ibm.datatools.dsoe.explain.zos.ExplainInfo
5072 ModalContext 11/23/12 11:41:41 AM MSK Input SQL Trace http://com.ibm.datatools.dsoe.common.input.SQLImpl void release() The object is removed.
5072 ModalContext 11/23/12 11:41:41 AM MSK Explainer Entry http://com.ibm.datatools.dsoe.explain.zos.impl.ExplainInfoImpl dispose() Starts to dispose the ExplainInfo.
Updated on 2012-12-12T06:41:39Z at 2012-12-12T06:41:39Z by lianggz1010
  • lianggz1010
    lianggz1010
    12 Posts
    ACCEPTED ANSWER

    Re: Error on Visual Explain

    ‏2012-12-12T05:43:32Z  in response to SystemAdmin
    Hi Konstantin,

    This is known issue. It will be fixed in the coming release. Thanks a lot.

    Thanks and Best Regards

    Data Studio Optim Query/Workload Tuner
    • lianggz1010
      lianggz1010
      12 Posts
      ACCEPTED ANSWER

      Re: Error on Visual Explain

      ‏2012-12-12T06:41:39Z  in response to lianggz1010
      Hi Konstantin,

      Just as an update. The issue is fixed in Data Studio v32 which is just available for download: http://www-01.ibm.com/support/docview.wss?uid=swg24033663

      Any further problem with it, kindly please please let me know. Thanks a lot.

      Thanks and Best Regards
      Data Studio Optim Query/Workload Tuner