Processing DB2 Unload / DSNTIAUL data with DFSORT – VARCHAR Fields

(Originally posted 2005-02-21.) In our process we unload the DB2 Catalog with DSNTIAUL and then use the resulting files in our analysis. When prototyping new code, or just plain trying different queries out, we use DFSORT. However VARCHARs pose a bit of a problem, encoded as they are with a 2-byte length and padded withContinue reading “Processing DB2 Unload / DSNTIAUL data with DFSORT – VARCHAR Fields”

Time to get creative

(Originally posted 2005-02-20.) Well, now I’m on the agenda at these two conferences I’m confronted with the task of actually getting 4 presentations out the door by March 4th. Thankfully Three are updates of existing presentations, varying in effort quite considerably. Two are shared between the two conferences Of course it doesn’t help that theContinue reading “Time to get creative”

DFSORT Processing SMF Records

(Originally posted 2005-02-18.) It’s going to sound like the only thing I talk about is DFSORT. While that isn’t entirely true I am currently updating my “What’s New With DFSORT?” foils. And it made me think about processing SMF data… In our internal analysis processes we chuck SMF data around quite a bit, whether subsettingContinue reading “DFSORT Processing SMF Records”

Not Your Grandfather’s DFSORT

(Originally posted 2005-02-17.) I’ve had a long and happy association with DFSORT. So here’s a link to a document describing the most recent enhancements, which came out in December. http://www-1.ibm.com/servers/storage/support/software/sort/mvs/pdug/ There was also another significant set of changes in February 2003. They are described here: http://www-1.ibm.com/servers/storage/support/software/sort/mvs/uq90053 As I previously mentioned I’ll be presenting “What’s NewContinue reading “Not Your Grandfather’s DFSORT”

zSeries and Storage Technical Conference, Innsbruck, Austria 11-15 April 2005

(Originally posted 2005-02-17.) I’m fortunate to be presenting at this excellent conference. Here’s the URL: http://www-306.ibm.com/services/learning/ites.wss?pageType=page&c=a0006121 There are many fine presentations on the agenda. My presentations are in the areas of DB2 Memory, CPU Management, “Modern” DB2 Applications’ performance, and DFSORT. All of these are significantly updated from previous conferences, and the CPU one isContinue reading “zSeries and Storage Technical Conference, Innsbruck, Austria 11-15 April 2005”

To blog or not to blog?

(Originally posted 2005-02-17.) For me that isn’t really the question – I’ve been blogging inside IBM for about a year now. And the benefits are well-known to me. So welcome to my customer-facing blog. I do like to mention client situations. But (especially as I’m helping develop IBM’s blogging guidelines in this area) I’d likeContinue reading “To blog or not to blog?”