x Want to participate? Join the group to interact
Mike Shaw
Related
Recommended

How can I purge the records from the Performance Index function (AIOBENCH)

1 minute read time.

Hopefully you all know about and use the "Performance index" (AIOBENCH) feature to monitor your system performance.  (Development, Utilities, Verifications, Performance index)

Whilst it is useful to be able to review the old data as a comparison to more recent performance indexes, I was asked how to clear out the existing trace files as the customer had a large number of records and wanted to purge out the old records, but found there is no obvious way to do so!

The data for this function is stored in the X3.AIOBENCH table, but when I checked the archive/purge tables and found there is no mention of this table.    This article will therefore run through the steps to setup a purge record for the X3.AIOBENCH so you can easily purge data if you wish to do so.

NOTE: before you run a purge, you may wish to capture the existing data by exporting to Excel using the "Dedicated export" option within the Performance index function.

.

1.  Login to X3 as an ADMIN user and make sure you are connected to the X3 folder endpoint.

2.  Navigate to Development, Data and Parameters, Development setup, Archive/Purge

Add a new record for AIOBENCH table. I'm going to keep it simple as possible, but make sure to enter TESDAT for the date field

3.  Navigate to Parameters, Usage, Data, Purge Parameters

You will now see AIOBENCH on the list, so can set Purge to "Yes" and how long to keep records for (10 days in my example, but you may wish to keep records for longer)

4.  You are now ready to run your purging.   As with any archive/purge you can setup on a batch task, or run interactively on-demand.

To test my setup, I will run interactively via Usage, Usage, Archive/Purge

Select the appropriate options, in my case I select "Purge" "Detailed log file" and deselect "Simulation"

Click OK to run and we're done.... our AIOBENCH records have been removed according to the Purge Parameters that are configured.

NOTE: the log files in the file system at "..\Folders\X3\TRA" will not be removed by this process, but should be removed as part of your batch server log purge process.

  • in reply to David Weinreich - Balt

    Hello David,

    I fear you may have been misguided.  Even with V11 Patch 18, the purging should already be there for the ALOGIN table.  Login and connect to your folder in question.   Go to Development--> Data and Parameters--> Development Setup--> Archive/Purge and query back the AUDIT record.  This should be already setup for ALOGIN, as well as the AUDITH and AUDITL tables.  You can then setup purging using this AUDIT record, albeit it will obviously also purge the audit as well as login data.

    If you do want to setup your own seperate purging record just for ALOGIN table, then you should be doing that against the folder you are concerned with rather than the X3 folder. You would also not likely want to keep 999 days worth of data, so perhaps set to smoething like 60 days (depending on your business requirements) Rather than a save button, you should see "OK" on the top right of the screen which will save any changes.   if not, then maybe your user permissions are not sufficient to make changes.

    Hope this helps

    regards

    Mike

  • in reply to David Weinreich - Balt

    after you discussed with your client, you can just delete direct.

  • OR... Does anyone know if I could just use a SQL statement to delete rows from ALOGIN?

  • Thanks for this post.  We are running v11p18.  Our ALOGIN table is about 2.3M rows.  US Sage Support said we could use this AIOBENCH solution for ALOGIN.  In our test server's X3 Folder, logged in as admin, I successfully created the Development, Data and Parameters, Development setup, Archive/Purge entry.  I then went to Parameters, Usage, Data, Purge Parameters.  I found my new ALOGIN entry and entered 999 Days.  But there is no Save button.  I have been unable to save the number of days.  What am I doing wrong?

Generic Content
Generic Content

*Community Hub is the new name for Sage City