Thursday, May 25, 2006
Why is this interesting? Well, for one, it seems like IBM has a good handle on the actual problem, linking it to master data management. And IBM's system software is typically top notch. But to take it up a few levels, why should anyone truly adopy CMDB? Well, according to a recent article Network World (CMDB adoption: What some numbers tell us and why) the CMDB is at the heart of change and configuration management, service assurance, and problem and incident management initiatives.
These are important initiatives because many organizations do not know what assets they have deployed, so they are over- and under-buying these assets. This, of course, results in inefficiencies -- either too much IT spend or ineffective IT. And the bugaboo of missed SLAs should always be top of mind. And implementing a CCMDB promises to help alleviate these problems. And this is goodness...
Wednesday, May 17, 2006
Thursday, May 11, 2006
I just finished my final presentation (the one on NULLs) and I'm sitting in an empty hallway as I type this. And, I have to say, this has been a very productive IDUG.
Anyway, I know that my blogs on IDUG this week have been brief, but that is because IDUG is a very busy week for me (as it is for most of the attendees, I suppose). If you are looking for more in-depth coverage of IDUG, I suggest you check out IDUG's Official Conference Blog. There is a LOT of great stuff (as well as pictures) posted there.
Also, if you are interested in another perspective on IDUG, click on over to Willie Favero's DB2 Blog for Willie's insights on the week.
Wednesday, May 10, 2006
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
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
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
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...