Are you making plans to migrate to a new version of DB2? Do you know what impact the access changes for dynamic SQL will have on performance? When migrating to a new DB2 version, access path changes for dynamic SQL are unpredictable – as is the impact those changes will have on application performance. Learn how you can use Bind ImpactExpert to eliminate the unwanted surprises in version migration by performing a “precheck” on dynamic SQL access path changes.This webinar will be presented by myself (Craig Mullins) and Joe Brockert, Sr. Software...
Friday, 25 January 2008
Get Control of Access Path Changes for Dynamic SQL when Migrating to a New Version of DB2
Posted on 08:51 by Unknown
Wednesday, 16 January 2008
Q+A: Locking
Posted on 11:59 by Unknown
I get questions e-mailed to me all the time. Although I try to read and answer them all, sometimes I don't. I hope those whom I've ignored over the years will forgive me, but I can't always answer everything (not enough time/energy) and sometimes things get lost or drop through the cracks.Anyway, at times I will take a question I get and blog about it in Q+A format. Today is one of those days!The question was: I want to perform a retry on an INSERT under DB2 Z/OS when I get a deadlock/timeout. -911 causes a rollback automatically. Is there a ZPARM...
Blog Tagged
Posted on 09:54 by Unknown
I have been blog tagged by Willie Favero. Don't worry, its not as painful as it sounds!Basically, blog-tagging is a game, of sorts, that has been crawling its way through the blogosphere for awhile now. The way it works, when you are tagged by another blogger, you have to write a blog posting about yourself, with 8 things that others might not know. . . and then tag 8 other bloggers.So here goes:I am an avid music fan. At last count, I have 5,281 CDs and albums (yes, I still have records). I know exactly how many I have because, geek that I am,...
Tuesday, 15 January 2008
History of the Mainframe
Posted on 14:29 by Unknown
While researching some items on the web I ran across a couple of interesting mainframe-related sites that I'd like to share with you.First up, on The History of Computing Project's site, is this entertaining and informative timeline of mainframe history. The timeline starts in 1939 with the creation of the Atanasoff-Berry Computer at Iowa State. If you are looking for historical events in the life of the mainframe, then this is a good place to start. It contains links to information about, and pictures of, some early mainframes including the ENIAC...
Wednesday, 9 January 2008
STOGROUPs and SMS [DB2 9 for z/OS]
Posted on 11:51 by Unknown
With today’s posting we return to our examination of the new features of DB2 9 for z/OS. With V9, DB2 storage groups can be better integrated with SMS storage classes.Prior to DB2 9, you could only spcify SMS storage classes, data classes, and management classes when using explicit IDCAMS defines. You could use those SMS specifications with your SMS ACS routings, but ACS routines filter on data set names, so those routines could become large and unwieldy if you defined multiple different combinations for different data sets.The improvement in DB2...
Thursday, 3 January 2008
On Database Skills and DBA Salaries
Posted on 09:54 by Unknown
Just a quick post today to point you over to my Data Management Today blog. I use this blog to talk about data management issues that are not specific to DB2, whereas this blog focuses almost exclusively on DB2 (and mainframe) topics.But two recent posts at my other blog may be of interest to readers of my DB2 Portal blog. They deal with the topics of employability and pay -- two topics that are near and dear to the heart of IT and database professionals.Here are links to those posts:DBA Salary Update - a look at a couple of recent salary surveysDatabase...
Subscribe to:
Posts (Atom)
