As regular readers of my blog know, I sometimes use the blog to answer questions I get via e-mail. This is one of those times...The question I received is this:Can you bring out the major differences between QMF and SPUFI?Here is my response:The biggest difference between QMF and SPUFI is that QMF is a query/reporting environment with the ability to format reports. SPUFI is just a quick and dirty SQL execution engine.(Here is a trivia question: what does the acronym SPUFI stand for? The answer is provided at the bottom, so page down if you want...
Wednesday, 28 February 2007
Tuesday, 27 February 2007
Dynamic SQL and Performance
Posted on 12:00 by Unknown
The performance of dynamic SQL is one of the most widely debated DB2 issues. Some shops try to avoid it, but in this day and age of ERP/CRM systems, Java/JDBC programming, and web applications, all of which heavily rely on dynamic SQL, its use is becoming more ubiquitous.Still, many shops that allow dynamic SQL try to place strict controls on its use. But as new and faster versions of DB2 are released, many of the restrictions on dynamic SQL use can be eliminated.I suppose that you can still find some valid reasons for prohibiting dynamic SQL....
Wednesday, 14 February 2007
A Report From SHARE
Posted on 08:42 by Unknown
As regular readers of this blog know, I regularly attend and speak at the SHARE user conferences held twice annually. The Spring 2007 SHARE conference is being held this week, February 12 thru 16, 2007, in Tampa, Florida. It is now Wednesday, mid-way through the week, and time for me to post a quick update of what is going on at SHARE, from a DB2 point of view.First of all, I’ve been privileged to deliver two presentations this week. The first is one of the perennial favorites called “A DB2 Performance Tuning Roadmap.” I’ve been delivering this...
Monday, 5 February 2007
See You at SHARE?
Posted on 13:07 by Unknown
Well, it is that time of the year again... that is, time for the first of two annual SHARE conferences. The "Spring 2007" SHARE will be held next week, in Tampa, FL.For those of you who don't know about SHARE, it is an independent, volunteer-run association for IBM customers. It is not only mainframe-focused, but it is one of the last events mainframe folks can attend to hear about mainframe topics from z/OS to JES and from CICS to IMS to DB2.I will be presenting on Monday (2/12) and Tuesday (2/13). On Monday I will cover a DB2 Performance Tuning...
Subscribe to:
Posts (Atom)
