| Author |
Message
|
| kkr |
 Posted: Mon Jan 11, 2010 10:18 am Post subject: CCSID problem on AS400 qmgr |
 |
|
Novice
Joined: 17 Dec 2009
Posts: 15
|
I am unable to add a qmgr to cluster.Created a clusrcvr poiting to itself and clussdr chl poiting to FR but see objects starting with syste.temp when i use dis clusqmgr. Verified all the parameters used to create channel are correctly specified..,incl port number.
Found that clussdr chl is stopped staus once it has been created and when started, found the following error on FR
================
AMQ6047: Conversion not supported.
EXPLANATION:
WebSphere MQ is unable to convert string data tagged in CCSID 420 to
data in
CCSID 819.
ACTION:
Check the WebSphere MQ Application Programming Reference Appendix and
the
appropriate National Language Support publications to see if the CCSIDs
are
supported by your system.
===========================
The queue manager which i try to add is having CCSID 420 on AS400 server. So i suspect this could be the reason for qmgr ot to be visible in cluster..can you please help...
Thanks. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Mon Jan 11, 2010 10:39 am Post subject: Re: CCSID problem on AS400 qmgr |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kkr wrote: |
can you please help...
|
Well the obvious solution is to have 420 / 819 conversion installed on the box running the FR. Might not be the easiest solution depending on the views of the box admin involved, but presumably you're going to need this for messages following through the cluster as well.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| kkr |
| Posted: Mon Jan 11, 2010 6:38 pm Post subject: |
|
|
Novice
Joined: 17 Dec 2009
Posts: 15
|
Thanks for the reply. Yes,the box on which FR qmgr is hosted is connected to many production sites and any changes on it is complex.
What i do observe is that the AS400 qmgr in question has CCSID 420 where as the remaming AS400 qmgrs which are able to connect successfully have 37as the CCSID. I am wondering whether CCSID 420 is supported by iSeries WMQ. can the ccsid of the qmgr be cahnged to a value that can be converted?  |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Jan 11, 2010 6:54 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
So you got arabic ebcdic? Apart from installing CCSID 819 on the box and checking if the conversion is supported, if need be creating the conversion table I do not see what else can be done.
As an alternate you might want to check if CCSID 500 EBCDIC international might be of help to you....
Or you might want to translate not to ccsid 819 (AIX) but to CCSID 1208 (UTF-8 ) which should allow for representation of Arabic Characters...
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Jan 11, 2010 7:47 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kkr wrote: |
| I am wondering whether CCSID 420 is supported by iSeries WMQ. can the ccsid of the qmgr be cahnged to a value that can be converted? |
AFAIK iSeries is like all other platforms - the queue manager uses whatever code page the hosting platform is set to. So the answer to your question is does the server hosting this queue manager support a code page which can be converted? Remember that both code pages and conversions are dependent on what the server will support (hence my suggestion to install the correct conversion on the receiving server).
This is of course a variation of the advice of my esteemed associate.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Mon Jan 11, 2010 7:58 pm Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| Quote: |
| ...successfully have 37 as the CCSID |
Codepage 037 is the perennial mainframe/as400/iseries ebcdic codepage.
Chapter 10 of the APR has code page conversion charts.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| kkr |
| Posted: Tue Jan 12, 2010 1:46 am Post subject: |
|
|
Novice
Joined: 17 Dec 2009
Posts: 15
|
Ok, so if my understanding is correct, the conversion table for converting CCSID420 to 819 needs to be created/installed on the receiving end(in this case unix) ? 
If yes, then please let me know if there is any documentation available on how this can be done..Thanks again |
|
| Back to top |
|
|
| zonko |
| Posted: Tue Jan 12, 2010 2:13 am Post subject: |
|
|
Voyager
Joined: 04 Nov 2009
Posts: 78
|
There is no conversion possible between 420 (Arabic EBCDIC) and 819 (English ASCII).
The AS400 qmgr has to use a different codepage, one which it is possible to convert to 819. The suggestion above is to use 1208 (Unicode variable size) on either qmgr. |
|
| Back to top |
|
|
| kkr |
| Posted: Tue Jan 12, 2010 3:02 am Post subject: |
|
|
Novice
Joined: 17 Dec 2009
Posts: 15
|
| Quote: |
| The AS400 qmgr has to use a different codepage, one which it is possible to convert to 819. |
any suggestions as to how this can be done please ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Jan 12, 2010 6:05 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kkr wrote: |
| If yes, then please let me know if there is any documentation available on how this can be done.. |
Ask whoever administers the server. They'll have a procedure, and in most cases they'll need to perform the work given the access typically required.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Jan 12, 2010 6:06 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kkr wrote: |
| Quote: |
| The AS400 qmgr has to use a different codepage, one which it is possible to convert to 819. |
any suggestions as to how this can be done please ? |
Again, speak to the AS400 sys progs.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| kkr |
| Posted: Wed Jan 13, 2010 11:09 am Post subject: |
|
|
Novice
Joined: 17 Dec 2009
Posts: 15
|
| what effect does altering the CCSID of the qmgr and restarting it have ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jan 13, 2010 11:13 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kkr wrote: |
| what effect does altering the CCSID of the qmgr and restarting it have ? |
If I said "it changes the CCSID the queue manager uses", would you believe me?
I don't understand the question. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Wed Jan 13, 2010 1:54 pm Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
| Quote: |
| The AS400 qmgr has to use a different codepage, one which it is possible to convert to 819. |
Changing a qmgr codepage might be an option, but with possible implications to existing apps.
As a work-around, you could create a new qmgr (a mediating qmgr) with a codepage that does support conversion to a codepage that supports 819.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
|
|
