DB2 V8 & OSC

Bob Markway

DB2 V8 & OSC
We had delayed installing the Optimization Service Center on V8 since we
were planning to upgrade to V9 in the near future, but due to budget
constraints, we are not performing the upgrade this fiscal year. So we are
considering installing OSC on V8 since it has been "back-leveled" for V8.

Is the OSC on V8 & V9 basically the same?
Is there an advantage over Visual Explain?
I have just started looking at OSC (and only from the install side), so any
information would be appreciated.

Thanks for you help,

Bob

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

Todd Burch

Re: DB2 V8 & OSC
(in response to Bob Markway)
Hi Bob.

The very short answer from a support standpoint:

OSC for V8 won't extract V9 stats.
OSC (Service SQL) is the wave of the future.

Todd
DB2 Tech Support


On Dec 8, 2009, at 10:00 AM, Bob Markway wrote:

We had delayed installing the Optimization Service Center on V8 since we
were planning to upgrade to V9 in the near future, but due to budget
constraints, we are not performing the upgrade this fiscal year. So
we are
considering installing OSC on V8 since it has been "back-leveled" for
V8.

Is the OSC on V8 & V9 basically the same?
Is there an advantage over Visual Explain?
I have just started looking at OSC (and only from the install side),
so any
information would be appreciated.

Thanks for you help,

Bob

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

Todd Burch

Re: DB2 V8 & OSC
(in response to Todd Burch)
Well, I need to correct myself. (Thanks Terry for the correction!)

VE does not collect DB2 V9 stats. I knew this, just wrote the wrong
thing.

And my comment about the future wave... as of today - it is
correct. ;)

Todd



On Dec 8, 2009, at 11:11 AM, Todd Burch wrote:

Hi Bob.

The very short answer from a support standpoint:

OSC for V8 won't extract V9 stats.
OSC (Service SQL) is the wave of the future.

Todd
DB2 Tech Support


On Dec 8, 2009, at 10:00 AM, Bob Markway wrote:

We had delayed installing the Optimization Service Center on V8 since we
were planning to upgrade to V9 in the near future, but due to budget
constraints, we are not performing the upgrade this fiscal year. So
we are
considering installing OSC on V8 since it has been "back-leveled" for
V8.

Is the OSC on V8 & V9 basically the same?
Is there an advantage over Visual Explain?
I have just started looking at OSC (and only from the install side),
so any
information would be appreciated.

Thanks for you help,

Bob

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

Richard Janni

Re: DB2 V8 & OSC
(in response to Todd Burch)
Bob,
We have been using OSC V1.1 fixpack 6 in V8 for 6 months. The
access plan graph (visual explain) part of it is enhanced. In addition,
you can generate actual runstat statements, that may contain the
colgroup options, on an sql statement or an entire DBRM. We have had
a number of cases where we simply ran those runstats, rusulting in an
optimum access path, and greatly improved performance.

Just yesterday, I tried upgrading to the current fixpack 7, and OSC did
not see all my subsystems. I heard this is a bug. You can still configure
the subsystems in OSC, but I'm waiting for the fix.

My advice is to start using OSC now. A class on how to use it would be
helpful. I recommend the course from Themis, Inc.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

Myron Miller

Re: DB2 V8 & OSC
(in response to Richard Janni)
I've been using 1.1.7 for some time now with no issues at all.  It came up with all of my subsystems when I updgraded from 1.1.6.

There's also a section in the performance manual about OSC as well, Pat Bossman did two presentations (Part I and Part II) PDFs, that are exceptional in learning how to use it.

To be honest, you really don't need a class.  I've got a number of programmers that have converted from Visual Explain to OSC with no problems and very minimal training to the product..  I have a few issues with it.  But it's still a great tool.

Myron




________________________________
From: Rich Janni <[login to unmask email]>
To: [login to unmask email]
Sent: Thu, December 10, 2009 2:18:40 PM
Subject: Re: [DB2-L] DB2 V8 & OSC

