altering the CCSID parameter for a database

murat umurhan

altering the CCSID parameter for a database
Hello all,

After migrating DB2 for OS/390 from V6 to V7, the CCSID parameter is a problem at our site.
Between 1999-07 and 2000-07 the CCSID parameter in DSNZPARM module was 1026(Turkish).
So the CCSID of the databases that are created during this time is 1026.
The problem is displaying the Turkish characters.

After 2000-07 the CCSID is again 500, and there is no problem on databases that are created after 2000-07.
We solved this problem by writing a conversion table and inserting it to sysibm.sysstrings.

Now, I want to change the CCSID of the databases that has CCSID=1026 to 500.
ALTER DATABASE statement is not working. I stopped the database and also it is not working:

DSNT408I SQLCODE = -20104, ERROR: AN ATTEMPT TO ALTER A CCSID FROM 1026 TO 500
FAILED

How can I alter this value?
Thanks in advance.

PS: After migrating DB2 from V5 to V6 this was not a problem.


==========-
Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda özel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lütfen gönderen kisiyi bilgilendiriniz ve mesaji sisteminizden siliniz. Turkiye Cumhuriyet Merkez Bankasi A.S. bu mesajin icerigi ile ilgili olarak hicbir hukuksal sorumlulugu kabul etmez.

This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. The Central Bank of The Republic of Turkey does not accept legal responsibility for the contents of this message.



Jose Ramon Vazquez

Re: altering the CCSID parameter for a database
(in response to murat umurhan)
Hi Murat,

See the ALTER DATABASE in SQL Reference Manual. You can change only between
specific CCSID.
There are some recommendations here.

Regards.






Murat Umurhan <[login to unmask email]>@LISTSERV.YLASSOC.COM> con fecha
12/12/2002 12:39:15

Por favor, responda a DB2 Data Base Discussion List
<[login to unmask email]>

Enviado por: DB2 Data Base Discussion List <[login to unmask email]>


Destinatarios: [login to unmask email]
CC:
Asunto: altering the CCSID parameter for a database




Hello all,

After migrating DB2 for OS/390 from V6 to V7, the CCSID parameter is a
problem at our site.
Between 1999-07 and 2000-07 the CCSID parameter in DSNZPARM module was
1026(Turkish).
So the CCSID of the databases that are created during this time is 1026.
The problem is displaying the Turkish characters.

After 2000-07 the CCSID is again 500, and there is no problem on databases
that are created after 2000-07.
We solved this problem by writing a conversion table and inserting it to
sysibm.sysstrings.

Now, I want to change the CCSID of the databases that has CCSID=1026 to
500.
ALTER DATABASE statement is not working. I stopped the database and also it
is not working:

DSNT408I SQLCODE = -20104, ERROR: AN ATTEMPT TO ALTER A CCSID FROM 1026 TO
500
FAILED

How can I alter this value?
Thanks in advance.

PS: After migrating DB2 from V5 to V6 this was not a problem.


==========-
Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda özel
haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lütfen gönderen
kisiyi bilgilendiriniz ve mesaji sisteminizden siliniz. Turkiye Cumhuriyet
Merkez Bankasi A.S. bu mesajin icerigi ile ilgili olarak hicbir hukuksal
sorumlulugu kabul etmez.

This e-mail communication is intended for the private use of the persons
named above. If you received this message in error, please immediately
notify the sender and delete it from your system. The Central Bank of The
Republic of Turkey does not accept legal responsibility for the contents of
this message.


visit
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can










Amit Sinha

Re: altering the CCSID parameter for a database
(in response to Jose Ramon Vazquez)
Hi,

We went thru the same pain when the CCSID got changed from 37 to 500 when we
moved to version 7.

-We contacted IBM and they gave us a usermod using which we could alter the
CCSID of the Tablespaces and the Databases
but it invalidates the plan & packages dependent on it and u need to rebind
the plan & packages with the new parameter in bind REBIND PLAN(XXXX)
ENCODING(XXX). They have a document outlining the steps u may want to talk
to them.

-Or if your subsystem is now set with the CCSID you can unload data with the
utility DSNTIAUL (the plan DSNTIB71 should have the same CCSID as the
tablespace) and then drop and recreate the object and then do a load of the
data by doing CCSID conversion in the LOAD card. And then rebinding the plan
and packages dependent on the Tablespace with the CCSID same as Tablespace.

This is what worked for us. You may want to verify with IBM or check in ur
site if this will work.

