XMA: How to display the SQL/MP query plan for objects.

XMA: How to display the SQL/MP query plan for objects.

To display the SQL EXPLAIN plan use the following:

*NOTE: A XMA_SQLCOMPALL needs to be performed as the creation of the explain plan invalidates the program.

TACL>Volume <XMA Installation Subvolume>
TACL> RUN NEWDEFS
TACL> sqlcomp/in <XMA Object>,out <Output Location>/catalog =xma_cat,explain plan
TACL> XMA_SQLCOMPALL

Example:

TACL>Volume XYGATEMA
TACL> RUN NEWDEFS
TACL> sqlcomp/in SLSENDER,out $S.#XYPRO/catalog =xma_cat,explain plan

             
To display the MEASURE information use the following.

TACL> MEASCOM
+ADD SQLSTMT $<Volume>.<SubVolume>.<XMA Object>
+START <Measure Output File>
+Exit

When you are satisfied that some work has been performed by the object.
TACL> MEASCOM
+STOP <Measure Output File>
+ADD <Measure Output File>
+listall sqlstmt *,by records-accessed,rate off


If this article did not provide a solution, please open a case with our support team by sending an email message to support@xypro.com.
 



 

    • Related Articles

    • XMA: How to generate the SQL explain plan for movers.

      To produce an explain plan to show the SQL/MP cost and table usage for XMA movers. Using XMA_MANAGER stop the Mover Volume $<XUGATEMA Installation volume>.XYGATEMA RUN NEWDEFS SQLCOMP /IN <Object>/CATALOG =XMA_CAT,EXPLAIN Using XMA_MANAGER start the ...

    • XMA-XTR: Can XMA/XTR run on a system where SQL/MP is not licensed?

      XMA and XTR are allowed on systems that are not licensed for SQL/MP. ???????Important! If an HPE Non-Stop Server is not licensed for SQL by HPE, XMA is compiled with a runtime license so that you can use it with just a few limitations. The only ...

    • XMA: SLSENDER is busy

      Use the XMA_SQLCOMPALL macro to generate a new optimized query plan, which will then be used when compiling the objects. TACL> VOLUME $SYSTEM.XYGATEMA TACL> RUN XMA INSTALL TACL> XMA_PWSTOP TACL> XMA_SQLCOMPALL TACL> XMA_PWCOOL The XMA_SQLCOMPALL ...

    • XMA: XMA_MANAGER returns ERROR from SQL [-8025]: The SQL region was not SQL compiled

      To recompile the XMA SQL objects perform the following: TACL> VOLUME $<volume>.<XYGATEMA Installation Subvolume> TACL> RUN XMA INSTALL TACL> XMA_PWSTOP (Stop XYGATEMA Mover Processes) TACL> XMA_SQLCOMPALL (SQL Compile the Mover Objects) TACL> ...

    • XMA: Example of a SQL query to determine the number of unsent records in the SYSLOGQ table

      The sample query statements below can also be used as an input file, for example, SQLCI /in <in-file>/ on the XMA DB subvolume. The query to determine unsent records in the SYSLOGQ table. set list_count 0; set headings off; select cast (ALERTEDGMT as ...