Retrieving the CPU usage information via SQL

One of the many additions to the last release and Technology Refresh, IBM i 7.5 and 7.4 TR6, was a SQL View that returns one row of results of the usage of the CPU.

To most people it may not sound the most interesting information, but I have been asked if there was a way to get to this information so it could be written to an outfile, by a couple of people. Previously the only way I knew how to show the information was the Work with System Activity command, WRKSYSACT.

Work with System Activity DEV750
DD/DD/DD TT:TT:TT
Automatic refresh in seconds . . . . . . . . . . . . . . . . . . . 5
Job/Task CPU filter . . . . . . . . . . . . . . . . . . . . . . . . .10
Elapsed time . . . . . . : 00:00:02 Overall CPU util . . . . : 80.1
Overall SQL CPU util . . . : 30.4
Average CPU rate . . . . . : 101.2
Current processing capacity: 1.00
Read more »

Talsco Weekly: A different take on the Cloud

Welcome to another edition of Talsco Weekly

Cloud:  A different take on the Cloud.
Learning:  A Three-Step Learning Model.
Development:  What is a full-stack developer?
IBM i Update:  Navigator Updates.
Open Source:  The future of rendering in React.

Cloud

A different take on the Cloud

A well-known project management software company, Basecamp, has been running partially in the cloud (hybrid) for more than a decade.

And now, they are thinking about leaving.

They run:

“extensively in both Amazon’s cloud and Google’s cloud. We’ve run on bare virtual machines, we’ve run on Kubernetes. We’ve seen all the cloud has to offer, and tried most of it.

In their case, they have concluded: “Renting computers is (mostly) a bad deal for medium-sized companies like ours with stable growth. The savings promised in reduced complexity never materialized.”

Does this mean having the cloud as part of your solution is wrong?

Of course not. But it highlights that just because you can go to the cloud does not mean you should.

The article goes on to point out that the “cloud excels at two ends of the spectrum.”

The “first end”: “is when your application is so simple and low traffic that you really do save on complexity by starting” in the cloud.
The “second end”: “is when your load is highly irregular.”

There is a “perception that the cloud is simpler, set it and forget it,” but is that really true?

“Some things are simpler, others more complex, but on the whole, I’ve yet to hear of organizations at our scale being able to materially shrink their operations team, just because they moved to the cloud.”

So, how does this apply to “IBM i customers”?

This is where it gets more complex.

It’s one thing to talk about the benefits of the cloud vs on-prem when it comes to new software or an application. But how does one determine the cost and benefits when it comes to the mix of applications that are found in an organization that has been in business for thirty or more years?

Most organizations have:

Custom ERP Systems (sometimes more than one)
3rd Party ERP Packages
EDI Systems
Data & Data warehouses
Custom or packaged WMS Systems

Companies are taking a “hard look at the value of running” their own powerplant vs the cloud. While much of the same “tooling that enabled the cloud is available for your own machines,” there is also value in migrating some workloads to the cloud.

What do you think?

Learning

A Three-Step Learning Model

As the IBM i ecosystem continues to develop and evolve, the future IBM i Developer will be asked to do more than develop RPG applications. The ability to pick up on new technologies will be essential.

Here is a Three-Step Learning Model, which is “a simple, yet powerful framework for learning anything new.”

Overview:

“Read & Research: Start horizontal for breadth and then go vertical for depth. Take your time in the initial research phase.”
“Teach: Distill the learnings into a teaching session for a group of uninitiated students.”
“Assess & Iterate: Reflect on the questions asked by the students to highlight the gaps in your knowledge. Iterate on the process to close those knowledge gaps.”

Learn more about it “here.”

Development

What is a full-stack developer?

“A full-stack developer creates and deploys the front-end and back-end elements of a website, web application, or computer program.”

“Full-stack developers are responsible for converting the elements of web design into executable code; coding the server-side elements of a web product; working with different programming languages and technologies to develop websites, web applications, or computer programs; and modifying and testing web products or software.”

IBM i Update

Navigator Updates

