Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

character setting configuration into DB2 for Z/OS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 42
Location: Bangalore

PostPosted: Thu Nov 05, 2015 11:37 am    Post subject: character setting configuration into DB2 for Z/OS
Reply with quote

Dear All,

i have been asked this Question.
We are using your z/OS DB2 database for developing and testing one of our product.
We found that this database is special with its character setting to be JAPAN EBCDIC DB. And this setting make us failed to retrieve GRAPHIC AND LOB datatype values with other language(like Chinese) characters.

So, could you help us do some configuration for implicit character conversion. This action requires admin user privilege.

Another thing we know is that this database’s MCCSID is 24876, but I didn’t find its GCCSID or ASCCSID.

Also if you want to test the setting is effective or not, please verify the
result of this query “select * from GRAPHIC_TB;” to be readable.

**************************************************
I have suggested them
1. Create a table with CCSID as UNICODE.
2 . In order to get the data in a readable format do casting for the columns

Now they are able to see the data properly. but they want know the following
1. is there any way to handle the Default Encoding table.
2. adding implicit character conversion .( i have never done this before).

Since most of the senior resources are Voluntary retirements. so i have to handle all the responsibility.

Any suggestions or pointers will be very Helpful.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Thu Nov 05, 2015 9:04 pm    Post subject:
Reply with quote

Haven't below link helped?
https://www-01.ibm.com/support/knowledgecenter/#!/SSEPEK_11.0.0/com.ibm.db2z11.doc.char/src/tpc/db2z_storeunicodedata.dita
Back to top
View user's profile Send private message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 42
Location: Bangalore

PostPosted: Thu Nov 05, 2015 10:26 pm    Post subject:
Reply with quote

This may be helpful in the Future but ar of now i am looking out for those 2 things
1. How to change the Default encoding Scheme E to U.( what i have understood is during installation of DB2 the Default Encoding Scheme should be decided in our case it is E. )
there should be someway to change this. ( since my tso id is having all the privileges i can give a try )

2. could you help us do some configuration for implicit character conversion.

Warm Regards,
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Thu Nov 05, 2015 10:53 pm    Post subject:
Reply with quote

1.May be you should look for ENCODING_SCHEME col in SYSIBM.SYSDATABASE table to change it.
2.Please check upon,
http://www-01.ibm.com/software/data/db2/zos/resources.html
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/download/IEA2UN50.pdf
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Nov 05, 2015 11:08 pm    Post subject: Reply to: character setting configuration into DB2 for Z/OS
Reply with quote

Quote:
Since most of the senior resources are Voluntary retirements. so i have to handle all the responsibility.

thats what happens with workforce realignment icon_cool.gif
Quote:
voluntary
icon_lol.gif icon_lol.gif icon_lol.gif
Back to top
View user's profile Send private message
sakthikumarT

New User


Joined: 09 Apr 2009
Posts: 42
Location: Bangalore

PostPosted: Tue Nov 17, 2015 10:58 am    Post subject:
Reply with quote

Hi All,
I have Found few Information.

The UCS customization process includes the following six steps:

1.Get the original conversion table in text mode.
2.Customize the conversion table in text mode.
3.Generate the binary conversion table.
4.Apply the conversion table to the system.
5.Update the z/OS system for the next IPL.
6.Update the application runtime environment to pick up the new conversion table.

Please let me know your comments.

Warm Regards
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. DSList (3.4) cannot display Chinese c... jacobdng TSO/ISPF 4 Wed Oct 05, 2016 2:51 pm
No new posts Continuation Character ballaswaroop SYNCSORT 8 Thu Aug 25, 2016 4:46 pm
No new posts XFACILIT class setting for Fault Anal... egrove IBM Tools 2 Thu Aug 11, 2016 8:02 pm
No new posts Adding a descending character to a file Steve Ironmonger DFSORT/ICETOOL 3 Fri Jul 15, 2016 4:57 pm
No new posts Moving character data to smallint in db2 rikdeb DB2 5 Thu Jul 14, 2016 12:38 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us