Wednesday, May 10, 2006

IDUG Day Three

It has been a busy couple of days here at the IDUG conference in Tampa this week. Let me catch you up if you aren't lucky enough to be here.

First of all, the vendor exhibit hall was rocking Monday, Tuesday, and Wednesday - but as of lunch today, the exhibit hall is over. Let's see, Compuware was giving away yo-yo's, Golden Gate had light up balls, NEON Enterprise Software was giving away cool black t-shirts, the Database Brothers were zooming around the hall on a Segway that they were giving away, and SoftBase had a slew of stuff including sunglasses, baseball caps, and stop watches. And IBM has finally put out a DB2 Catalog poster of their own. So now you can choose whether you want the CA, BMC, or IBM version. Or better yet, get all three and use them to wall paper your cubicle!

And let's not forget that CA held their annual party which is always a highlight of the show - at least for the drinkers in the crowd. But wait-a-minute, I don't think I've met the DBA who won't quaff a brew when it is offered for free. So I guess fun was had by one and all.

What about the serious stuff, you might ask? OK, I spent several sessions over the past two days concentrating on backup and recovery stuff. I mentioned Thomas Bauman's presentation on Day One, but I also saw Dave Schwartz of IBM outline the capabilities of IBM's Recovery Tools and Ulf Heinreich of Software Engineering talk about SEG's new Recovery Health Check for DB2 z/OS offering. Ulf's presentation discussed how automated daily checks can assure that each DB2 database object can always be recovered reliably and as fast as possible. The product can tell you how long it will take to recover - and isn't that what your boss is always leaning over your shoulder to ask when things go awry? "When will the recovery be done? When will the application be back up?" Wouldn't it be nice to tell him, "36.3 minutes, now make yourself useful and get me a refill on this coffee!"

The conference is winding down, and tomorrow will be the last day. I still have my presentation on Nulls - if you want a preview of that, read my blog from a week or so ago titled Using Nulls in DB2.

So this will be my last post from the IDUG show floor - after my presentation tomorrow, my wife is flying over here to join me for a few days of vacation on the Florida coast. After this week, I think I've earned... heck, we've all earned it, so maybe I'll see some fellow attendees on the beach this weekend. Just don't ask me to take a look at that outer join that is vexing you - I'm on vacation!

Tuesday, May 09, 2006

My First Presentation at IDUG

Oh, yes, I almost forgot to post about my presentation on Monday. I spoke at a vendor-sponsored presentation for NEON Enterprise Software. The topic was on Change Management for DB2 Access Paths - and it is an important topic to consider. Although my presentation was followed by a product pitch for NEON's BindImpact Expert, the topic warrants consideration, product or not.

Basically, the thrust of the presentation is that more focus needs to be applied to managing DB2 access paths. We implement strict change management procedures on every other change we make in the mainframe environment: program changes, system software changes, PTFs, etc. But with access paths it is move the DBRM to production and BIND. We don't move access paths, we create new ones on the fly in the production world. Is this any way to work?

The result of this situation is that many sites often BIND once, and then never REBIND for fear of introducing degraded access paths. This is an unfortunate situation. Basically, what this does is penalize EVERY statement because we are worried about 2 or 3 statements that might degrade.

I know these two things seem at odds with one another: that is, we need change management but we also need to keep REBINDing. And they are. But the proper response is NOT to stop all REBINDs, the proper response is to introduce methods and procedures for implementing a change management discipline. And that is where the NEON solution comes in.

'Nuff said, for now...

Monday, May 08, 2006

IDUG Day One

Just a quick post to report on the first day goings-on at the IDUG North American conference in Tampa. As usual the keynote was entertaining and highly attended. Bob Picciano of IBM talked about "Information as a Service... A New Era in Databases." The basic thrust of the pitch was that SOA and services will provide organizations with the ability to better integrate information and transform and modernize their existing systems.

I also attended a great overview of DB2 Recovery by Robert Goodman of Florida Hospital. He outlined a series of more than 30 tips on how to best implement DB2 recovery practices and procedures.

I'm just now waiting outside the exhibit hall which will open in a few minutes.

As always, IDUG is living up to its reputation to be informative, exciting, and a great place to network. If you're not here this year it is not too early to start pleading your case to attend next year....

Tuesday, May 02, 2006

DB2 for z/OS Version 9 Beta Announcement

On May 2, 2006 IBM announced the beta for the next version of mainframe DB2: namely, DB2 V9.1 for z/OS. You can view the announcement here.

According to the announcement the key areas of improvement in V9 will be in business insight innovations, cost savings through optimized innovations, and business resiliency innovations.

Selected features that deliver these valuable benefits to your business include:

  • Rich new hybrid data server support for both relational and pure XML storage, with the necessary services to support both data structures
  • New data types (decimal float, BIGINT, and varbinary)
  • Native SQL procedural language
  • Improved security with roles, trusted context, and new encryption functions
  • Extensions of the V8 capabilities to make changes to the data definitions without taking your data offline
  • Enhancements to large object support and performance
  • Volume-based copy and recover
  • Refinements to the DB2 industry-leading optimization
  • QMF interface redesigned to provide on demand access to data, reports, and interactive
    visual solutions with optional Web browser

So, if you haven't started planning your move to V8 yet, now is definitely the time to get moving. V8 has been out for a couple of years now and there is a new version of DB2 on the horizon...

Friday, April 28, 2006

System z9 Business Class Mainframe Getting Positive Press

It looks like IBM's new low-cost z9 mainframe is getting some positive press. It always does my heart good to see the mainframe in the IT press.

Take a look at these articles:
Anyone interested in reading all about IBM's z9 mainframe offerings can check 'em out at http://www-03.ibm.com/systems/z/.