“The Technology Refreshes have brought IBM closer to completing the transition to the new Navigator from the old Navigator product, which is susceptible to the Log4j security vulnerability. While the advances in IBM i 7.5 TR1 and 7.4 TR7 will help customers, the new Navigator product will still not be at feature parity with old Nav when the plug is pulled on the heritage product at the end of the year.”

IBM “has been encouraging its IBM i customer base to accelerate its adoption of the new Navigator,” and there is good reason for it. There are a number of updates that offer value.

The “new Nav” is entirely new.

Instead of a Java code base, it is now writing with “Angular and JavaScript, which provides a much snappier Web experience for customers.” The UI is much better too.

There are many reasons to be proud of the newer Nav:

Fully embraces the use SQL-based IBM i services
“Users can now see information about IASPs for each monitored system on their Navigator homepage and in Work Management tables and panels.”
“Integration with Performance Data Investigator (PDI) improves with this release.”
“The System Monitor Visualization panel from older Navigator has been recreated.”
“There is a new audit configuration screen that lets a user see different auditing actions available and whether it’s enabled or disabled.”
Intrusion detection capability has been added.
“Better network monitoring and management capabilities”

While there have been a number of changes, there is much more in the works.

Find more of the details here.

Open Source

The future of rendering in React

React and other UI tools are becoming more common in the IBM i community. It’s important to keep up to date as well as familiarize yourself with the tooling.

This article looks “at React’s current rendering patterns, their problems, and how the new patterns introduced with React 18 aim to fix those problems.”

Join

Sign up for Talsco Weekly to get the latest news, insight and job openings for the IBM i professional.

Contact us

If you are an RPG programmer looking to explore opportunities or a client who is looking for a talented IBM i professional, please contact us. We look forward to assisting you.

Share

Do you know of someone who could benefit from Talsco Weekly? If so, please use the social media buttons to spread the word. Thank you!

The post Talsco Weekly: A different take on the Cloud appeared first on IBM i (AS/400, RPG) Recruiting, Staffing & Consulting.

October 2022 Newsletter

This newsletter includes:

Function Junction – Securing Applications
The Grass is Always Greener Over The Septic Field – An Argument for Modernization Over Replacement
CHGJRN, CPF7018, and WRKCMTDFN
[NEXT WEEK] Register Now: iAdmin Fall 2022
iTech iTip Videos
Sips & Tricks: Coffee with iTech
iBasics: IBM i Education for the Beginner System Administrator
Watch Replay: Tactical Security Day
iPOWER Hour Episode 40: Security Vulnerabilities on Your IBM i
Upcoming Events
IBM i, FSP, and HMC release levels and PTFs (October 2022)

It’s Autumn in Connecticut, and there is no place prettier with the rolling hills of orange, yellow, and burnt red leaves as far as the eye can see, but underneath that beautiful landscape is the changes that will take place as we head into winter. There are lots of changes, and one that you might have seen with our integration into Service Express is the changing of our email addresses.

Only the domain name has changed from itechsol.com to serviceexpress.com, it is still our first initial followed by our last name. Our old email addresses are currently being forwarded to our new email addresses.  Other than that, you shouldn’t have noticed anything else changing in the services that we provide, or the support you have been used to all these years.  And that is a good thing and what I would have expected.   Of course, we now have additional offerings, and soon a few more people.  If there is something that you aren’t happy with the integration, let me know so that I can look into it and get it resolved.

iAdmin Fall 2022

Our iAdmin Fall 2022 is just days away, are you registered yet?  There is still time. This will be the same quality conference we have done in the past, and it will be packed with information, provided by your IBM i team here at iTech (now a Service Express company) who know what to do, when to do it, and how to do it when it comes to IBM i. You have heard me say it many times, we have the experience, the knowledge, and the know-how. So, why are you still with your business partner?

The dates for iAdmin Fall 2022 are November 2nd and 3rd, and as you can see from the agenda, this is an event you won’t want to miss.

This is a $1,500 conference and we

The post October 2022 Newsletter first appeared on iTech Solutions Group.

Verified by MonsterInsights