Conversion to DB2 v8 NFM and Unicode Catalog

Dave Petronella

Conversion to DB2 v8 NFM and Unicode Catalog
Hi,

We are preparing for upgrading to DB2 v8 New Function Mode. I'm
looking for any experiences that we may need to watch out for as it
pertains to the upgrade to DB2 v8 NFM and the conversion of the catalog to
Unicode, particularly as it pertains to queries against the catalog in
either statically-bound programs or dynamic queries via such tools as
DSNTIAUL, etc. Will the change in catalog column lengths affect any of
these processes adversely?

Thanks in advance for any feedback.


Thanks.
Dave.
x7747


******************************************************
IMPORTANT: Any information contained in this communication is intended for the use of the named individual or entity. All information contained in this communication is not intended or construed as an offer, solicitation, or a recommendation to purchase any security. Advice, suggestions or views presented in this communication are not necessarily those of Pershing LLC nor do they warrant a complete or accurate statement.

If you are not an intended party to this communication, please notify the sender and delete/destroy any and all copies of this communication. Unintended recipients shall not review, reproduce, disseminate nor disclose any information contained in this communication. Pershing LLC reserves the right to monitor and retain all incoming and outgoing communications as permitted by applicable law.

Email communications may contain viruses or other defects. Pershing LLC does not accept liability nor does it warrant that email communications are virus or defect free.
******************************************************

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

Avram Friedman

Re: Conversion to DB2 v8 NFM and Unicode Catalog
(in response to Dave Petronella)
Dave,
Other than
The need for Rebinds
New Sort order
Display / Report dependencies

I personally have not experienced problems or heard complaints about the
changes in the V8 NFM catalog.

I have noticed, however that there are a few examples on the IDUG code
place that create views of the V8 NFM catalog that provide size mapping to
V7.

Best Wishes
Avram Friedman

On Mon, 7 Jan 2008 15:55:43 -0500, [login to unmask email] wrote:

>Hi,
>
> We are preparing for upgrading to DB2 v8 New Function Mode. I'm
>looking for any experiences that we may need to watch out for as it
>pertains to the upgrade to DB2 v8 NFM and the conversion of the catalog to
>Unicode, particularly as it pertains to queries against the catalog in
>either statically-bound programs or dynamic queries via such tools as
>DSNTIAUL, etc. Will the change in catalog column lengths affect any of
>these processes adversely?
>
> Thanks in advance for any feedback.
>
>
>Thanks.
>Dave.
>x7747
>
>
>******************************************************
>IMPORTANT: Any information contained in this communication is intended for
the use of the named individual or entity. All information contained in this
communication is not intended or construed as an offer, solicitation, or a
recommendation to purchase any security. Advice, suggestions or views
presented in this communication are not necessarily those of Pershing LLC nor
do they warrant a complete or accurate statement.
>
>If you are not an intended party to this communication, please notify the
sender and delete/destroy any and all copies of this communication.
Unintended recipients shall not review, reproduce, disseminate nor disclose
any information contained in this communication. Pershing LLC reserves the
right to monitor and retain all incoming and outgoing communications as
permitted by applicable law.
>
>Email communications may contain viruses or other defects. Pershing LLC
does not accept liability nor does it warrant that email communications are
virus or defect free.
>******************************************************
>
>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

Gerald Hodge

Re: Conversion to DB2 v8 NFM and Unicode Catalog
(in response to Avram Friedman)
Sort order can be complicated by the CCSIDs supported. This is more an out
of the US issue but you should be aware. If your code is dependant upon
sequencing from a sort and you do not use CCSID 37 or its equivalent then
you may have to switch to an external sort.

Gerald Hodge
HLS Technologies, Inc.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Avram Friedman
Sent: Monday, January 07, 2008 3:41 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Conversion to DB2 v8 NFM and Unicode Catalog

Dave,
Other than
The need for Rebinds
New Sort order
Display / Report dependencies

I personally have not experienced problems or heard complaints about the
changes in the V8 NFM catalog.

I have noticed, however that there are a few examples on the IDUG code
place that create views of the V8 NFM catalog that provide size mapping to
V7.

Best Wishes
Avram Friedman

On Mon, 7 Jan 2008 15:55:43 -0500, [login to unmask email] wrote:

>Hi,
>
> We are preparing for upgrading to DB2 v8 New Function Mode. I'm
>looking for any experiences that we may need to watch out for as it
>pertains to the upgrade to DB2 v8 NFM and the conversion of the catalog to
>Unicode, particularly as it pertains to queries against the catalog in
>either statically-bound programs or dynamic queries via such tools as
>DSNTIAUL, etc. Will the change in catalog column lengths affect any of
>these processes adversely?
>
> Thanks in advance for any feedback.
>
>
>Thanks.
>Dave.
>x7747
>
9:14 AM

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