There’s something about the word “final” that really brings home the fact something is no longer going to be around. The title of this APAR says mountains for just that reason.
“PM66146: Final Update to the DB2 for z/OS Diagnosis Guide and Reference”
APAR PM66146 closed on June 27, 2012 and announced the availability of the final update to the V8 Diagnosis Guide. Of course, this APAR applies only to DB2 for z/OS Version 8. It contains the instructions for obtaining the PDF version of LY37-3201-07.
WOW.. 7 iterations of the Diagnosis Guide… that alone says a lot about how long Version has hung around..
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 email@example.com.
Thanks and looking forward to your comments…
The SRTPOOL subsystem parameter on macro DSN6SPRM defines the amount of sort work area an SQL SELECT statement can use. The number defined on this ZPARM is per SQL task. Bigger is always better if you are talking about only DB2 SQL performance. However, you must keep in mind that whatever value picked is used per SQL statement. That means that if you use the maximum value of 128000 KB (like I often try to do when doing a benchmark but of course, I’m not sure what I do is considered real world. It is definitely not best practices; be careful with the SRTPOL number you choose.), and 10 SQL requiring sort run simultaneously, each of those 10 SQL task has the potential of using 128000 KB of sort pool work area. A little common sense needs to be applied here. You are trading SQL performance for the possibility of a storage shortage. That’s why is is so important to make sure you always keep in mind that the sort pool value you are specifying with SRTPOOL is per concurrent SQL user…… Continue reading »
This is my “official” notice to all of the DB2 Professionals in the greater Houston area announcing out 3rd Quarter 2012 Houston Area DB2 User Group meeting. The meeting is scheduled for Wednesday, July 11 (in just three weeks) and will be hosted once again by Jack Henry & Associates, Inc. located just one block North of FM 1960 and TX-249, Houston (map on our web site: http://db2now.com/hadug/ )…… Continue reading »
You’re right, there were no DB2 for z/OS product publication updates in May; there can’t be stuff to update every month. However, there are a couple of DB2 10 and DB2 9 manuals that have been refreshed for June….. Continue reading »
You all are going to like this.. something that has been needed for a while now.
If you wanted to be able to determine if you have workload running on a general purpose engine (CP) that could have been eligible to run on a zIIP specialty if you had one installed and you wanted this information in your DB2 accounting reports, you wish has been been granted…… Continue reading »
What perfect timing. Just last week I published a blog post asking the question “Do you think we’re heading for a Mainframe skills shortage?” The subject of skills on System z, especially DB2 for z/OS, is of particular interest to me. As pointed out in the comments, if there is a skills shortage, then why is it so difficult for some to locate jobs on System z; both z/OS folks and DB2 for z/OS folk. I hear from them both…… Continue reading »
Testing for the latest RSU service package RSU1204 is complete. This 2nd addendum to this quarter’s service contains all service through December 2011 and PE resolution or HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through April 2012…… Continue reading »
Yup, I’m “flying the Friendly Skies”*** once again.I’m finally getting the opportunity, good or bad, to get out in front of folks once again… Over the next two weeks I will be speaking at…. Continue reading »
Two new built-in functions are being introduced in DB2 10 new function mode (NFM): PACK and UNPACK……. Continue reading »