• Font Size
  • S
  • M
  • L

Search via FAQ No.


  • No : 30689
  • Open Date : 2019/09/02 14:43
  • Print
NEW

[DataSpider Servista] Please tell me how to delete data stored in a repository DB.

I want to delete unnecessary data in order to reduce the amount of space used by the repository DB. Please tell me how to delete the data stored in a repository DB.
Category : 

Answer

The Repository DB saves file metadata, actual data, multiple user information, and various settings. Among these, the files typically use a large amount of space.
 
When saving files with DataSpider Servista, the repository DB is used when using the extended local file system or the database file system.
 
In either case, please delete the file using DataSpider Studio or the file operation adapter in the script.
 
Also, in the case of database file systems, please delete the file from DataSpider Studio and clean up the repository DB from the control panel.
 
Please refer to the following for the differences between the extended local file system and the database file system.
  • Extended local file system
In the extended local file system, actual files are saved in the OS file system, and the repository DB only saves file metadata.
 
This metadata remains in the repository DB even if the actual file in the OS file system is deleted. For this reason, please remove the metadata always from DataSpider Studio or the script.
  • Database file system
In the database file system, the actual data and the metadata are both saved in the repository DB.
 
When you delete the data with DataSpider Studio or the script, only meta information in the file is deleted, but the actual file still remains. In order to delete the actual file as well, please execute the repository DB cleanup together.
 
*Please refer to the link of "Reference Information" for the cleanup function of repository DB details.
 
 
Reference Information
  • The Repository DB cleanup