performance data investigator Archives

IBM Publishes Power10 Performance Optimize Guide

December 7, 2022 Alex Woodie

IBM i shops looking to squeeze the most performance out of their Power10 servers have a lot of options available at their disposal. IBM covers many, if not all, of them in its latest performance paper, titled “IBM Power10 performance optimization for IBM i,” which it released last week.

The Power10 is the most powerful processor IBM ever built. Compared to the Power9 processor, the Power10 delivers 20 percent to 30 percent higher performance per core. And with 25 percent more cores per socket, that means oodles of more processing power to do useful work.

At a system level, the …
Read more
COMMON Set for First Annual Conference in Three Years

May 18, 2022 Alex Woodie

Don’t look now, but COMMON is about to hold its first annual conference in three years. Starting on Monday in New Orleans, POWERUp 2022 will be the biggest gathering of the IBM i community since the pandemic started more than two years ago. There is still time to register for the conference, which will feature a raft of presentations on the newly released IBM i version 7.5.

COMMON’s annual conference scheduled for the New Orleans Marriott next week is shaping up to be a good one. More than 100 speakers are scheduled to present more than 300 sessions on …
Read more
Guru: IBM i Experience Sharing, Case 2 – Dealing With CPU Queuing Wait Time

March 21, 2022 Satid Singkorapoom

When we drive our cars, we hope to avoid red lights and traffic jams, because we all hate waiting immobile in traffic. I’m sure that you are aware, fully or subtly, that active jobs in any computer system can encounter wait as well. The IBM i developer team has categorized many types of wait.

In this article, let’s look at CPU Queuing wait time. Let’s see how we can interpret and address it in a sensible way to resolve poor performance. I’ll try to provide you with a useful approach to wait time analysis using a gloriously useful performance reporting …
Read more
Guru: Understanding Database Performance Using The Performance Data Investigator, Part 2

June 28, 2021 Dawn May

This is the second in a two-part series on how you can use the Performance Data Investigator (PDI) to investigate performance of Db2 for i. While the SQL Performance Center in Access Client Solutions is more commonly known than PDI, using both tools is a good way to analyze database performance.

In Part 1, I reviewed the Database content package, focusing on the charts for I/O reads and writes, SQL CPU utilization, and database locks. In this tech tip, I continue by reviewing the charts related to SQL Cursor and Native DB Opens as well as the SQL Performance …
Read more
Guru: Understanding Database Performance Using The Performance Data Investigator, Part 1

June 21, 2021 Dawn May

This is a two-part series on how to use the Performance Data Investigator (PDI) for investigating performance of Db2 for i. While the SQL Performance Center in Access Client Solutions is the tool of choice for Db2 performance analysis, there is valuable information that you can get from using PDI. PDI is often a useful starting point to help guide you in the correct direction when trying to identify performance issues. In my experience, PDI is under-utilized for Db2 investigation. For those not familiar with PDI, you may want to read the article, Getting Started with the Performance Data Investigator …
Read more
The Ultimate Set Of Tools

December 14, 2020 Rob McNelly

Those of a certain age will certainly remember the moment in Fast Times At Ridgemont High when Jeff Spicoli got himself into a bind after he wrecked his friend’s car. Luckily, Spicoli’s dad was a TV repairman, and he had an ultimate set of tools. Spicoli knew that with those tools, he could fix it. That level of confidence is intoxicating, although in this case it was possibly misplaced.

I have a friend that lives around the corner from me that actually does have the ultimate set of tools, and knows how to use them. For example, he recently rebuilt …
Read more

Content archive

Recent Posts

Subscribe

Pages

Search

IBM Publishes Power10 Performance Optimize Guide

COMMON Set for First Annual Conference in Three Years

Guru: IBM i Experience Sharing, Case 2 – Dealing With CPU Queuing Wait Time

Guru: Understanding Database Performance Using The Performance Data Investigator, Part 2

Guru: Understanding Database Performance Using The Performance Data Investigator, Part 1

The Ultimate Set Of Tools

Content archive

Recent Posts

Subscribe

Pages

Search