IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
 View Only

  • 1.  FORCE_WRITE_RATIO and processing speed

    Posted Tue August 06, 2024 02:29 PM

    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
    ------------------------------


  • 2.  RE: FORCE_WRITE_RATIO and processing speed

    Posted Tue August 06, 2024 10:30 PM
    Edited by Satid S Tue August 06, 2024 10:32 PM
      |   view attached

    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
    ------------------------------

    Attachment(s)

    pdf
    SQL-Fast Delete.pdf   221 KB 1 version
    Original Message


Related Content