What product/components do you use and which version/fix level are you on?
webMethods Integration Server - 10.3.0.0
Is your question related to the free trial, or to a production (customer) instance?
What are you trying to achieve? Please describe it in detail.
I would like to know if there’s a way via application (Integration Server Admin page, for example) to clear old logs from the database vinculated with the IS (this table is in SID “WPB”).
I ask that because the space available in this database is dropping and I would like to delete older data.
I’ve found the tables “WMERROR” and “TB_EAI_LOG” consuming, respectively, 17GB and 5GB with data from 2019 and we don’t need this data anymore.
Please, which is the best way to delete this older data?
Only by direct SQL?
Thanks in advance!
Do you get any error messages? Please provide a full error message screenshot and log file.
No error message
Have you installed all the latest fixes for the products and systems you are using?
afaik there is no IS Admin page where the tablespace consumption can be monitored.
Regarding the DB size you can check the Monitor Users Guide for details.
You will require an additional database schema for the Archiving function as well as MWS installed and configured.
Additionally the WmMonitor package needs to be installed to the IS affected and configured.
The mentioned package has Built-In-Services for archiving/deleting for several scopes.
Just choose the DELETE option to remove outdated data instead of transferring it from the original tables to the tables in the Archive schema (option ARCHIVE).
the services you are looking for are in the wm.monitor.archive folder, you can invoke them from IS Admin when browsing the package contents for WmMonitor.
You will need at least wm.monitor.archive:serviceArchive and wm.monitor.archive:serverArchive for the tables you want to reduce.
Remember to inform your DBA after deleting the data that he should analyse the IS core schema to get the tablespace freed.
TB_EAI_LOG sounds like a custom table to me as I have never heard of such a table in relation with webMethods.
Most likely ths table will not be considered during running the archiving service in DELETE mode.
Thanks for your advices. I managed to enable My webMethods Archive Audit and I managed to do the “serverArchive” proccess.
But, I’m receiving the following message when trying to execute “serviceArchive” (which deletes data from WMERROR - the biggest table):
Is there anything that I must do to fix this error?
Also, in myWebMethods, there isn’t any DB Pools in “Define Environments” section (is this normal?):
the Environment config shown here only applies when you are using Optimize (for Infrastructure and/or Process).
When you are just want to archive this is not relevant.
Usually I invoke these archiving services manually from IS Admin → Packages → Management or programmatically by using a FlowService being configured as a daily scheduled task in IS.
MWS is only needed for authorization in this case.
Therefore WmMonitor package must be configured to know the MWS instance.