Bob,
We have been using OSC V1.1 fixpack 6 in V8 for 6 months.  The
access plan graph (visual explain) part of it is enhanced.  In addition,
you can generate actual runstat statements, that may contain the
colgroup options, on an sql statement or an entire DBRM.  We have had
a number of cases where we simply ran those runstats, rusulting in an
optimum access path, and greatly improved performance. 

Just yesterday, I tried upgrading to the current fixpack 7, and OSC did
not see all my subsystems.  I heard this is a bug.  You can still configure
the subsystems in OSC, but I'm waiting for the fix.

My advice is to start using OSC now.  A class on how to use it would be
helpful.  I recommend the course from Themis, Inc.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *  http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html -  home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

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

Bob Markway

Re: DB2 V8 & OSC
(in response to Myron Miller)
An FYI and a question. As I was reseaching the install on the z/OS side for
OSC (I can't seem to find one spot for all the information) I came across a
link stating that the OSC is being depreciated. It will no longer be available
in V-next. Below is the link.

I am assuming the replacement products will be charge products, does
anyone know if that is a correct assumption.

http://www-01.ibm.com/support/docview.wss?rs=64&uid=swg27017059

Thanks,

Bob

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

Todd Burch

Re: DB2 V8 & OSC
(in response to Bob Markway)
Hi Bob.

Yes, that is correct.

Remember last week, when I said OSC, "as of today", was the "wave of
the future"? Well, that wave has now gone back out to sea and the new
wave is Data Studio (et al).

I can't speak for pricing - I don't know.

Todd


On Dec 15, 2009, at 12:16 PM, Bob Markway wrote:

An FYI and a question. As I was reseaching the install on the z/OS
side for
OSC (I can't seem to find one spot for all the information) I came
across a
link stating that the OSC is being depreciated. It will no longer be
available
in V-next. Below is the link.

I am assuming the replacement products will be charge products, does
anyone know if that is a correct assumption.

http://www-01.ibm.com/support/docview.wss?rs=64&uid=swg27017059

Thanks,

Bob

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA
*
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free
technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI,
Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for
every level.
_____________________________________________________________________

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

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

David Seibert

Re: DB2 V8 & OSC
(in response to Todd Burch)
Funny, moments ago on the other db2l ('[login to unmask email]')
someone asked the same question about Control Center.
See my answer below based on what I learned from Curt Cotner at IOD and
from Paul Wirth at Mich DB2 User Group. I believe the answer is the same
for OSC.

Data Studio or an Optim component will replace the control center
functions.
At IOD North America in October, the statement was made that the
no-charge offerings will continue and will be under the Data Studio
umbrella. The for-charge versions will be under the Optim name. See
http://www.mdug.org/currentmeeting.html and download Paul Wirth's
afternoon presentation for more details on what will remain no-charge.

Dave

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Todd Burch
Sent: Tuesday, December 15, 2009 1:35 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V8 & OSC

Hi Bob.

Yes, that is correct.

Remember last week, when I said OSC, "as of today", was the "wave of
the future"? Well, that wave has now gone back out to sea and the new
wave is Data Studio (et al).

I can't speak for pricing - I don't know.

Todd


On Dec 15, 2009, at 12:16 PM, Bob Markway wrote:

An FYI and a question. As I was reseaching the install on the z/OS
side for
OSC (I can't seem to find one spot for all the information) I came
across a
link stating that the OSC is being depreciated. It will no longer be
available
in V-next. Below is the link.

I am assuming the replacement products will be charge products, does
anyone know if that is a correct assumption.

http://www-01.ibm.com/support/docview.wss?rs=64&uid=swg27017059

Thanks,

Bob

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA
*
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free
technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI,
Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for
every level.
_____________________________________________________________________

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

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free
technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI,
Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for
every level.
_____________________________________________________________________

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

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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