In today’s Web application environment, notices and error messages that appear in a Web server’s logging files can be easily lost or missed. This exposes you to missing important information that you may need to know.

The Web Log Monitor gives users the capability to monitor the contents of log files for any Web-related server, including the Integrated Web Application Server, Integrated Web Services Server, WebSphere Application Server, WebSphere Portal Server, and IBM‘s HTTP Server.

Users can set rules for the Web Log Monitor. If a situation matches the rule parameters, the monitor sends a notification to:

• The *QSYSOPR

The DISTINCT keyword is a great example of the power of the SQL SELECT statement. Add this powerful word to any SELECT command and voilà! Duplicate rows magically disappear. Comments from readers have alerted me to the fact that some people find use of this feature confusing. Here are a brief discussion of DISTINCT and a performance tip.

Given a table (physical file) of sales order information and a table of customer information, how do I go about finding the account numbers of customers who have orders in the database? We could try this:

select s.companyno, s.customerno
  from salesordh as 

After we upgraded our production system to new Power i hardware, the Last used date on all our system objects was reset to zeros. While this isn’t a major problem, it does mean that we are no longer able to identify obsolete objects and files on our system. If we can’t identify them, then we can’t remove them. Is there any way to get this information back?

–Bert

Thanks, Bert. Unfortunately, if you migrated your existing production partition to a new system and restored all the objects to that system, all your objects’ Last used dates are gone. Here’s how