Dec 31

APAR Friday: End 2012 with an update to DSNWMSGS

By Willie 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.

Continue reading »

Share
Tagged with: • • • • • • • •
May 09

The DB2 Analytics Accelerator gets a couple significant enhancements

By Willie 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 »

Share
Tagged with: • • • • •
Apr 29

APAR Friday: Enhance REORG TABLESPACE PART performance

By Willie 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 »

Share
Tagged with: • • • • • • •
Feb 07

A new DB2 clock has started: End of Service for DB2 9

By Willie DB2 9 for z/OS Comments Off

That’s right.  If you’ve been keeping score you know that we had already announced End of Marketing (EoM) for DB2 9 last year.   That happens on December 10, 2012.   When I discussed that date in this blog I did mention that it won’t be long until we hear something about End of Service (EoS) for DB2 9……  Continue reading »

Share
Tagged with: • • • • •
Jan 25

Well worth a second mention: DB2 9 withdraw from marketing

By Willie DB2 10 for z/OS, DB2 9 for z/OS Comments Off

On December 10, 2012 (that’s less than one year from now), DB2 9 will be withdrawn from marketing along with DB2 9 VUE and the DB2 9 Utility Suite…… Continue reading »

Share
Tagged with: • • • • • •
Dec 09

DB2 9 withdraw from marketing has been announced

By Willie DB2 10 for z/OS, DB2 9 for z/OS Comments Off

On December 10, 2012 (that’s one year from now), DB2 9 will be withdrawn from marketing along with DB2 9 VUE and the DB2 9 Utility Suite…… Continue reading »

Share
Tagged with: • • • • • •
May 12

A seldom used term from days of old

By Willie DB2 9 for z/OS, Fun Stuff to Discuss, Maintenance Comments Off

 
How many times have you had to listen to some old-timer (someone my age) tell you about the old days?   I grew up in this business being told how we “used to do things”.  It does get annoying sometimes.  Old doesn’t always translate to better.  For example, I can assure you that DB2 10 for z/OS performs better with far more functionality than let’s say DB2 Version 1.1…… Continue reading »

Share
Tagged with: • • • • • • •
Oct 29

DB2 9 for z/OS, trusted context, and disaster recovery

By Willie DB2 9 for z/OS Comments Off

Are you on DB2 9 for z/OS? Are you using DB2′s trusted context? Are you also occasionally testing your disaster recovery plan? If you answered yes to all three of these questions, then here’s a little APAR that might be of interest to you….. Continue reading »

Share
Tagged with: • • • •
Aug 11

Let’s talk about more improvements for parallelism

By Willie DB2 9 for z/OS Comments Off

This afternoon I thought it would be fun to talk about a change in how parallelism affects your access path selection in DB2 9 for z/OS. Because of that change, we will also need to discuss a new DSNZPARM is being introduced by APAR PM16020 that throws some controls at how the optimizer makes that access path decision…. Continue reading »

Share
Tagged with: • • • • •
Jan 14

The Table Spaces that Support an RDS SORT – The Final Chapter

By Willie DB2 9 for z/OS, DB2 for z/OS (General) Comments Off

The final topic of discussion is the table spaces that are defined in support of the sort work files. Let’s start with what is probably the number one question in my opinion. Should a sort work file be defined with secondary extents? I have always recommended, as have many others that I know, that you should NOT specify a secondary extent for any of the table spaces defined to DSNDB07 (or what ever your sort work database it’s called if you are a data sharing shop). Secondaries will work with sorts but why have sort do extra work processing multiple extents. It can’t possibly be good for performance…>>>> Continue reading »

Share
Tagged with: •
Previous Entries
preload preload preload