IBM i Global

 View Only
Expand all | Collapse all

5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

  • 1.  5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    Posted Tue November 29, 2022 09:47 AM
    Hello, everyone

    Please can you confirm if the 5770-QU1IBM Query for i is included with the purchase of the 5770-ST1IBM DB2 Query Manager and SQL Development Kit for IBM program for the IBM i version 7.4?

    Thanks a lot,

    ------------------------------
    Regards,

    John Rivera
    ------------------------------


  • 2.  RE: 5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    IBM Champion
    Posted Tue November 29, 2022 10:08 AM
    Hi John, 

    Start in june 2022 both pruducts are free of charge. You have to place the necesary order to IBM in order to get the license key.

    Best regards,  




    ------------------------------
    Nicolae Chirea
    System architect
    Saytel Informatica SL
    Madrid
    +34607868409
    ------------------------------



  • 3.  RE: 5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    Posted Tue November 29, 2022 07:55 PM
    Hi Nicolae, thanks for the answer, I'll keep it in mind.

    ------------------------------
    John Rivera Conca
    ------------------------------



  • 4.  RE: 5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    IBM Champion
    Posted Wed November 30, 2022 01:36 AM
    Edited by Satid Singkorapoom Wed November 30, 2022 01:37 AM
    Dear John

    For more accurate information in case it is useful for you, QU1 NEVER has any offering relationship with ST1 product whatsoever.  QU1 used to be a free-of-charge bundle under Web Query product (QU2 and WQX) until 2019 (not 2022) when QU1 was changed to be an independent zero-priced product.  And then starting in June this year, there are many more IBM i SW products that were changed to zero-priced, including ST1.  More details on June 2022 IBM i SW price change announcement here : https://www.itjungle.com/2022/06/27/big-blue-tweaks-ibm-i-pricing-ahead-of-subscription-model/

    ------------------------------
    Right action is better than knowledge; but in order to do what is right, we must know what is right.
    -- Charlemagne

    Satid Singkorapoom
    ------------------------------



  • 5.  RE: 5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    Posted Thu December 01, 2022 10:14 PM
    Satid thanks for the answer, excellent reference.


    ------------------------------
    John Rivera Conca
    ------------------------------



  • 6.  RE: 5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    Posted Wed November 30, 2022 08:44 AM
    I know your question has been answered, but I wanted to also point out that DB2 Symmetric Multiprocessing is now a no-charge option. You can get a little more performance out of your IBM i if you have multiple cores available. 


    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 7.  RE: 5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    IBM Champion
    Posted Wed November 30, 2022 07:57 PM
    Dear Jeremy

    I wholeheartedly agree that as DB2 SMP is now a no-charge SW product for ALL releases of IBM i version 7, it should be ordered and beneficially used by IBM i customers who have at least substantial Query and/or SQL workload, which practically means most, if not all.

    ------------------------------
    Right action is better than knowledge; but in order to do what is right, we must know what is right.
    -- Charlemagne

    Satid Singkorapoom
    ------------------------------



  • 8.  RE: 5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    Posted Thu December 01, 2022 09:51 AM
    While Db2 SMP can help improve the performance of SQL & Query Workloads, it should only be used if there are system resources (CPU, Memory, Disk I/O) available to support the parallel processing of a query.  Those considerations are detailed in this Db2 for i blog entry

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



  • 9.  RE: 5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    Posted Thu December 01, 2022 01:47 PM
    If the IBM i can't handle parallel processing in 2022, it's probably time to look for a new platform honestly.

    ------------------------------
    Jeremy Bowling
    ------------------------------



  • 10.  RE: 5770-QU1 is included with the purchase of 5770-ST1 in version 7.4?

    IBM Champion
    Posted Thu December 01, 2022 08:30 PM
    Edited by Satid Singkorapoom Fri December 02, 2022 08:40 AM
    Dear Jeremy

    I'm sure IBM i can handle it but it should also be coupled with a relevant good practice to be sustainable. In the past 15 years, one of my professional focuses was IBM i and DB2 for i performance problem solving. Please let me try to share my experience that explains Kent's statement. 

    When you run a Query or SQL statement that needs to retrieve a relatively small amount of data rows from a table (physical file) with a lot of rows but without useful index for that query, DB2 for i query engine accesses the data mainly by table scan (read all rows to check each and every one) which is inefficient when the expected result set would be just some rows from among a lot more rows in the table. (This is a typical query in most customers.) Unnecessary table scan causes unnecessary disk read IO and the more of this wasted IO if there are a lot of rows. The same is true for memory faulting rate.  And if the selection criteria involves math calculation for each row, CPU power will also be wasted.  (Useful index help DB2 go directly to the desired rows which means no wasted disk IO, memory use, nor CPU power.)  All these also mean bad run-time for the query if the table is large. The larger the table (in MB), the worse the run-time.  I had many customers complaining the queries took longer and longer as years went by because the table kept growing and deleted rows accumulated without being purged. 

    If DB2 SMP is deployed for such a case, it improves run-time performance of the query because it runs multiple concurrent DB2 tasks to help with the same data access. The more concurrent tasks (parallel degree) you use, the better the run-time. But disk IO per second workload, memory faulting rate, and CPU cycles (all necessary and wasted ones) also increase as a result.  If there are very many such queries running at the same time (as in SQL-based core business application and all query type of workload), it can overwhelm the performance capacity of your server's HW (disk, memory, CPU) and cause overall performance dismay that reduces performance benefit of DB2 SMP.  I believe this is what Kent's point is about. 

    In my long experience in ASEAN geography. I found that the minority (about 20-30%) of IBM i customers in ASEAN geography were aware of the important benefit of useful indexes and used DB2 tools to create sufficient number of them for tables larger than 100MB to reduce wasted table scans and obtain decent overall query performance.  I delivered index identification and creation and training of such knowledge to customers who were not aware of this and needed help improving the overall performance. (I learned many of these skills from Kent himself!) For customers with large workload and database size, the performance improvement can be positively dramatic (for example, 3 hours reduce to half an hour or 5 minutes reduce to 15 seconds with indexes - no DB2 SMP involved yet).

    In summary, my experience tells me that it is the best practice that before deploying DB2 SMP in large Query/SQL workload and database size, sufficient useful indexes are create first, or soon after SMP deployment.  If SMP is used but sufficient useful indexes are never created, you need to count on some luck or otherwise be prepared to invest in more disk HW or memory size or more CPU cores.

    ------------------------------
    Right action is better than knowledge; but in order to do what is right, we must know what is right.
    -- Charlemagne

    Satid Singkorapoom
    ------------------------------