Sometimes using SQL to perform simultaneous inserts, updates and deletes against related tables can be a chore. It would be convenient if programmers could simply treat related tables as a single table for the purpose of modifying data.

For simplicity, consider the following common scenario: An iSeries has multiple item tables holding data related in a one-to-one relationship. Often, this scenario is due to multiple application packages having item master files that are both populated with common item data. The illustration in Figure 1 below shows an item master table from Application A along with a supplemental custom item extension

I followed your directions explicitly regarding your instructions to me as to how to install WebSphere Application Server 6.0 on our new i5. I must admit that the process was so foreign to me that I had no clue as to what was happening, but by following your directions it all seemed to work. But I still have a problem.

You don’t know how happy I was when well after an hour of running that QSHELL SCRIPT to install WAS 6.0 Express, it finished scrolling all its messages and it made me feel that all was well. To be sure,

We recently installed an i5 520 machine. We also experienced a power failure that lasted longer than our UPS could sustain, and the system wound up ending abnormally. Do you know how to set up an i5/OS system so that it automatically shuts down its partitions during a power failure? I have searched the IBM knowledgebase in vain.

— From the IT Jungle Forums

Yes, IBM provides a way to do this with the Uninterruptible Power Supply Delay Time system value (QUPSDLYTIM). According to IBM, this value is available for several different versions of the OS/400 and i5/OS operating system,