Personally, I'll freely admit I'm torn and highly prejudiced here.
If you rely
on OSC or Visual Explain heavily, then I'd recommend staying with
the plan of
going to Db2 V9 and avoid DB2 10 as long as possible. Data Studio
is nowhere as functional, nor works anywhere near as well as OSC,
the fact that it's got a number of bugs.
If this is not important to you, then personally (and here's where
definitely shows), I'd avoid DB2 V9 like the plaque and go directly
to DB2 V10.
V9 has had lots and lots of issues and for some people has caused a
and serious degradation in performance (up to 40% and more has been
Now, that does not mean that you should not carefully and I do mean
carefully plan and test the conversion. There are lots of changes
that can and
will impact your conversion. And that includes considering the
impact and using
much much more extensive and comprehensive runstats than most shops
V8. But V10 has lots and lots of extra benefits and going to it
will avoid some
of the issues with V9 that many of us suffer(ed) thru. Personally,
other than I
rely on OSC extensively and hate using DS because of its problems,
looking forward to going to V10 soon at my client's site and
getting out of DB2
I'd also strongly consider using Plan Stability (lousy name, I
agree) as soon as
possible. It'll be worth it in the migration, especially if you do
decide to go
to V9. Maintenance in V9 can and has caused access path
degradations, in some
cases the new access path via explain looked better but performed
worse. So be
careful even after you go there, if you do.
From: Max Scarpa <[login to unmask email]>
To: [login to unmask email]
Sent: Tue, December 21, 2010 4:42:54 AM
Subject: Re: [DB2-L] DB2 Shops on V10
Until now, from news and papers I read, you can do the big jump but
I don't know
if any beta testers jumped from V8 to DB2 10.I think many migrated
Considering no one migrated a real production system (for instance
program had an italian tester and they used a dedicated subsystem,
clone of a prod). For sure IBM provided this picture (Miller, IDUG
10% responded moving to DB2 10 as soon as possible
46% responded DB2 9 > DB2 10 when convenient
22% responded DB2 V8 > DB2 9
19% responded DB2 V8 > DB2 10
So it seems only 20% planned to move to DB2 10 with one jump but
they don't say
when (ie if after GA or after DB2 10 is 'mature').
IBM statistics show a decrease in issues when migrating from one
another, but it's only a quality control not a technical safe. In
my opinion it
strongly depends on how good is your testing. For example:
- usually main applications are checked and tested (I mean
online transaction (many) and/or batch jobs (few) but there's no
test' to check what happen under heavy workload. You realize
there's a problem
late in your life. In Db2 10 I'd consider to test this kind of
- Considering DB2 10 main goal is performance improvements I'd look
pre requisites, and expecially for z/OS . See apar II14474, where
it seems some
PTFs are relate to storage management for example. Here I'd expect
(I was burned by a z/OS PTF when dealing with LOBs in V7).
- Considering DB2 isn't a lone star, I'd check carefully if vendors
(and they are always ready, isn't it ? ;-)) and if I'm using any
product to manage critical prod processes I'd check that part of
attention (monitors - which are pervasive - first).
- Check what isn't allowed in DB2 10: the impact will be higher
with respect a
V9 - DB2 10 migration and you could have some unpleasant surprises.
it's time to stop simple tablespace definition, remove old
precompiler, SMS is
mandatory, and more to check before jump.
- 'Errare humanum est but to create real messes you need data
to say in data sharing environments, where you have many things to
you've to pay even more attention starting from CF levels and
For a good view about migrations activities see:
DB2 10 for z/OS Migration Planning by Roger
Miller IDUG 2010
Questions and Answers about DB2 10 for z/OS
Just some thoughts from what I read and IDUG 2010 discussions.
> We are currently on V8 z/OS. Originally our plans were to go
> in 3rd quarter of 2011, but an IBM rep suggested to management
> we should just go directly from V8 to V10. The other DB2
> and myself (and several DBA's as well) would prefer to go to
> first. Anyway to make a long story even longer, my concern is
> was GA all of two months ago, and after going early on V8
> battling many issues I am in a word, scared (if not scarred)
> being on the bleeding edge. Does anyone know of a web site
> tracks the percentages of DB2 customers that have gone to V10?
> anyone on V10? If so were there major issues (especally
> from V8)? Any advantages/disadvantages that you would like to
> I was able to find very little information on V10 migration at
all on the web.
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> IDUG.ORG/NA *
> * If you are going to attend only one conference this year,
this is it! *
> How can you expand your staff or do succession planning in
> Mentoring is a proven, economical, way to train the next
> of DB2 Users!
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
>>> Error in line 8 of site.mailtpl: incorrect operand
type, leftover data: " =
3" <<< -> .BB &DAYSEQ(3) = 2 or &DAYSEQ(3) = 3
* IDUG North America * Anaheim, California * May 2-6 2011 *
* Your only source for independent, unbiased, and trusted DB2
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv