XMA: master DDL location for XMA tables
It is called NEWTBLS, which is located in the XMA installation subvol.
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: Database Tables are filling up
You may either partition the tables or create new, larger tables. Option 1 - Partition the AUDSESS and AUDDET tables Partitioning the AUDSESS and AUDDET files will give them more room to grow. To assist in this process there is a file in the XYGATEMA ...
XMA: Update Statistics Macro doesn't work when the XMA Tables are partitioned.
Customer needs to execute the UPDATE STATISTICS by following the below steps. VOLUME <XMA VOLUME> (Ex., VOLUME $SYSTEM.XYGATEMA) RUN XMA RUN NEWDEFS UPDATE ALL STATISTICS FOR TABLE =XMA_AUDSESSIONTBL NO RECOMPILE PROBABILISTIC; UPDATE ALL STATISTICS ...
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 How To Change Ownership On The Existing Installation
The following methods are available to change the ownership of an XMA environment. Method #1 - Re-Install XMA Procedure: Refer to Chapter 1 " Installing XMA " in the XYGATE Merged Audit (XMA), User's Guide and Reference Manual Method #2 - ...
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 ...