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

• 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: 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: The message "System not licensed for XYGATE-MA" is displayed when running XMA_MANAGER during a new XMA install

  1. Run LICCHK from the XYGATEMA subvolume to ensure that the license is valid. Example: a. VOLUME $SYSTEM.XYGATEMA b. RUN LICCHK P28F001 2. If the license is good, check to see fi the FILTERS file can be compiled. From the XYGATEMA subvolume: ...

• 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:Ways to address SQL error due to error 45 in AUDDET or AUDSESS

  Below are the Steps for ?Option 1? clean up the obsolete data records: Step: Option 1.0. Logon as an owner of XMA installation and install XMA macro at TACL Step: Option 1.1. Stop XMA Pathway by running the XMA_PWSTOP macro at TACL (or at the ...