Skip to Main Content
IBM Power Ideas Portal

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Start by posting ideas and requests to this portal to enhance a Power product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas and add comments to ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The Power teams will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.


Specific link you will want to bookmark for future use

IBM Unified Ideas Portal - https://ideas.ibm.com/ - Use this site to create or search for existing Ideas across all IBM products that are outside of Power, and track all of your personal interactions with all Ideas.

Status Future consideration
Workspace IBM i
Categories Performance Tools
Created by Guest
Created on May 19, 2020

Generate performance reports based on *HSTFILE, and also have the possibility of automate report generation if possible.

I would like to be able to generate reports based on historical data, and also be able to automate it's generation.


Use Case:

For instance, generate reports on the 1st of each month for the previous months, for CPU utilization, disk arm usage, disk response times and fault rates.


Idea priority Medium
  • Guest
    May 24, 2020

    Hi

    I agree, having a scheduler to produce collections of these performance reports would be a great idea.

    I wanted to check that you knew you can write your own, all PDi graphs including the Graph History ones have an option to show you the SQL that was used to generate the graph. You can take this SQL and use your own job to generate it. An example at the bottom of this comment.

    Hope this helps. #StaySafe
    Steve B
    IBM Champion, CEAC Member and Technical Director of i-UG.co.uk

    /** Historic Composite chart: CPU Utilization (Overview) */
    SELECT QSYS.DATETIME AS DATETIME,
    SYSSPTU,
    SYSCTA,
    COLPCTCPU,
    SYSPTU,
    COLPCTSCPU,
    SPURR_PURR_RATIO,
    CASE
    WHEN QSYS.NUM_DATA_POINTS > 1
    THEN 'NO'
    ELSE 'YES'
    END AS "IS_SINGLE_POINT",
    CASE
    WHEN QSYSDET.DATETIME2 IS NULL
    THEN 'NO'
    ELSE 'YES'
    END AS "HAS_DETAILED_DATA"
    FROM (
    SELECT MIN(DATETIME) DATETIME,
    AVG(SYSSPTU) AS SYSSPTU,
    AVG(SYSCTA) AS SYSCTA,
    AVG(SYSPTU / DOUBLE (SYSCTA) * 100) AS COLPCTCPU,
    AVG(SYSPTU) AS SYSPTU,
    AVG(SYSSPTU / DOUBLE (SYSCTA) * 100) AS COLPCTSCPU,
    AVG(DOUBLE (SYSSPTU / SYSPTU)) AS SPURR_PURR_RATIO,
    COUNT(*) AS NUM_DATA_POINTS
    FROM QPFRHIST.qapmhmsyst
    WHERE DATETIME >= '2020-04-24 00:00:00'
    AND DATETIME <= '2020-05-24 00:00:00'
    GROUP BY YEAR(DATETIME),MONTH(DATETIME),DAY(DATETIME),HOUR(DATETIME) / 6
    ) QSYS
    LEFT JOIN (
    SELECT DISTINCT j.DATETIME AS DATETIME2
    FROM QPFRHIST.QAPMHDJOBM j,
    QPFRHIST.QAPMHMSYST s
    WHERE s.DATETIME = j.DATETIME
    ) QSYSDET ON QSYS.DATETIME = QSYSDET.DATETIME2
    ORDER BY DATETIME