In The Spotlight
SMP causes long-running queries to complete faster but consume more resources. Therefore, SMP shouldn’t be used in all situations; consider carefully how SMP is applied in your environment.
By Sarah Mackenzie
By default, when a query is run, only a single process is used to run the query. Db2 Symmetric Multiprocessing (SMP) allows queries to use multiple, parallel processes when running a query in order to complete faster. This is achieved by allowing the database to use multiple CPUs and I/O processors to work on the query at the same time. SQL queries, OPNQRYF, Query/400, index creation and maintenance, and reorganizing of physical files can all take advantage of SMP. This powerful tool can result in these operations running more quickly but will cause increased consumption of main storage, CPU, and disk resources. Therefore, SMP isn’t always the best choice, and it’s important to choose wisely how and when to use SMP.
Data, it seems, is never quite in the form we need. We perform operations on our data to convert it to the form we want. Free-format RPG IV offers a variety of methods for transforming data to suit our requirements.
By Jim Martin
Editor's Note: This article is excerpted from chapter 8 of Free-Format RPG IV: Third Edition, by Jim Martin.
In this excerpt series, we explore those options, which include assignment statements, a large stable of built-in functions, and operations for converting dates and times.
The sensational media stories following the release of Open AI’s GPT-4 continue, but the theme that it's about to—or already has—plunged the world into the "Singularity" is being quietly undercut by efforts in the EU and the US to regulate AI in general.
By John Ghrist
Many popular and business media outlets have recently gone overboard in predicting the end of civilization at the hands of this useful but humble chatbot. While it’s fun to scare ourselves with spooky stories from time to time, this deluge is starting to give AI in general an undeserved bad rep. A useful antidote is to look at the slew of laws and regulations—some already on the books, some merely pending—that can assure the sober-minded that responsible people are aware of the dangers and are acting to do something about it.
The Project Proposal has been approved. What next? The project must now be defined in greater detail.
By Colleen Garton and Erika McCulloch
Editor's Note: This article is excerpted from chapter 4 of Fundamentals of Technology Project Management, by Colleen Garton and Erika McCulloch.
The project definition includes the creation of:
- The Project Charter
- The Marketing Requirements Document (MRD)
- The Budget
- The Statement of Work (SOW)
The flowchart in Figure 4.1 shows the project definition workflow process from the proposal being approved through to project approval.
Current Events All Events
October 9 - 11 2023 | Virginia Beach, VA
Join COMMON in Virginia Beach, VA from October 9 - 11, 2023 for an IBM i educational event. NAViGATE will feature 100+ sessions presented by industry expert speakers, an Expo of leading solution providers in the IBM i space, and limitless networking opportunities to connect with peers and experts to
NAViGATE 2023 is COMMON's Fall conference, providing you with 2.5 days of leading IBM i education, including on the new releases and announcements.
The conference will take place as an in-person event in Virginia Beach, VA. All attendees will enjoy 2.5 days of leading education on the latest IBM i and related topics, consisting of 100+ sessions presented by industry expert speakers.
As with every COMMON conference, it will offer an Expo of leading solution providers and unique in-person networking opportunities allow attendees to interact with peers, share knowledge, and continue learning
Benefits of Attending
- You will enjoy high-quality education and exciting networking opportunities in person in a conference environment that will follow CDC and local COVID guidelines.
- Access to 100+ sessions on the latest IBM i and related topics.
- Sessions will be presented by industry expert speakers, presenting live in person.
- Network with speakers throughout the conference for additional help and get your questions answered.
- Meet and network with other attendees throughout the conference, while attending the Welcome Reception, or while enjoying lunch in the Expo.
- Exhibitors will be present in-person in the Expo where you can continue learning and networking.
- 09 October 2023 - 11 October 2023
- Marriott Virginia Beach Oceanfront
- 332 South Michigan Avenue Unit LL – C12 Chicago, IL 60604
Support MC Press Online
Support MC Press with a contribution of any size.
Your support helps MC Press deliver free quality information about the new and legacy technologies you rely on to IT Professionals everywhere. Our goal continues to be helping you become more productive on the job and get more out of your career. Every contribution, regardless of size, furthers that goal.