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
#Power
 View Only

  • 1.  Db2 for i Services - DSPJOBTBL ?

    Posted Mon October 16, 2023 05:59 PM

    Not finding any Db2 for i service that covers the job table like DSPJOBTBL does ... any plans for such a service?



    ------------------------------
    Jack Woehr
    IBM Champion 2021 - 2023
    IBM Qiskit Advocate
    ------------------------------


  • 2.  RE: Db2 for i Services - DSPJOBTBL ?

    Posted Mon October 16, 2023 08:07 PM

    We came up with

    SELECT Total_jobs_in_system,
           Maximum_jobs_in_system,
           CAST((CAST(Total_jobs_in_system AS FLOAT) / CAST(Maximum_jobs_in_system AS FLOAT) * 100) AS DECIMAL(3, 2)) AS Percent_used
        FROM TABLE (
                QSYS2.SYSTEM_STATUS()
            );



    ------------------------------
    Jack Woehr
    IBM Champion 2021 - 2023
    IBM Qiskit Advocate
    ------------------------------

    Original Message


Related Content