Development Center Adventures

Edward Long

Development Center Adventures
I've been in a cage match with the Development Center lately and need some help.

I have a relatively complex SQL stored procedure and need to step through the code.

The target DB is Version 8 of z/OS so the latest incarnation (v9) of the tool appears to be out of bounds.

The client is at FP17. The principal problem is that I cannot make the step buttons work reliably; further, I have not succeeded in finding current doc for the product which certainly contributes to #1.

We also have run into an interesting bug that the external name, aka Load Module name, must be unique within the entire DB2 subsystem, or else the Development Center client gets upset. We use multiple separate schemas, but still get the problem. Our workaround is, while using the DC, we create a separate name and then revert when we're done.

Am I wasting my time with this thing? What are the rest of you V8 folks doing?
Edward Long

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, 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

David Seibert

Re: Development Center Adventures
(in response to Edward Long)
Hello Ed,

have you tried the DB2 communities and forums?

http://www-01.ibm.com/software/data/db2/support/db2_9/community.html
You can ask questions and get answers from IBMers and other users also.

I've had varying success getting stuff done, but good answers.

E.g., I'm still waiting for a fix to a bogus requirement that a stored
procedure definition have unique names for its parameters. If names are
optional and omitted, how can they be required to be unique????

Good luck,

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: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Ed Long
Sent: Monday, December 15, 2008 11:31 AM
To: [login to unmask email]
Subject: [DB2-L] Development Center Adventures

I've been in a cage match with the Development Center lately and need
some help.

I have a relatively complex SQL stored procedure and need to step
through the code.

The target DB is Version 8 of z/OS so the latest incarnation (v9) of the
tool appears to be out of bounds.

The client is at FP17. The principal problem is that I cannot make the
step buttons work reliably; further, I have not succeeded in finding
current doc for the product which certainly contributes to #1.

We also have run into an interesting bug that the external name, aka
Load Module name, must be unique within the entire DB2 subsystem, or
else the Development Center client gets upset. We use multiple separate
schemas, but still get the problem. Our workaround is, while using the
DC, we create a separate name and then revert when we're done.

Am I wasting my time with this thing? What are the rest of you V8 folks
doing?
Edward Long

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, 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

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, 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

Philip Sevetson

Re: Development Center Adventures
(in response to David Seibert)
Dave, you do know that the link you provided is to a page that specifies
it's for LUW? And Fred's a z/OS DBA?

I like DB2-L, mind you, but I wish there were more forums for the z/OS
DB2 progs, sysprogs, and DBAs. This place feels like a slowly sinking
island, with a few less people on it every year.

--Phil

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Seibert, Dave
Sent: Monday, December 15, 2008 1:37 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Development Center Adventures

Hello Ed,

have you tried the DB2 communities and forums?

http://www-01.ibm.com/software/data/db2/support/db2_9/community.html
You can ask questions and get answers from IBMers and other users also.

I've had varying success getting stuff done, but good answers.

E.g., I'm still waiting for a fix to a bogus requirement that a stored
procedure definition have unique names for its parameters. If names are
optional and omitted, how can they be required to be unique????

Good luck,

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: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Ed Long
Sent: Monday, December 15, 2008 11:31 AM
To: [login to unmask email]
Subject: [DB2-L] Development Center Adventures

I've been in a cage match with the Development Center lately and need
some help.

I have a relatively complex SQL stored procedure and need to step
through the code.

The target DB is Version 8 of z/OS so the latest incarnation (v9) of the
tool appears to be out of bounds.

The client is at FP17. The principal problem is that I cannot make the
step buttons work reliably; further, I have not succeeded in finding
current doc for the product which certainly contributes to #1.

We also have run into an interesting bug that the external name, aka
Load Module name, must be unique within the entire DB2 subsystem, or
else the Development Center client gets upset. We use multiple separate
schemas, but still get the problem. Our workaround is, while using the
DC, we create a separate name and then revert when we're done.

