May 15

Deprecated: Such a cool word yet a word so misunderstood

By Willie DB2 for z/OS (General), DSNZPARM, Migration No Comments »

I wanted to talk about the DSNZPARM keys deprecated in DB2 10.  And yes I do realize that I listed them out in a previous post.  However, this time I wanted to discuss why it’s important today, maybe even before migrating to DB2 10, to plan on how their eventual departure from DB2 may affect you.

Then someone pointed out to me that sometimes when we say something is “deprecated” in a future release of DB2, it can sometimes get misinterpreted, or misunderstood.  In fact, there has been extra verbiage added to the DB2 10 Installation and Migration Guide (GC19-2974) to help alleviate future misunderstandings…… Continue reading »

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

Metrics have been enhanced for DB2 stored procedures and UDFs

By Willie DB2 10 for z/OS, Maintenance, Performance No Comments »

For all of you that love to do performance and tuning of you DB2 subsystems, DB2 land is about to make your job a whole lot easier in the stored procedure and user-defined function (UDF) categories by improving some of the existing metrics and adding a few new ones.

The issue; a couple of numbers all lumped in together.  The solution; more granularity, possibly right down to the individual stored procedure or UDF level, if everything gets set up correctly…… Continue reading »

Share
Tagged with: • • • • • • • •
May 11

APAR Friday: Another parallel REORG enhancement

By Willie APAR Friday, DB2 10 for z/OS, DB2 Utilities, DSNZPARM, Maintenance, Performance No Comments »

Well over a year ago (Feb 2011) I blogged about the addition of the PARALLEL keyword that was made available on the REORG TABLESPACE LIST utility control statement.  (See “APAR Friday: Another great REORG enhancement” )

As a result of the group of fixes mentioned in the above blog post, a single execution of REORG happens with a list of partitions.  It does happen in parallel; that’s good news.   However, sometimes, someone may want to still run the list of partitions serially… one partition at a time……. Continue reading »

Share
Tagged with: • • • • • • •
May 10

It’s not to soon to start thinking about IOD 2012 in Las Vegas

By Willie Education, IBM Sponsered Event No Comments »

The 2012 Information on Demand (IOD) conference is only 5 months away… (where has this year gone already)….  It’s being help once again in Las Vegas at the Mandalay Bay on October 21-25.  Last years conference was huge.   This years should be even better.

Continue reading »

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

The “DB2 for z/OS Exchange” (the old zHotline) has returned

By Willie DB2 for z/OS (General), IBM Information of Interest No Comments »

If you are a DB2 for z/OS DBA, System Programmer, or Application Programmer, you now have a new resource to add to your list of places to discover information.

The DB2 for z/OS Exchange  will have much of what you need, being refreshed as frequently as each month…  Were you wondering about a HIPER you heard about, or an APAR that seems like it could solve an issue you’re having?   The DB2 for z/OS Exchange  could be the place to find the answer….. 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 No Comments »

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: • • • • •
May 08

Updated DB2 for z/OS Diagnosis Guide and Reference available

By Willie DB2 10 for z/OS, DB2 9 for z/OS, Maintenance, Publication No Comments »

As I discussed last week in my April 29, 2012 blog post “DB2 10, DB2 9, and DB2 V8 Product Publications have been refreshed for April 2012”, the APAR that delivers the updates to the DB2 9 for z/OS and DB2 10 for z/OS Diagnosis Guide and Reference closed yesterday…… Continue reading »

Share
Tagged with: • • • • • •
May 05

Here’s your opportunity to learn more and DB2 for z/OS and WLM

By Willie DB2 for z/OS (General), Performance, WLM, z/OS No Comments »

Last Thursday I had the chance to listened in to Cristian Molaro  talk about the z/OS component workload manager (WLM).  He discussed how DB2 can take advantage of WLM and how you can manage WLM on the DB2 Night Show  .  He even goes into a few no-charge tools available to you for download form the IBM web site…… Continue reading »

Share
Tagged with: • • •
May 04

APAR Friday: Small glitch with DSNZPARM keyword DDLTOX

By Willie APAR Friday, DB2 10 for z/OS, DB2 9 for z/OS, DSNZPARM, Maintenance No Comments »

Back on July 11, 2011 ( I can’t believe it’s been a year almost already) I wrote about a new DSNZPARM keyword that was introduced that applied a timeout controls on DDL, different from the rest of the timeout knobs that already existed in DB2.  That post along with all the details about the ZPARM can be found at “An additional timeout control is added to DB2 for z/OS” …… Continue reading »

Share
Tagged with: • • • • •
May 04

April 2012 (RSU1204) service package is tested and available

By Willie DB2 10 for z/OS, DB2 9 for z/OS, Maintenance No Comments »

Testing for the latest RSU service package RSU1204 is complete.  This 1st quarter addendum contains all service through December 2011 and PE resolution or HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedes through March 2012…… Continue reading »

Share
Tagged with: • • • • • •
Previous Entries
preload preload preload