PDI Archives - IT Jungle

New Nav Puts SQL Services Within Reach

September 15, 2021 Alex Woodie

IBM delivered new Technology Refreshes (TRs) for IBM i 7.3 and 7.4 last week, and there’s a lot of good stuff in there. Arguably one of the biggest announcements is the overhaul of IBM i Navigator, which the folks at IBM have taken to calling “New Nav.” But what makes New Nav so special?

IBM rewrote New Nav from the ground up in Angular, a JavaScript framework for building Web and mobile applications, and PrimeNG, a popular component library for Angular. The combination of these two technologies gives New Nav a fresh-looking interface that will appeal to users of all …
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
Guru: Health Indicators

January 28, 2019 Dawn May

In Configure Collection Services, I reviewed how you can improve the configuration of Collection Services. In this tip, I’m going to demonstrate how to easily review your Collection Services data and understand your partition’s performance characteristics using the Health Indicators.

Navigator for i has a rich set of performance tasks, one of which is Investigate Data, also referred to as the Performance Data Investigator (PDI). The base operating system allows you to manage and visualize Collection Services data. The Performance tasks (and PDI) also support other types of performance data, but those graphical features require installing the Performance Tools …
Read more

Content archive

Recent Posts

Subscribe

Pages

Search

New Nav Puts SQL Services Within Reach

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

Guru: Health Indicators

Content archive

Recent Posts

Subscribe

Pages

Search