Am I wasting my time with this thing? What are the rest of you V8 folks
doing?
Edward Long

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, 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

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, 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


=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, 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

Edward Long

Re: Development Center Adventures
(in response to Philip Sevetson)
Not sure about Fred, but this Ed does both.

The product in question appears to be a component of LUW hence its less than stellar performance when pointed at z/OS.

Phil's observations about the link appear to be accurate. No real help was obvious after the look up.

Back to the cage match!


Edward Long


--- On Mon, 12/15/08, Sevetson, Phil <[login to unmask email]> wrote:

> From: Sevetson, Phil <[login to unmask email]>
> Subject: Re: [DB2-L] Development Center Adventures
> To: [login to unmask email]
> Date: Monday, December 15, 2008, 3:58 PM
> Dave, you do know that the link you provided is to a page
> that specifies
> it's for LUW? And Fred's a z/OS DBA?
>
> I like DB2-L, mind you, but I wish there were more forums
> for the z/OS
> DB2 progs, sysprogs, and DBAs. This place feels like a
> slowly sinking
> island, with a few less people on it every year.
>
> --Phil
>
> -----Original Message-----
> From: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On
> Behalf Of Seibert, Dave
> Sent: Monday, December 15, 2008 1:37 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] Development Center Adventures
>
> Hello Ed,
>
> have you tried the DB2 communities and forums?
>
> http://www-01.ibm.com/software/data/db2/support/db2_9/community.html
>
> You can ask questions and get answers from IBMers and other
> users also.
>
> I've had varying success getting stuff done, but good
> answers.
>
> E.g., I'm still waiting for a fix to a bogus
> requirement that a stored
> procedure definition have unique names for its parameters.
> If names are
> optional and omitted, how can they be required to be
> unique????
>
> Good luck,
>
> 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: DB2 Data Base Discussion List
> [mailto:[login to unmask email] On
> Behalf Of Ed Long
> Sent: Monday, December 15, 2008 11:31 AM
> To: [login to unmask email]
> Subject: [DB2-L] Development Center Adventures
>
> I've been in a cage match with the Development Center
> lately and need
> some help.
>
> I have a relatively complex SQL stored procedure and need
> to step
> through the code.
>
> The target DB is Version 8 of z/OS so the latest
> incarnation (v9) of the
> tool appears to be out of bounds.
>
> The client is at FP17. The principal problem is that I
> cannot make the
> step buttons work reliably; further, I have not succeeded
> in finding
> current doc for the product which certainly contributes to
> #1.
>
> We also have run into an interesting bug that the external
> name, aka
> Load Module name, must be unique within the entire DB2
> subsystem, or
> else the Development Center client gets upset. We use
> multiple separate
> schemas, but still get the problem. Our workaround is,
> while using the
> DC, we create a separate name and then revert when
> we're done.
>
> Am I wasting my time with this thing? What are the rest of
> you V8 folks
> doing?
> Edward Long
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 *
> http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in
> IDUG. The
> DB2-L list archives, 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
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 *
> http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in
> IDUG. The
> DB2-L list archives, 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
>
>
> =========
> Confidentiality Notice: This e-mail communication, and any
> attachments, contains confidential and privileged
> information for the exclusive use of the recipient(s) named
> above. If you are not an intended recipient, or the employee
> or agent responsible to deliver it to an intended recipient,
> you are hereby notified that you have received this
> communication in error and that any review, disclosure,
> dissemination, distribution or copying of it or its contents
> is prohibited. If you have received this communication in
> error, please notify me immediately by replying to this
> message and delete this communication from your computer.
> Thank you.
>
> Any opinions, expressed or implied, presented are solely
> those of the author and do not necessarily represent the
> opinions of the agency or the City.
> =========
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 *
> http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in
> IDUG. The DB2-L list archives, 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

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, 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

William Favero

Re: Development Center Adventures
(in response to Edward Long)
Have you had a look at the DB2 for z/OS forums at IBM's developerWorks...

http://www.ibm.com/developerworks/forums/forum.jspa?forumID=293&cat=19

Willie

Sevetson, Phil wrote:
> Dave, you do know that the link you provided is to a page that specifies
> it's for LUW? And Fred's a z/OS DBA?
>
> I like DB2-L, mind you, but I wish there were more forums for the z/OS
> DB2 progs, sysprogs, and DBAs. This place feels like a slowly sinking
> island, with a few less people on it every year.
>
> --Phil
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Seibert, Dave
> Sent: Monday, December 15, 2008 1:37 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] Development Center Adventures
>
> Hello Ed,
>
> have you tried the DB2 communities and forums?
>
> http://www-01.ibm.com/software/data/db2/support/db2_9/community.html
> You can ask questions and get answers from IBMers and other users also.
>
> I've had varying success getting stuff done, but good answers.
>
> E.g., I'm still waiting for a fix to a bogus requirement that a stored
> procedure definition have unique names for its parameters. If names are
> optional and omitted, how can they be required to be unique????
>
> Good luck,
>
> 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: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Ed Long
> Sent: Monday, December 15, 2008 11:31 AM
> To: [login to unmask email]
> Subject: [DB2-L] Development Center Adventures
>
> I've been in a cage match with the Development Center lately and need
> some help.
>
> I have a relatively complex SQL stored procedure and need to step
> through the code.
>
> The target DB is Version 8 of z/OS so the latest incarnation (v9) of the
> tool appears to be out of bounds.
>
> The client is at FP17. The principal problem is that I cannot make the
> step buttons work reliably; further, I have not succeeded in finding
> current doc for the product which certainly contributes to #1.
>
> We also have run into an interesting bug that the external name, aka
> Load Module name, must be unique within the entire DB2 subsystem, or
> else the Development Center client gets upset. We use multiple separate
> schemas, but still get the problem. Our workaround is, while using the
> DC, we create a separate name and then revert when we're done.
>
> Am I wasting my time with this thing? What are the rest of you V8 folks
> doing?
> Edward Long
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The
> DB2-L list archives, 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
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The
> DB2-L list archives, 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
>
>
> =========
> Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.
>
> Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
> =========
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, 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
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, 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

