-
Tales from the AS/400 crypt
You can smash it, flood it and even run a forklift through it, but the AS/400 (iSeries) keeps on running. These true tales illustrate just how reliable the 400 is.
-
Simple check for IFS object
Learn a simple way to check for the existence of an IFS object --without having to dig into IFS APIs.
-
Information Security Best Practices
This chapter addresses best practices for setting up security within operating systems.
-
Simple CHKOBJ for a file in the IFS
Here's a method to discover if your file, folder or other IFS object exists in the IFS -- without getting into custom commands and system API's.
-
Limiting result sets
The FETCH FIRST and OPTIMIZE FOR clauses are best for limiting the amount of rows if the result set is big.
-
Using CMPPFM for more
Learn how you can use CMPPFM for more than just comparing source members.
-
Know all fields and tables on your iSe
Need to search one field or one file? Learn how here.
-
Converting Julian dates
Learn how to converting Julian dates on SQL.
-
Track response times with WRKACTJOB
Using the Work with Active Jobs screen you can see detailed performance data for each job listed.
-
Useful columns on WRKACTJOB screen
The right-hand side of the Work with Active Jobs screen contains some other columns of interest. Here's a brief summary.
-
Simplifying individual object restores
Having a method for quick and easy restore for individual objects is important in the overall security plans for your shop.
-
Edit value using edit code 'X'
Converting numbers to characters.
-
Display changed source records
Display only certain records in SEU, in particular, records changed after a certain date.
-
Splitting DB2 transactions
Here's how to split large SQL jobs into more manageable smaller ones on DB2.
-
Showing fields with SQL
Locate the field you want quickly with SQL.
-
List IFS directory
Learn how to process the contents of an IFS directory.
-
Old recs for WRKACTJOB no longer true
Over the years there have been changes to the way WRKACTJOB works. What was once true for DSPACTJOB on System/38 is no longer true for WRKACTJOB.
-
Lessen your interactive load
If your apps have sections that use a lot of CPU, make those subroutines separate programs. Then the heavy work can be done in batch via client/server and returned to the program.
-
Formatting the date with SQL
Here's a simple way to provide formatting for dates in DB2.
-
Let the iSeries page you
Let the iSeries page you if a problem arises.
-
V6R1 upgrade planning checklist
When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been installed.
-
Connecting multiple iSeries systems through DDM
Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed data management (DDM).
-
Preventing IBM i data theft
A firewall should be the first line of defense to protect your IBM i system, but not the only security measure you take. Rich Loeber counsels you to not ignore the enemy within. Build strong object...
-
A power-handling CL program for multiple IBM i servers
Rather than connecting your AS/400's to their own separate UPSs, find out how one UPS, one cable and a CL program can manage all your power-handling needs.