Tuesday, September 30, 2014

DB2 for z/OS: DDF, Stored Procedures, and SET CURRENT PACKAGESET

›
Recently, I was talking with people from a company's IT department about modernizing their mainframe application architecture.Among othe...
2 comments:
Friday, September 26, 2014

DB2 for z/OS: Avoiding zIIP Engine Contention Issues

›
In an entry posted a few months ago to this blog, I touched on several matters pertaining to mainframe zIIP engines and the use of these pr...
Friday, August 29, 2014

DB2 10 for z/OS, 1 MB Page Frames, and the Number 6656

›
I recently received an interesting message from a mainframe DB2 person I've known for a long time. At his DB2 10 for z/OS site, 1 MB pag...
6 comments:
Monday, August 25, 2014

DB2 for z/OS: Can a Pooled DBAT Hold Locks?

›
The answer to the question in the title of this post is, "No, it can't -- unless it can." How's that for a hook? OK, a l...
3 comments:
Tuesday, July 29, 2014

Isolating DB2 for z/OS Accounting Data at the WebSphere Application Level

›
Back in the 1990s, almost all of the DB2 for z/OS-accessing transactional applications I encountered were of the CICS variety. Often, a give...
4 comments:
Wednesday, July 16, 2014

DB2 for z/OS Buffer Pool Enlargement is NOT Just an Elapsed Time Thing

›
A couple of weeks ago, I got a question from a mainframe DB2 DBA about the impact of DB2 buffer pool enlargement on application and system p...
Thursday, June 26, 2014

DB2 for z/OS: the Functional Advantages of Native SQL Procedures

›
I have been a big fan of DB2 for z/OS native SQL procedures ever since the functionality was introduced with DB2 9 , back in 1997. I have po...