In the first tip of this series, I covered three new features introduced in DB2 for i 7.2: ALTER TRIGGER, TRUNCATE TABLE, and the ability to vary the fractional precision of a TIMESTAMP column. This tip continues the adventure by exploring a few more new features in IBM i 7.2 (in no particular order).

KEEP IN MEMORY Clause For Tables And Index

When creating a new index or table, a new KEEP IN MEMORY clause is available to tell DB2 to keep the data in main storage when possible. (A table or index cached in this manner should, of

Next to Barbara Morris, the job log is the IBM i professional’s best friend. However, even though job logs give useful information, they don’t always tell us everything we need to know to diagnose job failure. A recent email from perspicacious reader Daniel Long reminded me that sometimes we have to help ourselves.

A job log can tell us when a job started and ended, the list of libraries at its disposal, the CL commands and programs it ran, the messages those programs sent, etc. The one thing the job log does not show us, and how I

We’re consolidating our IBM i partitions on another Power 7+ machine that belongs to my parent company. They want to move and install some special-purpose user profiles from of their partitions to one of our partitions. What’s the best way to port a user profile from one partition to another?

–Tim

You have two choices here. 1) You can either take a printout of the user profiles in question and manually recreate them on your target machine; or 2) You can back up and restore the user profiles from one machine to another.

My preference is to back up and