If you live in or around Birmingham, Alabama or Dallas, Texas or Phoenix, Arizona I will be in your neck of the woods the next two weeks speaking at the local DB2 user groups.On April 30th, 2008 I'll be speaking at Alabama DB2 User Group on the topic of Managing Data For Long Retention Periods.Then, on May 2nd, I mosey on over to Dallas to speak on two topics at the DB2 Forum meeting. I'll cover database auditing in one talk and the other will be my "famous" DB2 Top 10 Lists presentation.The following week, on May 8th, I'll be in Arizona to discuss...
Monday, 28 April 2008
Tuesday, 22 April 2008
My Most Recent DB2 Articles
Posted on 13:28 by Unknown
Today I'm posting a quick blog entry to let my readers know about a couple of recent DB2-related articles/columns that I've had published. You can always keep up-to-date on my writings by visiting my web site at http://www.craigsmullins.com/articles.htm.Any way, the following three articles might be of interest to DB2 for z/OS folks:Use Real Time Statistics to Automate Your Database Maintenance was published in the April/May 2008 issue of zJournal. This article examines Real Time Statistics (RTS) and the benefits that can be accrued by using RTS....
Thursday, 17 April 2008
The Mainframe Still Rocks!
Posted on 14:14 by Unknown
Mainframe Executive, a new publication for CIOs and IT managers in enterprises with IBM mainframe systems, just published a list of 15 reasons to stay on, or move to, a mainframe. The list is a good one, covering reliability, availability, security, resource utilization, scalability, power consumption, staffing concerns, quality, and on and on.Here is the list for those not inclined to click on the link:1. Lowest outage costs from highest platform reliability, availability, and serviceability.2. Lowest security breach risks/costs via most secure...
Thursday, 10 April 2008
Consider Table Expressions to Improve Performance
Posted on 12:11 by Unknown
Table expressions are frequently overlooked as a potential solution for resolving problems using only SQL. Table expressions can be used to force the optimizer to choose a specific processing order.For example, consider the following query:SELECT D.DEPTNO, MIN(D.DEPTNAME) AS DEPT_NAME, MIN(D.LOCATION) AS DEPT_LOCATION, SUM(E.SALARY) AS TOTAL_SALARYFROM DEPT D, EMP EWHERE D.DEPTNO = E.WORKDEPTAND E.BONUS BETWEEN 0.00 AND 1000.00GROUP BY D.DEPTNO;In this query, the detail rows that qualify from each table are joined...
Subscribe to:
Posts (Atom)
