With a new OVRDBF feature, you can override the REUSEDLT(*YES) attribute of a physical file or table and effectively use the behavior of REUSEDLT(*NO).

Written by Fernando Echeveste

If your application inserts a large volume of rows into DB2 for i tables, the following features found on IBM i can influence the performance of your application:

Are you in a quandary because DB2 Web Query can't use *libl to find your stored procedure's synonym? Yes, it can!

Written by Anita Corcoran

In a previous Tech Tip, "Use a Stored Procedure as Your Data Source in DB2 Web Query for i," I discussed using a stored procedure as the data source in DB2 Web Query for i. Using a stored procedure as your data source offers many benefits to you as a developer: 

Build queries with optional input parameters using existing business logic.

Written by Anita Corcoran

Do you need the ability to build queries with optional input parameters? Do you need your queries to use existing business logic? Did you know you can accomplish both goals by using a stored procedure as your data source in DB2 Web Query?

New enhancements from IBM minimize disk activity and disk storage requirements.

Written by Kent Milligan

As documented in a previous TechTip, the Database Monitor is a great tool for collecting SQL performance data. However, you must apply great care when using this tool because it can cause significant disk activity on your system and quickly consume disk space. Recently, IBM introduced enhancements to minimize the disk activity and disk storage requirements associated with database monitor collections.

Both a primer and a reference, this book is a must-have for anyone who wants to program in PHP.

By Mike Pavlak

After developing Web solutions for the iSeries in Net.Data and then getting a sour taste from Java, I wanted something better. PHP was certainly the right choice, but making it run on an iSeries at the time was no small feat. Then Zend came to the table, and the rest, as they say, is history. There is no way any of us on the ground floor of this amazing union could have anticipated this level of excitement and interest. We continue to see huge numbers being drawn to PHP on IBM i as well as Linux, UNIX, and Windows. And this book comes at just the right time; it's both a primer and a reference.

Is your BI solution hard to install and difficult to use?

By Floyd Del Muro 

Is your data out-of-date and your report backlog still a backlog? Is your BI technical department larger than two people, and do they spend most of their time redefining your data to make the solution work? Does your technical team spend hours upon hours installing program fixes? Does your solution work with only one database, and is it too complicated to allow end users to write their own inquiries? Do you have to pay more any time you want to do more? Is your BI solution meeting your needs?

The overhead that a monitor can place on disk and I/O subsystems is no longer the problem it used to be.

By Kent Milligan

Starting a Database Monitor on your server is quite simple, whether you're using the STRDBMON CL command or the System i Navigator graphical interface. The challenging part of a Database Monitor is minimizing the overhead that a monitor can place on disk and I/O subsystems while it's writing the collected data.