David Seibert

Re: Development Center Adventures
(in response to William Favero)
Thanks for the comment Phil.

As far as I've seen, the Development Center installs only on LU or W.
But the list of forums on the link also includes z DB2.
Scroll down if you missed them.

The site is poorly labeled to lead you to believe otherwise.

Try them out.

Dave

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Sevetson, Phil
Sent: Monday, December 15, 2008 3:58 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Development Center Adventures

Dave, you do know that the link you provided is to a page that specifies
it's for LUW? And Fred's a z/OS DBA?

I like DB2-L, mind you, but I wish there were more forums for the z/OS
DB2 progs, sysprogs, and DBAs. This place feels like a slowly sinking
island, with a few less people on it every year.

--Phil

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Seibert, Dave
Sent: Monday, December 15, 2008 1:37 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Development Center Adventures

Hello Ed,

have you tried the DB2 communities and forums?

http://www-01.ibm.com/software/data/db2/support/db2_9/community.html
You can ask questions and get answers from IBMers and other users also.

I've had varying success getting stuff done, but good answers.

E.g., I'm still waiting for a fix to a bogus requirement that a stored
procedure definition have unique names for its parameters. If names are
optional and omitted, how can they be required to be unique????

Good luck,

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: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Ed Long
Sent: Monday, December 15, 2008 11:31 AM
To: [login to unmask email]
Subject: [DB2-L] Development Center Adventures

I've been in a cage match with the Development Center lately and need
some help.

I have a relatively complex SQL stored procedure and need to step
through the code.

The target DB is Version 8 of z/OS so the latest incarnation (v9) of the
tool appears to be out of bounds.

