XMA: MADELDBC Process using increased CPU resources.

XMA: MADELDBC Process using increased CPU resources.

Upgrade to XMA 2.45 or later. 

Workaround:

If unable to immediately upgrade to XMA 2.47, a filter can be added tot he FILTERS file that should assist in cleaning up the database.

FILTERDEFBEGIN $DB_CLEANUP
  STATUS ACTIVE
  MOVER_BEGIN
     MOVER_SELECT_BEGIN
      PRODUCT = FILEMAINT
     MOVER_SELECT_END
  MOVER_END
  DATA_BEGIN
    DATA_SELECT_BEGIN
       FILTERTYPE NOFILTER
    DATA_SELECT_END
  DATA_END
  ACTIONCOLL_BEGIN
    ACTION_BEGIN
      ACTIONTYPE RETAIN
      RETAIN_DAYS 7
    ACTION_END
  ACTIONCOLL_END
FILTERDEFEND
 
The Archive and Cleanup processes will check Filters with MOVER paragraphs with the PRODUCT set to FILEMAINT. They will find the MOVER paragraph with an ACTIONTYPE of RETAIN and check the value of the RETAIN_DAYS or RETAIN_MONTHS keyword, and then process audit records in the XMA database that match the data selection criteria for the Filter accordingly.

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

    • XYGATE: Installing XMA using XAI

      Copy the following file, to your Desktop as an icon, from the following link. \\fs.xypro.com\filesrv\HP\HP_XYGATE_DISTRIBUTION\Release_tracking Click on the icon to open the file. Click on the ?Summary? tab at the bottom of the file. You will see the ...

    • XMA: How to decrease the maximum CPU busy percentage for a mover

      The maximum CPU busy for a mover can be configured within XMA_MANAGER. If the CPU Usage is greater than or equal to the percentage specified in CPU Busy, the MOVER will sleep for a random interval of 1 to 3 seconds. The default value is 30%. If ...

    • XMA: Steps to edit the Merged Audit FILTERS file using XMA_EDIT_FILTERS

      The XMA_EDIT_FILTERS Macro makes a copy of the FILTERS file called NEWFILT and allows you to edit this. Once editing is complete you can choose to install the edited version. This renames the current FILTERS file to OLDFLTXX, and replace it with ...

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

    • XMA: xma_manager Check_SQLCompileNeeded

      Run the XMA_SQLCOMPALL macro to compile XMA object files. This problem arises when XMA object files have not been recompiled more 7 days after product installation. The solution is to recompile the SQL objects using the XMA_SQLCOMPALL macro. From the ...