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.  Making better use of the free-of-charge DB2 SMP

    Posted Mon October 09, 2023 10:36 PM
    Edited by Satid Singkorapoom Mon October 09, 2023 10:43 PM

    Dear all

    Now that DB2 SMP has been available free of charge for all IBM i 7.x customers with active SWMA, making a good use of it would bring performance benefit to long-running SQL/Query as well as index build and table reorganization jobs. There is enhancement to this in IBM i 7.5 and it is clearly explained in this informative article just published by IBM i SW engineer a few days ago : TechTip: Fine-Tuning Db2 Symmetric Multiprocessing (SMP) to Improve Performance for Long-Running Queries at  https://www.mcpressonline.com/analytics-cognitive/db2/techtip-fine-tuning-db2-symmetric-multiprocessing-smp-to-improve-performance-for-long-running-queries

    Let me also add that it is advisable to also use Plan Cache's Show Statements + Visual Explain + Index Advisor (all from IBM i ACS GUI) to identify and create as many useful indexes for your prevailing long-running SQL/Query workload first and the use of DB2 SMP will not unnecessarily consume your HW resources (CPU + memory mainly).  This is because, without useful indexes in place, SMP will do unnecessary parallel table scans that unnecessarily burn your CPU and memory.  The existence of useful indexes help reduce this waste, unless you have so many CPUs and so much memory to burn :-) 

    Useful indexes + DB2 SMP will take your SQL/Query and DB admin workload performance a long way in IBM i. 

    ------------------------------
    Chance favors only the prepared mind.
    -- Louis Pasteur
    ------------------------------
    Satid S.
    ------------------------------



  • 2.  RE: Making better use of the free-of-charge DB2 SMP

    Posted Tue October 10, 2023 12:02 PM
    Edited by Kent Milligan Thu May 15, 2025 05:40 PM

    I also published an entry on my Db2 for i blog highlighting Db2 SMP Best Practices.



    ------------------------------
    Kent Milligan
    ------------------------------

    Original Message


  • 3.  RE: Making better use of the free-of-charge DB2 SMP

    Posted Thu January 09, 2025 09:22 AM

    Kent, thank you for this valuable article. I think our customers should also consider that an IBM i should be used only for OLTP or OLAP environment. The mix of these two needs hits the response times desired by the users of their applications, especially for example a Core Banking.



    ------------------------------
    Nicolas Rafael Ascanio Pena Customer Success Management - Architect
    Consultant Data & AI
    IBM
    Caracas
    +58 424 1406472
    ------------------------------

    Original Message


  • 4.  RE: Making better use of the free-of-charge DB2 SMP

    Posted Thu January 09, 2025 09:15 AM

    Thank Satid.!



    ------------------------------
    Nicolas Rafael Ascanio Pena Customer Success Management - Architect
    Consultant Data & AI
    IBM
    Caracas
    +58 424 1406472
    ------------------------------

    Original Message


Related Content