Hi,
I have a scenario where my C:\Skyline DataMiner\System Cache\Local\ElementData_xxx\ folder is swamped with over 2 million of DAT and MSSQL server query files. Although there are a few workarounds, may I ask if is it safe to delete such files and speed up the DMA restart ?
TIA 🙂
Hi,
The files in this folder are data updates which still need to be inserted into the elementdata table (on an SQL setup).
The elementdata tables contain saved element data (saved configuration data / saved table keys or data), allowing the corresponding DataMiner element to start out with the same element data as before after an element or DataMiner restart.
.dat files contain new and updated data, .sql files contain queries (typically delete queries to remove data for deleted DataMiner table rows or queries that change keys)
At DMA startup, DataMiner will try to offload the still pending files into the database, which can delay startup.
Removing the files will basically drop these updates, having elements restart from older data. Depending on how the connectors work, elements might recover by polling data updates from their data source.
If there are a lot of files in this folder, it might be good to investigate whether there is a single element which is generating excessive numbers of files here. In normal operation, the folder should be close to empty.
Hi Wouter,
Thank you for the detailed suggestions. Customers have tried to rename the data from the local folder as a workaround to bring up the DMA pair first.
While it seemed the data returned back and accumulated again sometime later. Is there a way to purge these data from DB so that it won’t be copied to the local folder after being deleted? Customers understand they will lose data by doing this.