Version 8 migration - UTF 8 characters, CCSID changes.

William Kloote

Version 8 migration - UTF 8 characters, CCSID changes.
Hello Listers,

We are DB2 V 7 on Z/OS and migrating to V 8. Our database objects are created with CCSID as EBCDIC. 

What are all the tasks we have to perform in case if we have international characters/UTF-8?. Do we need to change the DB2 objects CCSID to UNICODE or any specific tasks are needed from database or application point of view to accomodate all international characters?

Thanks in advance!

Thanks
William




______________________________________________________________________

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




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Philip Sevetson

Re: Version 8 migration - UTF 8 characters, CCSID changes.
(in response to William Kloote)
I don't know if IBM is still doing this, but...

When we started converting, IBM advised us to open a PMR on converting
to UNICODE. There are a bunch of queries to be run and a bunch of steps
to be taken. Since DB2V7 is out of support, I don't know if they're
doing that any more.



--Phil



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of William Kloote
Sent: Wednesday, January 07, 2009 10:40 AM
To: [login to unmask email]
Subject: [DB2-L] Version 8 migration - UTF 8 characters, CCSID changes.



Hello Listers,



We are DB2 V 7 on Z/OS and migrating to V 8. Our database objects are
created with CCSID as EBCDIC.



What are all the tasks we have to perform in case if we have
international characters/UTF-8?. Do we need to change the DB2 objects
CCSID to UNICODE or any specific tasks are needed from database or
application point of view to accomodate all international characters?



Thanks in advance!



Thanks

William




________________________________

IDUG 2009 - North America * May 11-15 * Denver, Colorado, USA
< http://idug.org/lsna >

IDUG.org < http://www.idug.org > was recently updated requiring members
to use a new password. You should have gotten an e-mail with the
temporary password assigned to your account. Please log in and update
your member profile. If you are not already an IDUG.org member, please
register here. < http://www.idug.org/component/juser/register.html >



=========
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/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Hanne Lyssand

Re: Version 8 migration - UTF 8 characters, CCSID changes.
(in response to Philip Sevetson)
From the top up my head about this subject, we are in v9 NFM no so it's been a while.

You don't have to and I will not recommend you to change any the ccsid's as a part of the migration. DB2 catalog will be in Unicode, so you have to understand what Unicode is .

If you for some reason have tables, columns, tablespace with national characters in the name be aware. Sort order is different in Unicode, and you may have some applications/programs based on catalog information. I remember that we hade to change some SAS-code to use external sort instead of order by in the SQL.

DBRM's will be in Unicode, if you read them or have any programs that read them, they have to change. We had some programs and had to fore some time use the V7 precompile with V8 DB2. Works fine but is of course just a short time fix.

There is plenty of information out there, and I guess that the IBM people will guide you.

Best regards

Hanne

______________________________________________________________________

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




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Peter Backlund

Re: Version 8 migration - UTF 8 characters, CCSID changes.
(in response to Hanne Lyssand)
Just a minor point regarding V7/V8 precompile.
You can use the V8 precompiler with option NEWFUN(NO)

Peter

Hanne Lyssand wrote:

From the top up my head about this subject, we are in v9 NFM no so it’s been a while.

 

You don’t have to and I will not recommend you to change any the ccsid’s as a part of the migration. DB2 catalog will be in Unicode, so you have to understand what Unicode is .

 

If you for some reason have tables, columns, tablespace with national characters in the name be aware. Sort order is different in Unicode, and you may have some applications/programs based on catalog information. I remember that we hade to change some SAS-code to use external sort instead of order by in the SQL.

 

DBRM’s will be in Unicode, if you read them or have any programs that read them, they have to change. We had some programs and had to fore some time use the V7 precompile with V8 DB2. Works fine but is of course just a short time fix.

 

There is plenty of information out there, and I guess that the IBM people will guide you.

 

Best regards


Hanne



IDUG 2009 - North America * May 11-15 * Denver, Colorado, USA

IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.


No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.10.4/1880 - Release Date: 2009-01-07 08:49
-- Attend IDUG 2009, North America -- 11-15 May in Denver, Colorado Attend IDUG 2009, Europe -- 5- 9 October in Rome, Italy Learn more at http://www.idug.org +-------------------------------+---------------------------------+ | Peter G Backlund | Telephone: 08 - 38 69 08 | | Peter Backlund DB2-Konsult AB | Mobile: 070 - 764 7554 | | Rasundavagen 94 | Country Code (Sweden): 46 | | S-169 57 SOLNA | Skype: BacklundDB2 | | Sweden | E-mail: [login to unmask email] | +-------------------------------+---------------------------------+ | IBM Database GOLD Consultant | +-------------------------------+---------------------------------+ | Working with DB2 since 1981 ... and forever! | +-----------------------------------------------------------------+

IDUG 2009 - North America * May 11-15 * Denver, Colorado, USA

IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.