XMA: How to get SQL queries in SQLXPress audit passed to the XMA database via SQX mover

XMA: How to get SQL queries in SQLXPress audit passed to the XMA database via SQX mover

The Audit Level in SQLXPress must be set to ACCESS for SQL queries and CONTROL statements to be added to SQLXPress audit.  Once the queries are logged the SQLXPress audit, XMA reads SQLXPress audit and adds queries to the XMA database. The steps to change the Audit Level to capture this information are below:

1. SQLXPRess > Select Tools > Security Manager

2. Set the Audit level to "Access? by dragging the slider on the left hand side to "ACCESS"

3.Verify the SQLXPress mover is running
>run xma install
>XMA_MANAGER
>1. Pathway
>4. Quick server status



If you are unable to locate the solution needed or if you need additional assistance please Click Here to open a case from our Customer Care Portal.


    • Related Articles

    • SQLXPress: Does SQLXPress use MXCI?

      SQLXPress mainly uses dynamic SQL statements. However, SQLXPress does use MXCI for some of it's functions. Several background tasks, such as partition management and audit extract, include $MXCI in the scripts that they submit to NetBatch. Commands ...

    • XMA: How to force a Mover to read data from the first file in the products Audit Pool

      Deleting and re-adding the mover is the only way to get the Safeguard mover to read the product audit pool records from the beginning if re-populating an XMA database that was re-partitioned and data was lost. Deleting the Mover: Using XMA_MANAGER ...

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

    • XMA: How to check Mover database and Pathway parameters.

      Modified pathway and database parameters are stored in the PARAMS table. By default it is stored in the subvolume XMADAT. To confirm that default parameters for a mover have been changed and to view what the new value is: TACL> VOLUME <XYGATEMA SQL ...

    • XMA: XMA Softdoc contains an entry that mentions SQLXPress v 3.50.3. Should I be concerned?

      This entry was related to an old SQLXPress bug with AX. AX is not part of XMA - it is a piece of SQLXpress code, but is run by the XMA SQLXpress mover (if one is configured) to retrieve SQLXpress audit data. The issue referred to in the softdoc was ...