The client is at FP17. The principal problem is that I cannot make the
step buttons work reliably; further, I have not succeeded in finding
current doc for the product which certainly contributes to #1.

We also have run into an interesting bug that the external name, aka
Load Module name, must be unique within the entire DB2 subsystem, or
else the Development Center client gets upset. We use multiple separate
schemas, but still get the problem. Our workaround is, while using the
DC, we create a separate name and then revert when we're done.

Am I wasting my time with this thing? What are the rest of you V8 folks
doing?
Edward Long

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, 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

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, 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


=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use
of the recipient(s) named above. If you are not an intended recipient,
or the employee or agent responsible to deliver it to an intended
recipient, you are hereby notified that you have received this
communication in error and that any review, disclosure, dissemination,
distribution or copying of it or its contents is prohibited. If you have
received this communication in error, please notify me immediately by
replying to this message and delete this communication from your
computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or
the City.
=========

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, 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

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, 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

Philip Sevetson

Re: Development Center Adventures
(in response to David Seibert)
Thanks for the link, Willie :-)


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Willie Favero
Sent: Monday, December 15, 2008 8:24 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Development Center Adventures

Have you had a look at the DB2 for z/OS forums at IBM's
developerWorks...

http://www.ibm.com/developerworks/forums/forum.jspa?forumID=293&cat=19

Willie

Sevetson, Phil wrote:
> Dave, you do know that the link you provided is to a page that
specifies
> it's for LUW? And Fred's a z/OS DBA?
>
> I like DB2-L, mind you, but I wish there were more forums for the z/OS
> DB2 progs, sysprogs, and DBAs. This place feels like a slowly sinking
> island, with a few less people on it every year.
>
> --Phil
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Seibert, Dave
> Sent: Monday, December 15, 2008 1:37 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] Development Center Adventures
>
> Hello Ed,
>
> have you tried the DB2 communities and forums?
>
> http://www-01.ibm.com/software/data/db2/support/db2_9/community.html
> You can ask questions and get answers from IBMers and other users
also.
>
> I've had varying success getting stuff done, but good answers.
>
> E.g., I'm still waiting for a fix to a bogus requirement that a stored
> procedure definition have unique names for its parameters. If names
are
> optional and omitted, how can they be required to be unique????
>
> Good luck,
>
> 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: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Ed Long
> Sent: Monday, December 15, 2008 11:31 AM
> To: [login to unmask email]
> Subject: [DB2-L] Development Center Adventures
>
> I've been in a cage match with the Development Center lately and need
> some help.
>
> I have a relatively complex SQL stored procedure and need to step
> through the code.
>
> The target DB is Version 8 of z/OS so the latest incarnation (v9) of
the
> tool appears to be out of bounds.
>
> The client is at FP17. The principal problem is that I cannot make the
> step buttons work reliably; further, I have not succeeded in finding
> current doc for the product which certainly contributes to #1.
>
> We also have run into an interesting bug that the external name, aka
> Load Module name, must be unique within the entire DB2 subsystem, or
> else the Development Center client gets upset. We use multiple
separate
> schemas, but still get the problem. Our workaround is, while using the
> DC, we create a separate name and then revert when we're done.
>
> Am I wasting my time with this thing? What are the rest of you V8
folks
> doing?
> Edward Long
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The
> DB2-L list archives, 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
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The
> DB2-L list archives, 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
>
>
> =========
> Confidentiality Notice: This e-mail communication, and any
attachments, contains confidential and privileged information for the
exclusive use of the recipient(s) named above. If you are not an
intended recipient, or the employee or agent responsible to deliver it
to an intended recipient, you are hereby notified that you have received
this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is
prohibited. If you have received this communication in error, please
notify me immediately by replying to this message and delete this
communication from your computer. Thank you.
>
> Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or
the City.
> =========
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, 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
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, 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


=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, 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