Monday, March 25, 2013

Bringing Control to a DB2 for z/OS Client-Server Workload (Part 2)

›
In part one of this two-part blog entry, I pointed out that the notion that one cannot control a DB2 for z/OS client-server workload as one...
2 comments:
Saturday, March 16, 2013

Bringing Control to a DB2 for z/OS Client-Server Workload (Part 1)

›
At System z sites all over the world, DB2 for z/OS workloads are growing -- often at a brisk clip. You'd think that this would be unqual...
10 comments:
Wednesday, February 27, 2013

DB2 for z/OS: What Might "Template" DDL for CREATE TABLESPACE and CREATE INDEX Look Like?

›
Recently, a DB2 for z/OS DBA sent me a question about a particular clause of the SQL DDL (data definition language) statements CREATE TABLES...
16 comments:
Monday, February 11, 2013

DB2 for z/OS: Boosting UNLOAD and LOAD Performance with Pipes and FORMAT INTERNAL

›
My colleague Jorn Thyssen, who is based in Denmark, recently let me know of some nice work that he had done in setting up a high-performance...
32 comments:
Tuesday, January 22, 2013

DB2 for z/OS Data Sharing: the Lock List Portion of the Lock Structure

›
With DB2's data sharing capability having been introduced back in the mid-1990s with DB2 for z/OS Version 4, a great many people -- incl...
14 comments:
Wednesday, January 9, 2013

DB2 for z/OS: An Interesting "Flip Side" to Native SQL Procedures

›
I heard the other day from a DB2 for z/OS DBA who communicated to me an interesting story. His organization had recently gotten into develop...
16 comments:
Friday, December 28, 2012

DB2 for z/OS: Clearing Up a Native SQL Procedure Misconception

›
A few days ago I received a question that I believe reflects a rather widely held misconception about DB2 for z/OS native SQL procedures. In...