DB2 v8 z/OS & DB2 Pathchecker

Steve Whittaker

DB2 v8 z/OS & DB2 Pathchecker
We are going to start down that long, lonely, cold dark path to:
"Migration to DB2 z/OS Version 8".

I've been reading some IBM material on V8 and I see this product
mentioned (DB2 Pathchecker) and I was wondering if anyone out there has
used it for their v8 Migration? If so, what did you think of it and was
it something that you could not live without.

I'd appreciate any opinions on this and if you'd like to respond
off-line from the forum please feel free to do so.

Thanks:
--Steve....

Steve Whittaker


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Mark Vickers

Re: DB2 v8 z/OS & DB2 Pathchecker
(in response to Steve Whittaker)
Steve,
We are right there too.
I compared the "claimed" features of Pathchecker and NEON BindImpactExpert
expert and we are currently evaluating BindImpactExpert
We chose NEON at this stage because it has a facility to managing binds
and rebinds in batch mode, which we can use longer term for our QA -
AFAIK, with IBM you need a second tool for that (DB2 Bind Manager).
I have not had any feedback from the eval so far, but if you would like, I
will pass it on when I do.

I hope you don't mind if I expand this thread here.......
I look forward to hearing from someone who has used one or more of these
products.
BTW, there was a third player (EZDB2 I think).

Mark Vickers




"Whittaker, Stephen" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/18/2007 01:37 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
DB2 v8 z/OS & DB2 Pathchecker






We are going to start down that long, lonely, cold dark path to:
"Migration to DB2 z/OS Version 8".
I've been reading some IBM material on V8 and I see this product
mentioned (DB2 Pathchecker) and I was wondering if anyone out there has
used it for their v8 Migration? If so, what did you think of it and was it
something that you could not live without.
I'd appreciate any opinions on this and if you'd like to respond
off-line from the forum please feel free to do so.
Thanks:
--Steve?.
Steve Whittaker

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org under
the Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services




This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete all copies
of this message.



The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Myron Miller

Re: DB2 v8 z/OS & DB2 Pathchecker
(in response to Mark Vickers)
I haven't used Pathchecker but did use Cogito's EZDB2 path checking tool
extensively when migrating from V7 to V8. It won't do the binds them selves
but it did help with the access path comparisons. I looked at thousands of SQL
over a two month period and checked things pretty thoroughly during the
migration so that when we did the actual implementation we had zero access path
issues.

Myron
--- "Whittaker, Stephen" <[login to unmask email]> wrote:

> We are going to start down that long, lonely, cold dark path to:
> "Migration to DB2 z/OS Version 8".
>
> I've been reading some IBM material on V8 and I see this product
> mentioned (DB2 Pathchecker) and I was wondering if anyone out there has
> used it for their v8 Migration? If so, what did you think of it and was
> it something that you could not live without.
>
> I'd appreciate any opinions on this and if you'd like to respond
> off-line from the forum please feel free to do so.
>
> Thanks:
> --Steve....
>
> Steve Whittaker
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
> archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug
> under the Listserv tab. While at the site, you can also access the IDUG
> Online Learning Center, Tech Library and Code Place, see the latest IDUG
> conference information, and much more. If you have not yet signed up for
> Basic Membership in IDUG, available at no cost, click on Member Services at
> http://www.idug.org/lsms
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Steve Whittaker

Re: DB2 v8 z/OS & DB2 Pathchecker
(in response to Myron Miller)
Mark:
Thanks for the information. I'll be checking on the others you
mentioned too.

--Steve....

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of [login to unmask email]
Sent: Tuesday, December 18, 2007 2:48 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8 z/OS & DB2 Pathchecker



Steve,
We are right there too.
I compared the "claimed" features of Pathchecker and NEON
BindImpactExpert expert and we are currently evaluating BindImpactExpert

We chose NEON at this stage because it has a facility to
managing binds and rebinds in batch mode, which we can use longer term
for our QA - AFAIK, with IBM you need a second tool for that (DB2 Bind
Manager).
I have not had any feedback from the eval so far, but if you
would like, I will pass it on when I do.

I hope you don't mind if I expand this thread here.......
I look forward to hearing from someone who has used one or more
of these products.
BTW, there was a third player (EZDB2 I think).

Mark Vickers




"Whittaker, Stephen" <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

12/18/2007 01:37 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc
Subject
DB2 v8 z/OS & DB2 Pathchecker






We are going to start down that long, lonely, cold dark path to:
"Migration to DB2 z/OS Version 8".

I've been reading some IBM material on V8 and I see this
product mentioned (DB2 Pathchecker) and I was wondering if anyone out
there has used it for their v8 Migration? If so, what did you think of
it and was it something that you could not live without.

I'd appreciate any opinions on this and if you'd like to
respond off-line from the forum please feel free to do so.

Thanks:
--Steve....

Steve Whittaker


The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org < http://www.idug.org/lsidug > under the Listserv tab. While
at the site, you can also access the IDUG Online Learning Center, Tech
Library and Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services
< http://www.idug.org/lsms >





This e-mail (and any attachments) may contain information that
is confidential and/or protected by law. Any review, use, distribution
or disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the
intended recipient, please contact the sender by reply email and delete
all copies of this message.





The IDUG DB2-L Listserv is only part of your membership in IDUG.
DB2-L list archives, the FAQ, and delivery preferences are at
www.idug.org < http://www.idug.org/lsidug > under the Listserv tab. While
at the site, you can also access the IDUG Online Learning Center, Tech
Library and Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG,
available at no cost, click on Member Services
< http://www.idug.org/lsms >


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms