We are cleaning up some files. We use SQL called from an SQLRPGLE program to do the deletes.  One file processed in a timely manner while the other took days. 

File one has FRCRATIO(*NONE) while the other file had FRCRATIO(20).  When I looked at the two libraries for the database, one library had a 2-1 ratio of *NONE to 20. The other has about 1-1.    

------------------------------
David Taylor
Sr Application Developer
Range Resources
Fort Worth
------------------------------

Dear David

I have always thought that Force Ratio has to do with data write only.  Since you use SQL to do row delete, a proper way is to look into the Plan Cache to compare the access plan of the two delete jobs or just analyze the access plan of the slow job.  The Visual Explain graph may reveal that it may come down to a simple thing like whether you have proper index created for the columns specified in WHERE clause (ORDER BY, GROUP BY, and join columns)  or not.   If you see this is already in place, then please read this article that I attached herewith on SQL Fast Delete feature that was new in IBM i 6.1 to see if it helps or not.

------------------------------
Satid S
------------------------------