We had aneed to reduce thesize of the databaseused bythe SD.We want to remove(with backup ofcourse)from DB recordsolder than 2years.Is it possible todo itwithout breaking thefunctionalityof SD andhow it will lookto the user?
It is not supported to perform SQL updates, trunc or delete statements on the database, because of the relationships between objects in SD. Doing database updates directly that bypass the SD Application Server may corrupt your DB and bring it into an unsupported state.
The proper way to reduce the DB size is by "archiving". (System Panel > Archive Settings, cf. Online help)
SD's archiving function disconnects relations between Servicecalls, Problems, Persons, CI's, attachments, and so on, then delete the archived item(s) such as Servicecalls older than 2 years from the DB.
Archiving uses normal views with specific filter conditions to isolate old items, say "servicecalls where registration;modified <= 2 years ago and status Closed and FAQ = false"
Optionally, before archiving deletes old items, you can export the data to an XML file for a records retaining policy for example. In the archiving view, choose the important fields to be displayed and archived. Fields not displayed will not be archived.
Note that the resulting archive XML is NOT suitable for importing it back into SD using Data Exchange.
If you don't want to keep the old data anyway (you are 100% sure that the old data is worthless), and you will delete the XML file at the end, then
- make the archiving view display only the ID field, nothing more
- uncheck archiving of historylines & attachments.
This will make the archiving action relatively fast.
After archiving is complete, the users won't notice anything special, except that the old (archived and deleted) items cannot be found anymore.
If an old Servicecall 12345 was related to Problem 6543, then after the archiving of old servicecalls,
the user cannot open or search for Sc 12345. Problem 6543 will still exist, but won't have a reference to Sc 12345 anymore.
Besides archiving, you could delete old records manually in the client GUI.
HPE Software Support
If you find that this or any post resolves your issue, please mark it as an accepted solution. Kudos are welcome.