Technical Blog Post
Abstract
Gentran:Server for Windows - How to delete a large number of documents from the ?Out Documents
Body
How to delete a large number of documents from the ?Out Documents.
Potential scenario: a map is caught in an infinite loop and creates thousands of documents in the ?Out Documents.
Cannot delete a large number of documents from the ?Out Documents and GENTRAN is not responding when trying to delete the documents from the ?Out Documents. If manually deleting the documents fails, run a DELETE query to clear the documents from the system.
To remove all the documents from the ?Out Documents, run the following query:
SQL:
DELETE FROM Document_tb where LocationStaus=5
Oracle:
DELETE FROM "Document_tb" where "LocationStatus" = 5;
Subsequently, run GiCheck to remove the orphaned files created by the query.
This should be done with the services stopped and a backup of the database and GENSRVNT directory in place.
UID
ibm11122837