Assembler : Getting DB2 Traces Started to OPn
Published July 29th, 2013 - by James Gill
In the previous post I talked about getting our assembler monitor connected to DB2 for z/OS with the intention of getting some statistics traces running and gathering the data cut by DB2. This time we’re going to look at how we actually got the traces running. As you’ll know from your extensive reading of Continue Reading
DB2 for z/OS Connectivity Testing
Published December 3rd, 2012 - by James Gill
One of the challenges that customers face is validating the DDF configuration of a new service before making it available to mid-range application servers. In an ideal world, we’d all have DB2 Connect available to bash a quick configuration together and use the command line processor to connect and run some simple SQL as Continue Reading
Confession of the Month
Top Tip for Avoiding Conversion Mode Outage
Published February 14th, 2012 - by Julian Stuhler
Are you looking forward to using those lovely new DB2 10 for z/OS features, but dreading having to schedule the outage needed to get to Conversion Mode? Although a DB2 data sharing group can theoretically be upgraded to the new release with no loss of availability, certain processes such as DDL and BIND can suffer Continue Reading
Confession of the Month
Want to reduce the number of members in your DB2 for z/OS V10 data sharing group?
Published November 18th, 2011 - by James Gill
For customers who are looking to reduce the number of members in their DB2 for z/OS V10 data sharing group, the APAR that provides this support – PM51945 – closed on November 1st 2011. It provides updated support to the Change Log Inventory (DSNJU003) stand-alone utility to allow you to deactivate a member within a Continue Reading
Confession of the Month
DB2 z/OS Quick Tuning Tip
Published May 27th, 2011 - by DB2 Geek
Anyone who has spent any time tuning DB2 for z/OS applications will know how painful the occasional dataset open/close process can be – there’s even a specific accounting class 3 suspend counter for it. The problem is even worse when large numbers of datasets have to be opened or closed all at once, such as Continue Reading