Thanks.

Amit


-----Original Message-----
From: Murat Umurhan [mailto:[login to unmask email]
Sent: Thursday, December 12, 2002 5:39 AM
To: [login to unmask email]
Subject: altering the CCSID parameter for a database


Hello all,

After migrating DB2 for OS/390 from V6 to V7, the CCSID parameter is a
problem at our site.
Between 1999-07 and 2000-07 the CCSID parameter in DSNZPARM module was
1026(Turkish).
So the CCSID of the databases that are created during this time is 1026.
The problem is displaying the Turkish characters.

After 2000-07 the CCSID is again 500, and there is no problem on databases
that are created after 2000-07.
We solved this problem by writing a conversion table and inserting it to
sysibm.sysstrings.

Now, I want to change the CCSID of the databases that has CCSID=1026 to 500.
ALTER DATABASE statement is not working. I stopped the database and also it
is not working:

DSNT408I SQLCODE = -20104, ERROR: AN ATTEMPT TO ALTER A CCSID FROM 1026 TO
500
FAILED

How can I alter this value?
Thanks in advance.

PS: After migrating DB2 from V5 to V6 this was not a problem.


==========-
Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda özel
haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lütfen gönderen
kisiyi bilgilendiriniz ve mesaji sisteminizden siliniz. Turkiye Cumhuriyet
Merkez Bankasi A.S. bu mesajin icerigi ile ilgili olarak hicbir hukuksal
sorumlulugu kabul etmez.

This e-mail communication is intended for the private use of the persons
named above. If you received this message in error, please immediately
notify the sender and delete it from your system. The Central Bank of The
Republic of Turkey does not accept legal responsibility for the contents of
this message.


visit the





Jose Moreno

Re: altering the CCSID parameter for a database
(in response to Amit Sinha)
Hi,

The only allowed modifications of CCSID for a DB or a TS is between
compatibles CCSID.
compatible CCSID are for example 297 and 1147 (Freench EBCDIC and French
EBCDIC + Euro sign). In fact the only allowed modifications of CCSIDs are
between sames codepages, but with or without the Euro sign.

At the creation of the DB or the TS, the CCSID parameter is the codeset
(EBCDIC, ASCII, UNICODE), the codepage for the object created is the
"default" codepage for the codeset in DSNHDECP. If you default to CCSID 500
for EBCDIC in DSNHDECP, all your objects created with CCSID EBCDIC will have
a CCSID of 500. And then since there is no "compatible" CCSID for 500. You
will never be allowed to change your codepage with ALTER.

The only way to modify a CCSID of an object is :

UNLOAD
DROP
modify DSNHDECP
recycle DB2
CREATE
LOAD

But you should never have a mix of CCSIDs of the same codeset on the same
subsystem !!!!

----- Original Message -----
From: "Murat Umurhan" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Thursday, December 12, 2002 12:39 PM
Subject: altering the CCSID parameter for a database


> Hello all,
>
> After migrating DB2 for OS/390 from V6 to V7, the CCSID parameter is a
problem at our site.
> Between 1999-07 and 2000-07 the CCSID parameter in DSNZPARM module was
1026(Turkish).
> So the CCSID of the databases that are created during this time is 1026.
> The problem is displaying the Turkish characters.
>
> After 2000-07 the CCSID is again 500, and there is no problem on databases
that are created after 2000-07.
> We solved this problem by writing a conversion table and inserting it to
sysibm.sysstrings.
>
> Now, I want to change the CCSID of the databases that has CCSID=1026 to
500.
> ALTER DATABASE statement is not working. I stopped the database and also
it is not working:
>
> DSNT408I SQLCODE = -20104, ERROR: AN ATTEMPT TO ALTER A CCSID FROM 1026
TO 500
> FAILED
>
> How can I alter this value?
> Thanks in advance.
>
> PS: After migrating DB2 from V5 to V6 this was not a problem.
>
>
> ==========-
> Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda özel
haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lütfen gönderen
kisiyi bilgilendiriniz ve mesaji sisteminizden siliniz. Turkiye Cumhuriyet
Merkez Bankasi A.S. bu mesajin icerigi ile ilgili olarak hicbir hukuksal
sorumlulugu kabul etmez.
>
> This e-mail communication is intended for the private use of the persons
named above. If you received this message in error, please immediately
notify the sender and delete it from your system. The Central Bank of The
Republic of Turkey does not accept legal responsibility for the contents of
this message.
>
>
>


>