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

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 Mover

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 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 ...

    • 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: SLENDER retryable transient error -4060 SQL Error : SqlCode : -4060

      To resolve the SLSENDER mover due to missing PARAMS and SYSLOGQ tables: TACL> VOLUME $<VOLUME>.<XYGATEMA Installation Subvolume> TACL> FUP COPY NEWDEFS TACL> OBEY NEWDEFS TACL> INFO DEFINE =XMA_PARAMSTBL Output should return something such as: Define ...

    • XMA:Can the XMA database only be created with SQLMP?

      XMA installation volume has TACLSRC script that only creates SQL/MP data base. XMA supports only SQL/MP Database. XMA movers support SQLXpress that can be configured with SQL/MP, SQL/MX, or both. If you are unable to locate the solution needed or if ...