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:
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,
Post an idea
Upvote ideas and add comments to ideas that matter most to you
Get feedback from the IBM team to refine your idea
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.
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.
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.
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