“Red Alerts” are serious and should be address in as timely manner as possible.
In this case, it all has to do with the ability to recover spacemap updates, are rather not be able to recover them.
Jan 16
Two subsystem parameters (DSNZPARM keywords) have been added in support of DDF (and other DDF enhancements…)
APAR Friday, DB2 10 for z/OS, DDF, Maintenance
Comments Off
The Setup
Today’s blog post discusses two DSNZPARM keywords (MAXCONQN and MAXCONQW on the DSN6FAC macro) that were introduced on December 13, 2012 via APAR PM43293 
to improve management of (distributed) database access threads (DBATS). However, before we (that proverbial group of nonexistent people that live in my head that always tend to volunteer me for stuff that always seems to get me into trouble) get into the details of these two new system parameters, I thought it would be prudent to review a few of the existing distributed terms (like DBAT) and a few DSNZPARM keywords that are used in APAR PM43293’s cover and in today’s blog post: MAXDBAT and CONDBAT on the DSN6SYSP macro and CMTSTAT on the DSN6FAC macro.
Dec 31
APAR Friday: End 2012 with an update to DSNWMSGS
APAR Friday, DB2 10 for z/OS, DB2 9 for z/OS, Maintenance, Performance, Redbooks
Comments Off
2012 comes to an end today. Many have the day off, some don’t but aren’t getting much work done anyway, yet others still have things to complete to finish up their year. With all that in mind, I thought a short yet still handy post would be perfect to cap off the year.
Anyone who has ever messed around with tuning DB2 for z/OS has probably come across an IFCID (instrumentation facility component identifier) at one point or another. In fact, I did a blog post back in May 2010 discussing DSNWMSGS (Instrumentation Facility Component Identifier ) In fact, DB2’s IFCIDs have information on just about any DB2 for z/OS metric you could possibly be interested in, and new ones are added all the time and the current ones are always being expanded.
Nov 29
Just re-wrote a blog post from last month that discussed a space utilization HIPER
DB2 10 for z/OS, Maintenance
Comments Off
That’s right… I just didn’t care for the way it flowed… so I had a little time while eating lunch today… with a sandwich in one hand and keying with the other, I did a little patch work to a blog post I published back on October 28 that discussed the potential for wasting space in the older style table spaces after migrating to DB2 10.
Visit “APAR Friday: If you recently migrated to DB2 10, watch out for table spaces using too much space (HIPER) “ for the rewrite and what I think is a much better description of the issue. If you want, let me know if it reads better now.
Nov 28
APAR Friday: A little something for the programming side; a fix for a small DB2 10 compatibility issue
APAR Friday, DB2 10 for z/OS, DSNZPARM, Maintenance, Migration
Comments Off
Jun 20
DB2 10 for z/OS SQL EXPLAIN
DB2 10 for z/OS, Education, Performance
Comments Off
This may be the shortest blog post I have ever published.
What aspects of EXPLAIN would you all like to see discussed here? Yes, I am looking for ideas for new materials.. and who better to ask than the people who make this blog possible.
Post your suggestions/questions here as comments or send them directly to me at wfavero@acm.org.
Thanks and looking forward to your comments…
May 09
The DB2 Analytics Accelerator gets a couple significant enhancements
Business Analytics, Data Warehousing, DB2 10 for z/OS, DB2 9 for z/OS, Performance, Publication
Comments Off
Performance Availability Scalability
If you hang with DB2, what else do you want? What else could you ask for?
A few months back we (IBM) announced the DB2 Analytics Accelerator V2 (IBM United States Software Announcement 211-454, October 12, 2011) that combined all the things we’ve grown to love and expect from System z with the speed of Netezza. It was without a doubt the perfect marriage.. and almost everyone seems to want to hear more about it. This could be one of the hottest products I’ve seen come around it long time…… Continue reading »
Apr 29
APAR Friday: Enhance REORG TABLESPACE PART performance
APAR Friday, DB2 10 for z/OS, DB2 9 for z/OS, DB2 Utilities, DSNZPARM, Maintenance, Performance
Comments Off
If you are interested in improving the performance of your partition REORGs, here’s a code update that should be of interest. All you need to do is stay current on your maintenance and add an additional keyword here and there. Magically, you have better performance…… Continue reading »
Mar 26
If you use LOBs, are considering using LOBs, or are just a little curious about what’s new with LOBs in DB2 10 for z/OS, do I have a webcast reply for you…… Continue reading »
Jan 31
Make sure you are register for this excellent upcoming February Webcast
DB2 10 for z/OS, Education, Event, IBM Sponsered Event, Migration
Comments Off
DB2 for z/OS Version 8 goes out of SERIVCE (End of Service) on April 20, 2012, just three months from now.
DB2 10 once again offers a skip level migration from DB2 Version 8 to DB2 10.
DB2 9 for z/OS has announced its END of MARKETING as of December 10, 2012 and we all know that when we stop marketing a product, its End of Service announcement can’t be too far away…… Continue reading »
Recent Comments