Email Alerts
-
Database drivers on the i: MySQL vs. IBM Toolbox
Which reads data from i faster: MySQL or IBM Toolbox drivers? Joe Pluta put the drivers to the test in both an AS/400 and a Windows environment. The conclusion: MySQL over its own database performs roughly as well as IBM's Java Toolbox over DB2 data,... Tip
-
Performance tuning for IBM i: The basics and beyond
Raymond Johnson answers five reader-submitted questions about performance tuning on the AS/400. Some quick tips and tricks for performance tuning are provided. Tip
-
Dynamic memory in V5: Harness the power -- part 5: New built-in function simplifies dynamic array ha
According to iSeries (AS/400) systems management expert Ron Turull, a new built-in function (BIF) added to Integrated Language Environment (ILE) RPG in V5R3 is essential when using dynamic arrays. The new built-in function is %SubArr (sub-array) and ... Tip
-
Clean up programs and procedures to increase data and application integrity -- part 3
Here's the information you should know before employing clean-up procedures in your applications. Tip
-
Clean up programs and procedures to increase data and application integrity -- part 2
In part 1 we discussed some differences between ILE and OPM in the way programs can be cleaned up. We also were introduced to the CEERTX API (Register Call Stack Entry Termination User Exit Procedure). In this installment, we'll see this API in actio... Tip
-
Expiration of disk controller card batteries in V5R3
Expiration of disk controller card batteries in V5R3 Tip
-
Tuning the auto-tuner
The automatic performance adjustment on the iSeries can help you keep your system in step with workload changes. But if your workload changes very quickly, the auto-tuner may need some help from you. Dan Reusche shows you what you can do to assist it... Tip
-
Populating system stats
Program TJ8953R populates file TJ8953D with the same information that can be viewed with the WRKSYSSTS command using IBM's API QWCRSSTS. Tip
-
A quick way to parse spooled text files in Excel
If you want to parse spooled file rows, Excel has a tool that makes the job a snap. Tip
-
Writing to a file from CL -- revisited
Are you writing from a CL program? This tip writer explains how you can speed up the process. Tip