DB2-L Digest - 21 Dec 2010 to 22 Dec 2010 (#2010-345)

Dave Edwards

DB2-L Digest - 21 Dec 2010 to 22 Dec 2010 (#2010-345)
----- Original Message -----
From: "DB2-L automatic digest system" <[login to unmask email]>
To: <[login to unmask email]>
Sent: Wednesday, December 22, 2010 1:00 AM
Subject: DB2-L Digest - 21 Dec 2010 to 22 Dec 2010 (#2010-345)


There are 11 messages totaling 1875 lines in this issue.

Topics of the day:

1. DB2 Shops on V10 (5)
2. unsubscribe
3. SQL question (4)
4. DB2 Security: Row and Column Access Controls

----------------------------------------------------------------------

Date: Tue, 21 Dec 2010 03:03:34 -0500
From: Phil Grainger <[login to unmask email]>
Subject: Re: DB2 Shops on V10

Well, it depends what Bob means by "go to V9 in 3rd quarter of 2011"

If that means STARTING the migration of subsystems o DB2 9 in Q3 2011, then
changing that plan to a migration to DB2 10 in Q3 2011, then I wouldn't be
anywhere near so concerned as starting a DB2 V8 to 10 migration NOW - and it
fits in with Eds "after a year" suggestion too
Phil Grainger
Cogito Ltd.
[login to unmask email]
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk <blocked:: http://www.cogito.co.uk >

Attend IDUG 2011 - the premiere events for DB2 professionals.
IDUG North America < http://www.idug.org/na > , 2-6 May, Anaheim California
IDUG EMEA < http://www.idug.org/emea > , 14-18 November, Prague Czech Republic


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ed Long
Sent: 20 December 2010 21:54
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 Shops on V10

The following is strictly my opinion and does not reflect the view of any
other person, place or thing.
It took over a year for V8 and V9 to stabilize to the point where the code
matched the hype. Therefore, unless you have a pressing need for something
in V9 or V10 your decision comes down to either waiting a year for V10 to
stabilize or installing V9 now and planning on V10 in 2012.
If you need something in V10 bad then its worth being the first Indian over
the hill. Otherwise, let someone else enjoy the barrage of APARS and go with
V9.


Edward Long

--- On Mon, 12/20/10, Bob Markway <[login to unmask email]> wrote:

From: Bob Markway <[login to unmask email]>
Subject: [DB2-L] DB2 Shops on V10
To: [login to unmask email]
Date: Monday, December 20, 2010, 3:55 PM
We are currently on V8 z/OS. Originally our plans were to go to V9 in 3rd
quarter of 2011, but an IBM rep suggested to management that we should just
go directly from V8 to V10. The other DB2 sysprogs and myself (and several
DBA's as well) would prefer to go to V9 first. Anyway to make a long story
even longer, my concern is it was GA all of two months ago, and after going
early on V8 and battling many issues I am in a word, scared (if not scarred)
of being on the bleeding edge. Does anyone know of a web site that tracks
the percentages of DB2 customers that have gone to V10? Is anyone on V10?
If so were there major issues (especally migrating from V8)? Any
advantages/disadvantages that you would like to share. I was able to find
very little information on V10 migration at all on the web.

Thanks,

Bob

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation 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 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 21 Dec 2010 10:42:54 +0100
From: Max Scarpa <[login to unmask email]>
Subject: Re: DB2 Shops on V10

Hi all

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 from V9. Considering no one migrated a real production system
(for instance V8 beta program had an italian tester and they used a
dedicated subsystem, probably a clone of a prod). For sure IBM provided
this picture (Miller, IDUG 2010):

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 version
to 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 programs) with
online transaction (many) and/or batch jobs (few) but there's no real
'load 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
workload.
- Considering DB2 10 main goal is performance improvements I'd look
carefully to 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 some issues (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 are
ready (and they are always ready, isn't it ? ;-)) and if I'm using any 3rd
party product to manage critical prod processes I'd check that part of
prod with 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. For example 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 sharing'.
Simply to say in data sharing environments, where you have many things to
consider, you've to pay even more attention starting from CF levels and
structures.

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.

Max Scarpa
Certified.......???


> We are currently on V8 z/OS. Originally our plans were to go to V9
> in 3rd quarter of 2011, but an IBM rep suggested to management that
> we should just go directly from V8 to V10. The other DB2 sysprogs
> and myself (and several DBA's as well) would prefer to go to V9
> first. Anyway to make a long story even longer, my concern is it
> was GA all of two months ago, and after going early on V8 and
> battling many issues I am in a word, scared (if not scarred) of
> being on the bleeding edge. Does anyone know of a web site that
> tracks the percentages of DB2 customers that have gone to V10? Is
> anyone on V10? If so were there major issues (especally migrating
> from V8)? Any advantages/disadvantages that you would like to share.
> I was able to find very little information on V10 migration at all on
the web.
>
> Thanks,
>
> Bob
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://
> IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is
it! *
> _____________________________________________________________________
> http://www.IDUG.org/mentor
> How can you expand your staff or do succession planning in this economy?
> Mentoring is a proven, economical, way to train the next generation
> 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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 21 Dec 2010 11:56:18 +0200
From: Cuneyt Goksu <[login to unmask email]>
Subject: Re: DB2 Shops on V10

I would like to give my 2 cents too...

In my region, most of the customers are either running V9 or already in the
middle of V9 Migration project. There is just one client just migrated to V8
from V7 few months ago. We're planning to move them to V10 in 2011Q4. There
are 2 main drivers for this. One is out-of-box savings and the second is
they can not afford to initiate two migration projects in 3-4 years
consecutively. They're outsourcing the migration projects and they're
staying behind the versions. If They move to V10 next year, They will not
need to consider Migration at least 4 years...

Regards, Cuneyt

--
> We are currently on V8 z/OS. Originally our plans were to go to V9
> in 3rd quarter of 2011, but an IBM rep suggested to management that
> we should just go directly from V8 to V10. The other DB2 sysprogs
> and myself (and several DBA's as well) would prefer to go to V9
> first. Anyway to make a long story even longer, my concern is it
> was GA all of two months ago, and after going early on V8 and
> battling many issues I am in a word, scared (if not scarred) of
> being on the bleeding edge. Does anyone know of a web site that
> tracks the percentages of DB2 customers that have gone to V10? Is
> anyone on V10? If so were there major issues (especally migrating
> from V8)? Any advantages/disadvantages that you would like to share.
> I was able to find very little information on V10 migration at all on the
web.
>
> Thanks,
>
> Bob
>
> _____________________________________________________________________

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 21 Dec 2010 06:43:29 -0500
From: Daniel Nardini <[login to unmask email]>
Subject: unsubscribe



_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 21 Dec 2010 03:47:43 -0800
From: Dave Nance <[login to unmask email]>
Subject: Re: SQL question

Then what Phil gave you would work perfect. excuse the formatting, just cut
and
pasted from your mails.

SELECT 1 FROM SYSIBM.SYSDUMMY1
where 1 = ( Select 1 from

( SELECT COUNT(*) NTABLES, COUNT(DISTINCT TSNAME) NTABLESPACE
FROM SYSIBM.SYSTABLES
WHERE DBNAME = 'DSNDB06'
) as newcounts
WHERE NTABLES > 100 AND NTABLESPACE > 1 )

David Nance




________________________________
From: Teldb2kals <[login to unmask email]>
To: [login to unmask email]
Sent: Mon, December 20, 2010 8:16:10 PM
Subject: Re: [DB2-L] SQL question

Thanks, Phil. I knew I should have included another caveat. I don't have too
much control over the full SQL. I can only input the portion from the WHERE
clause, as this is a vendor application that has got the SELECT 1 FROM
SYSIBM.SYSDUMMY1 hardcoded as the first line.


Kals

On Mon, 20 Dec 2010 19:31:23 -0500, Sevetson, Phil <[login to unmask email]>
wrote:

>Kals,
>
>Will this help?
>
>WITH NEWCOUNTS AS
>(
> SELECT COUNT(*) NTABLES, COUNT(DISTINCT TSNAME) NTABLESPACE
> FROM SYSIBM.SYSTABLES
> WHERE DBNAME = 'DSNDB06'
>)
>SELECT 1 FROM NEWCOUNTS
>WHERE NTABLES > 100 AND NTABLESPACE > 1
>
>****************************************************************
>
>-----Original Message-----
>From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Teldb2kals
>Sent: Monday, December 20, 2010 7:25 PM
>To: [login to unmask email]
>Subject: [DB2-L] SQL question
>
>Hi listers,
>
>Merry XMas to all of you.
>
>Now, I am looking at a query that does two different grouping functions on
>the
>same table for the same criteria. To give a simplified example,
>
>SELECT 1 FROM SYSIBM.SYSDUMMY1
>WHERE 100 < (SELECT COUNT(*) FROM SYSIBM.SYSTABLES WHERE DBNAME =
>'DSNDB06')
>
>
>AND 1 < (SELECT COUNT(DISTINCT TSNAME) FROM SYSIBM.SYSTABLES WHERE DBNAME =
>'DSNDB06')
>
>;
>
>(Basically return me '1' if I have more than 100 tables for database
>DSNDB06 and
>more than 1 distinct tablespace for that database).
>
>Can we combine the two subqueries so that it accesses SYSTABLES only once ?
>
>This is a simplistic example of my actual problem where I have a much more
>complicated query, and I would like to avoid executing two subqueries which
>are
>very similar except for the grouping.
>
>Thanks,
>
>Regards,
>Kals
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 *
>http://IDUG.ORG/NA
>*
>* If you are going to attend only one conference this year, this is it! *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>How can you expand your staff or do succession planning in this economy?
>Mentoring is a proven, economical, way to train the next generation 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
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 *
>http://IDUG.ORG/NA
>*
>* If you are going to attend only one conference this year, this is it! *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>How can you expand your staff or do succession planning in this economy?
>Mentoring is a proven, economical, way to train the next generation 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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA
*
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation 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




_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 21 Dec 2010 07:53:36 -0500
From: "B. L. \"Tink\" Tysor" <[login to unmask email]>
Subject: Re: SQL question

Hi Kals,

This is a similar solution to Phil's, but uses a nested table expression
rather than a common table expression.

SELECT 1
FROM
SYSIBM.SYSDUMMY1
,(SELECT COUNT(*) AS TBCOUNT
,COUNT(DISTINCT TSNAME) AS TSCOUNT
FROM SYSIBM.SYSTABLES
) AS T
WHERE
100 < T.TBCOUNT AND 1 < T.TSCOUNT
;
Hope this helps,

Tink
On Mon, Dec 20, 2010 at 8:16 PM, Teldb2kals <[login to unmask email]> wrote:

> Thanks, Phil. I knew I should have included another caveat. I don't have
> too much control over the full SQL. I can only input the portion from the
> WHERE clause, as this is a vendor application that has got the SELECT 1
> FROM
> SYSIBM.SYSDUMMY1 hardcoded as the first line.
>
> Kals
>
> On Mon, 20 Dec 2010 19:31:23 -0500, Sevetson, Phil
> <[login to unmask email]>
> wrote:
>
> >Kals,
> >
> >Will this help?
> >
> >WITH NEWCOUNTS AS
> >(
> > SELECT COUNT(*) NTABLES, COUNT(DISTINCT TSNAME) NTABLESPACE
> > FROM SYSIBM.SYSTABLES
> > WHERE DBNAME = 'DSNDB06'
> >)
> >SELECT 1 FROM NEWCOUNTS
> >WHERE NTABLES > 100 AND NTABLESPACE > 1
> >
> >****************************************************************
> >
> >-----Original Message-----
> >From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Teldb2kals
> >Sent: Monday, December 20, 2010 7:25 PM
> >To: [login to unmask email]
> >Subject: [DB2-L] SQL question
> >
> >Hi listers,
> >
> >Merry XMas to all of you.
> >
> >Now, I am looking at a query that does two different grouping functions
> >on
> the same table for the same criteria. To give a simplified example,
> >
> >SELECT 1 FROM SYSIBM.SYSDUMMY1
> >WHERE 100 < (SELECT COUNT(*) FROM SYSIBM.SYSTABLES WHERE DBNAME =
> 'DSNDB06')
> >AND 1 < (SELECT COUNT(DISTINCT TSNAME) FROM SYSIBM.SYSTABLES WHERE
> DBNAME = 'DSNDB06')
> >;
> >
> >(Basically return me '1' if I have more than 100 tables for database
> DSNDB06 and more than 1 distinct tablespace for that database).
> >
> >Can we combine the two subqueries so that it accesses SYSTABLES only once
> ?
> >
> >This is a simplistic example of my actual problem where I have a much
> >more
> complicated query, and I would like to avoid executing two subqueries
> which
> are very similar except for the grouping.
> >
> >Thanks,
> >
> >Regards,
> >Kals
> >
> >_____________________________________________________________________
> >* IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA < http://idug.org/NA > *
> >* If you are going to attend only one conference this year, this is it!
> *
> >_____________________________________________________________________
> >http://www.IDUG.org/mentor < http://www.idug.org/mentor >
> >How can you expand your staff or do succession planning in this economy?
> >Mentoring is a proven, economical, way to train the next generation of
> >DB2
> Users!
> >_____________________________________________________________________
> >
> >If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-Lis
> >the home of IDUG's Listserv
> >
> >_____________________________________________________________________
> >* IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA < http://idug.org/NA > *
> >* If you are going to attend only one conference this year, this is it!
> *
> >_____________________________________________________________________
> >http://www.IDUG.org/mentor < http://www.idug.org/mentor >
> >How can you expand your staff or do succession planning in this economy?
> >Mentoring is a proven, economical, way to train the next generation of
> >DB2
> Users!
> >_____________________________________________________________________
> >
> >If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-Lis
> >the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 *
> http://IDUG.ORG/NA < http://idug.org/NA > *
> * If you are going to attend only one conference this year, this is it!
> *
> _____________________________________________________________________
> http://www.IDUG.org/mentor < http://www.idug.org/mentor >
> How can you expand your staff or do succession planning in this economy?
> Mentoring is a proven, economical, way to train the next generation 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
>



--
B.L. "Tink" Tysor
Bayard Lee Tysor, Inc.
[login to unmask email]
401-965-2688

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 21 Dec 2010 10:52:26 -0500
From: Chris Hoelscher <[login to unmask email]>
Subject: Re: DB2 Shops on V10

interesting - our IBM rep told is it is indeed possible to go from 8 to 10
(we are on 8) but that he did NOT recommend it (we just got 9 in house in
October)

Chris Hoelscher
IDMS/DB2 System & Database Architect
Humana Inc
502-476-2538
[login to unmask email]

I refuse to repeat gossip - so listen carefully the first time




The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you receive
this material/information in error, please contact the sender and delete or
destroy the material/information.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 21 Dec 2010 12:31:24 -0500
From: Dave Beulke <[login to unmask email]>
Subject: DB2 Security: Row and Column Access Controls

[Message contains invalid MIME fields or encoding and could not be
processed]

------------------------------

Date: Tue, 21 Dec 2010 11:35:21 -0800
From: Myron Miller <[login to unmask email]>
Subject: Re: DB2 Shops on V10

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 query
tuning
is nowhere as functional, nor works anywhere near as well as OSC, not
including
the fact that it's got a number of bugs.

If this is not important to you, then personally (and here's where my
prejudice
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
noticeable
and serious degradation in performance (up to 40% and more has been
documented )

Now, that does not mean that you should not carefully and I do mean
extremely
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 use/(d)
in
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, I'm
really
looking forward to going to V10 soon at my client's site and getting out of
DB2
V9.

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.

Myron



________________________________
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

Hi all

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 from V9.
Considering no one migrated a real production system (for instance V8 beta
program had an italian tester and they used a dedicated subsystem, probably
a
clone of a prod). For sure IBM provided this picture (Miller, IDUG 2010):


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 version to
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 programs) with
online transaction (many) and/or batch jobs (few) but there's no real 'load
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 workload.

- Considering DB2 10 main goal is performance improvements I'd look
carefully to
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 some
issues
(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 are
ready
(and they are always ready, isn't it ? ;-)) and if I'm using any 3rd party
product to manage critical prod processes I'd check that part of prod with
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. For
example
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 sharing'.
Simply
to say in data sharing environments, where you have many things to consider,
you've to pay even more attention starting from CF levels and structures.


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.

Max Scarpa
Certified.......???


> We are currently on V8 z/OS. Originally our plans were to go to V9
> in 3rd quarter of 2011, but an IBM rep suggested to management that
> we should just go directly from V8 to V10. The other DB2 sysprogs
> and myself (and several DBA's as well) would prefer to go to V9
> first. Anyway to make a long story even longer, my concern is it
> was GA all of two months ago, and after going early on V8 and
> battling many issues I am in a word, scared (if not scarred) of
> being on the bleeding edge. Does anyone know of a web site that
> tracks the percentages of DB2 customers that have gone to V10? Is
> anyone on V10? If so were there major issues (especally migrating
> from V8)? Any advantages/disadvantages that you would like to share.
> I was able to find very little information on V10 migration at all on the
> web.
>
> Thanks,
>
> Bob
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://
> IDUG.ORG/NA *
> * If you are going to attend only one conference this year, this is it!
> *
> _____________________________________________________________________
> http://www.IDUG.org/mentor
> How can you expand your staff or do succession planning in this economy?
> Mentoring is a proven, economical, way to train the next generation
> 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 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 21 Dec 2010 16:27:54 -0500
From: Teldb2kals <[login to unmask email]>
Subject: Re: SQL question

Thanks, Dave. I had a feeling I was not thinking clearly. That works
perfectly well.

Regards,
Kals
On Tue, 21 Dec 2010 03:47:43 -0800, Dave Nance <[login to unmask email]> wrote:

>Then what Phil gave you would work perfect. excuse the formatting, just cut
>and
pasted from your mails.

SELECT 1 FROM SYSIBM.SYSDUMMY1??
where 1 = (??Select 1 from
????????????????????????????????????????????????????????
( SELECT COUNT(*) NTABLES, COUNT(DISTINCT TSNAME) NTABLESPACE
?FROM SYSIBM.SYSTABLES??????????????????????????????????????
WHERE DBNAME = 'DSNDB06'?????????????????????????????????
)???as newcounts??????????????????????????????????????????????????????
WHERE NTABLES > 100 AND NTABLESPACE > 1??)
?
David Nance




________________________________
From: Teldb2kals <[login to unmask email]>
To: [login to unmask email]
Sent: Mon, December 20, 2010 8:16:10 PM
Subject: Re: [DB2-L] SQL question

Thanks, Phil. I knew I should have included another caveat. I don't have too
much control over the full SQL. I can only input the portion from the WHERE
clause, as this is a vendor application that has got the SELECT 1 FROM
SYSIBM.SYSDUMMY1 hardcoded as the first line.


Kals

On Mon, 20 Dec 2010 19:31:23 -0500, Sevetson, Phil <[login to unmask email]>
wrote:

>Kals,
>
>Will this help?
>
>WITH NEWCOUNTS AS? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
>(? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
> SELECT COUNT(*) NTABLES, COUNT(DISTINCT TSNAME) NTABLESPACE
> FROM SYSIBM.SYSTABLES? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
> WHERE DBNAME = 'DSNDB06'? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
>)? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
>SELECT 1 FROM NEWCOUNTS? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
>WHERE NTABLES > 100 AND NTABLESPACE > 1? ? ? ? ? ? ? ? ? ?
>
>****************************************************************
>
>-----Original Message-----
>From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Teldb2kals
>Sent: Monday, December 20, 2010 7:25 PM
>To: [login to unmask email]
>Subject: [DB2-L] SQL question
>
>Hi listers,
>
>Merry XMas to all of you.
>
>Now, I am looking at a query that does two different grouping functions on
>the
>same table for the same criteria. To give a simplified example,
>
>SELECT 1 FROM SYSIBM.SYSDUMMY1? ? ? ? ? ? ? ? ? ? ? ? ? ?
>WHERE 100 < (SELECT COUNT(*) FROM SYSIBM.SYSTABLES WHERE DBNAME =
>'DSNDB06')? ?
>? ? ? ? ? ? ? ? ? ? ? ? ? ?
>
>AND? ? 1 < (SELECT? COUNT(DISTINCT TSNAME) FROM SYSIBM.SYSTABLES WHERE
>DBNAME =
>'DSNDB06')? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
>
>;? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
>
>(Basically return me '1' if I have more than 100 tables for database
>DSNDB06 and
>more than 1 distinct tablespace for that database).
>
>Can we combine the two subqueries so that it accesses SYSTABLES only once ?
>
>This is a simplistic example of my actual problem where I have a much more
>complicated query, and I would like to avoid executing two subqueries which
>are
>very similar except for the grouping.
>
>Thanks,
>
>Regards,
>Kals
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

Date: Tue, 21 Dec 2010 16:32:00 -0500
From: Teldb2kals <[login to unmask email]>
Subject: Re: SQL question

Thanks, Tink. But I have control only after the WHERE clause, not before. So
I would not be able to code the NTE there. But it is something to keep in
mind.

Regards,
Kals

On Tue, 21 Dec 2010 07:53:36 -0500, B. L. "Tink" Tysor <[login to unmask email]>
wrote:

>Hi Kals,
>
>This is a similar solution to Phil's, but uses a nested table expression
>rather than a common table expression.
>
>SELECT 1
>FROM
> SYSIBM.SYSDUMMY1
> ,(SELECT COUNT(*) AS TBCOUNT
> ,COUNT(DISTINCT TSNAME) AS TSCOUNT
> FROM SYSIBM.SYSTABLES
> ) AS T
>WHERE
> 100 < T.TBCOUNT AND 1 < T.TSCOUNT
>;
>Hope this helps,
>
>Tink
>On Mon, Dec 20, 2010 at 8:16 PM, Teldb2kals <[login to unmask email]> wrote:
>
>> Thanks, Phil. I knew I should have included another caveat. I don't have
>> too much control over the full SQL. I can only input the portion from the
>> WHERE clause, as this is a vendor application that has got the SELECT 1
>> FROM
>> SYSIBM.SYSDUMMY1 hardcoded as the first line.
>>
>> Kals
>>
>> On Mon, 20 Dec 2010 19:31:23 -0500, Sevetson, Phil
>> <[login to unmask email]>
>> wrote:
>>
>> >Kals,
>> >
>> >Will this help?
>> >
>> >WITH NEWCOUNTS AS
>> >(
>> > SELECT COUNT(*) NTABLES, COUNT(DISTINCT TSNAME) NTABLESPACE
>> > FROM SYSIBM.SYSTABLES
>> > WHERE DBNAME = 'DSNDB06'
>> >)
>> >SELECT 1 FROM NEWCOUNTS
>> >WHERE NTABLES > 100 AND NTABLESPACE > 1
>> >
>> >****************************************************************
>> >
>> >-----Original Message-----
>> >From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Teldb2kals
>> >Sent: Monday, December 20, 2010 7:25 PM
>> >To: [login to unmask email]
>> >Subject: [DB2-L] SQL question
>> >
>> >Hi listers,
>> >
>> >Merry XMas to all of you.
>> >
>> >Now, I am looking at a query that does two different grouping functions
>> >on
>> the same table for the same criteria. To give a simplified example,
>> >
>> >SELECT 1 FROM SYSIBM.SYSDUMMY1
>> >WHERE 100 < (SELECT COUNT(*) FROM SYSIBM.SYSTABLES WHERE DBNAME =
>> 'DSNDB06')
>> >AND 1 < (SELECT COUNT(DISTINCT TSNAME) FROM SYSIBM.SYSTABLES WHERE
>> DBNAME = 'DSNDB06')
>> >;
>> >
>> >(Basically return me '1' if I have more than 100 tables for database
>> DSNDB06 and more than 1 distinct tablespace for that database).
>> >
>> >Can we combine the two subqueries so that it accesses SYSTABLES only
>> >once
>> ?
>> >
>> >This is a simplistic example of my actual problem where I have a much
>> >more
>> complicated query, and I would like to avoid executing two subqueries
>> which
>> are very similar except for the grouping.
>> >
>> >Thanks,
>> >
>> >Regards,
>> >Kals

>B.L. "Tink" Tysor
>Bayard Lee Tysor, Inc.
>[login to unmask email]
>401-965-2688
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

------------------------------

End of DB2-L Digest - 21 Dec 2010 to 22 Dec 2010 (#2010-345)
************************************************************

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv