DB2 V10 and COOL:Gen 6 [SEC=UNCLASSIFIED]

Steve Tennant

DB2 V10 and COOL:Gen 6 [SEC=UNCLASSIFIED]
I can't think of any reason why it would be a problem. We are in the
process of going from gen 6.5 to Gen8 whilst at the same time moving
from db2 v8 to db2v9 (we like the excitement)

Old Gen will generate 'old' SQL and as db2 is good at backwards
compatibility I don't think that would be an issue.

An area that may need more attention is z/os versions. I seem to recall
we had problems with Gen/Websphere/z-os at version 6 with db2v7 but as
you are beyond that point it is obviously not an issue. Even so I'd
talk with CA and IBM about possible mismatches with z-os and Gen.

Moving _Gen_ forward has more problems due to changes from load modules
to DLLs and mixing two Gens at one level is a no-no.

HTH

Steve T


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of William
Powers
Sent: Friday, 14 January 2011 7:11 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 V10 and COOL:Gen 6

We are currently looking into upgrading our DB2 subsystems from V8 to
V10 and wanted to see if any shops have had any experience or issues
running COOL:Gen 6 in DB2 V10 code.

Any feedback would be greatly appreciated.


William Powers
Sr Systems Programmer
Labcorp

_____________________________________________________________________
* 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! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

***************************************************************************************************
IMPORTANT:

* This transmission is intended for the use of the addressee only and might contain sensitive or legally privileged information. If you are NOT the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error, please notify the author immediately by telephone and delete all copies of this transmission together with any attachments.

* The Australian Customs and Border Protection Service DOES NOT AUTHORISE the recipient to further disclose this email or its contents without permission of the originator.

* Unsolicited commercial emails MUST NOT be forwarded to the originator of this transmission unless prior consent has been given.

***************************************************************************************************

_____________________________________________________________________
* 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! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Peter Suhner

Re: DB2 V10 and COOL:Gen 6 [SEC=UNCLASSIFIED]
(in response to Steve Tennant)

William,

as Steve points out, the generated code itself should be ok.

I have no experience yet with DB2 10, but as for any version change, I'd check the SQL reserved words list.

And of course for installation/runtime, remember that PLAN bind is no more supported with DB2 10. In our shop (and in development environment only), we currently still use PLAN-DBRM bind for GEN programs, as GEN's capabilities for PACKAGE BIND are insufficient for our development concept due to our extensive use of COLLECTIONS. Therefore, we're a bit stuck with DB2 9 in this specific area.

For production, our deployment tools support package binds, so that's no real problem. And GEN DDL support runs properly at our site. But we'll need to adapt our GEN development tools prior to upgrading to DB2 10. Hope this is different with your shop.


Best regards,
Peter

_______________________
Peter Suhner
[login to unmask email]


Please consider the environment instead of printing this message




> Date: Fri, 14 Jan 2011 15:05:00 +1100
> From: [login to unmask email]
> Subject: Re: [DB2-L] DB2 V10 and COOL:Gen 6 [SEC=UNCLASSIFIED]
> To: [login to unmask email]
>
> I can't think of any reason why it would be a problem. We are in the
> process of going from gen 6.5 to Gen8 whilst at the same time moving
> from db2 v8 to db2v9 (we like the excitement)
>
> Old Gen will generate 'old' SQL and as db2 is good at backwards
> compatibility I don't think that would be an issue.
>
> An area that may need more attention is z/os versions. I seem to recall
> we had problems with Gen/Websphere/z-os at version 6 with db2v7 but as
> you are beyond that point it is obviously not an issue. Even so I'd
> talk with CA and IBM about possible mismatches with z-os and Gen.
>
> Moving _Gen_ forward has more problems due to changes from load modules
> to DLLs and mixing two Gens at one level is a no-no.
>
> HTH
>
> Steve T
>
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of William
> Powers
> Sent: Friday, 14 January 2011 7:11 AM
> To: [login to unmask email]
> Subject: [DB2-L] DB2 V10 and COOL:Gen 6
>
> We are currently looking into upgrading our DB2 subsystems from V8 to
> V10 and wanted to see if any shops have had any experience or issues
> running COOL:Gen 6 in DB2 V10 code.
>
> Any feedback would be greatly appreciated.
>
>
> William Powers
> Sr Systems Programmer
> Labcorp
>
> _____________________________________________________________________
> * 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! *
> ** DB2 certification -> no additional charge
> ** Meet fellow DB2 users and leading DB2 consultants
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv
>
> ***************************************************************************************************
> IMPORTANT:
>
> * This transmission is intended for the use of the addressee only and might contain sensitive or legally privileged information. If you are NOT the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error, please notify the author immediately by telephone and delete all copies of this transmission together with any attachments.
>
> * The Australian Customs and Border Protection Service DOES NOT AUTHORISE the recipient to further disclose this email or its contents without permission of the originator.
>
> * Unsolicited commercial emails MUST NOT be forwarded to the originator of this transmission unless prior consent has been given.
>
> ***************************************************************************************************
>
> _____________________________________________________________________
> * 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! *
> ** DB2 certification -> no additional charge
> ** Meet fellow DB2 users and leading DB2 consultants
> _____________________________________________________________________
>
> 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
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