WLM Balancing Initiators In Sysplex

(Originally posted 2005-03-09.) Here’s the gist of an Info APAR on the subject: OA10114. This documentation APAR was taken to enhance the information in the WLM Planning book to more clearly state that the intent of the WLM Managed Batch Initiator Balancing enhancement is not to evenly distribute the batch workload among systems in theContinue reading “WLM Balancing Initiators In Sysplex”

DB2 Fix for Star Join

(Originally posted 2005-03-09.) PK01266 enables parallelism in Star Join under an additional set of circumstances: From the APAR Database: STAR JOIN QUERY ON NON-PARTITIONED FACT TABLE DOES NOT GET CPU PARALLELISM CHOSEN WHEN MULTIPLE CPUS ARE AVAILABLE Starjoin queries with non-partitioned fact table can encounter poor performance since CPU parallelism may not be enabled. TheContinue reading “DB2 Fix for Star Join”

A question for those of you that send data into IBM

(Originally posted 2005-02-24.) I’m investigating FTP support for our process. That would mean allowing customers to send their data via FTP to either of two IBM-owned sites: One in Mainz, Germany and the other in Boulder, Colorado. The question is: Is it easier for customers to send data via FTP? Or on tape? I’m thinkingContinue reading “A question for those of you that send data into IBM”

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”