ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Support for new code page set to 1047 on Unix MQ

Post new topic  Reply to topic
 Support for new code page set to 1047 on Unix MQ « View previous topic :: View next topic » 
Author Message
Sam Uppu
PostPosted: Tue Aug 17, 2010 7:34 am    Post subject: Support for new code page set to 1047 on Unix MQ Reply with quote

Yatiri

Joined: 11 Nov 2008
Posts: 610

Hi Guys,
We are running MQ and Broker on AIX 6.1.

MQ v7.0.1.1 and MB 7.0.0.1

Right now the messageflows are written with codepage set to 1047 by some third party vendor. Now we wanted to deploy those flows onto our broker running on AIX. To support this code page set to 1047, I wanted to ALTER QMgr ccsid to either 37. I believe the equivalent CCSID for 1047 code page set is 37 (US).

When I try to modify the QMgr with alter command, it is complaining that:

Quote:
alter qmgr ccsid(37)
1 : alter qmgr ccsid(37)
AMQ7090: The queue manager CCSID is not valid.

:
alter qmgr ccsid(1047)
2 : alter qmgr ccsid(1047)
AMQ7090: The queue manager CCSID is not valid.


I see the CCSID listed in '/var/mqm/conv/table/ccsid.tbl'

Quote:
# CCSID Base CodePage CodePage Type Enc ACRI Codeset
# CCSID DBCS SBCS name
# ----- ----- -------- -------- ---- ---- ----- -------
819 819 0 819 1 3 0 ISO8859-1
923 923 0 923 1 3 0 ISO8859-15
1051 1051 0 1051 1 3 0 IBM-1051
1252 1252 0 1252 1 2 0 IBM-1252
5348 5348 0 5348 1 2 0 IBM-5348
437 437 0 437 1 2 0 IBM-437
4533 437 0 437 1 2 0 IBM-437
8629 437 0 437 1 2 0 IBM-437
12725 437 0 437 1 2 0 IBM-437
16821 437 0 437 1 2 0 IBM-437
20917 437 0 437 1 2 0 IBM-437
850 850 0 850 1 2 0 IBM-850
4946 850 0 850 1 2 0 IBM-850
33618 850 0 850 1 2 0 IBM-850
61697 850 0 850 1 2 0 IBM-850
61698 850 0 850 1 2 0 IBM-850
858 858 0 858 1 2 0 IBM-858
37 37 0 37 1 1 0 IBM-037
4133 37 0 37 1 1 0 IBM-037
8229 37 0 37 1 1 0 IBM-037
12325 37 0 37 1 1 0 IBM-037
16421 37 0 37 1 1 0 IBM-037
20517 37 0 37 1 1 0 IBM-037
24613 37 0 37 1 1 0 IBM-037
32805 37 0 37 1 1 0 IBM-037


I am not sure whether whether I need to set anything else.

Can you guys throw some light on this?.

Thanks,
Back to top
View user's profile Send private message
zonko
PostPosted: Tue Aug 17, 2010 7:45 am    Post subject: Reply with quote

Voyager

Joined: 04 Nov 2009
Posts: 78

37 is an EBCDIC code page for use on mainframes only
Back to top
View user's profile Send private message
Vitor
PostPosted: Tue Aug 17, 2010 8:08 am    Post subject: Re: Support for new code page set to 1047 on Unix MQ Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

Sam Uppu wrote:
To support this code page set to 1047, I wanted to ALTER QMgr ccsid


Why? Why change the CCSID of the queue manager? Why not just ensure you have a valid conversion from this code page to whatever the queue manager is currently using (which you probably would already)?

Simple, quick and less likely to have side effects for whatever's already running on the queue manager.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
rekarm01
PostPosted: Tue Aug 17, 2010 7:18 pm    Post subject: Re: Support for new code page set to 1047 on Unix MQ Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 1415

Perhaps this should be moved to the WMB forum.

Sam Uppu wrote:
I believe the equivalent CCSID for 1047 code page set is 37 (US).

For ccsid=37, the code page is 37. For ccsid=1047, the code page is 1047. These are not equivalent, nor interchangeable.

Sam Uppu wrote:
alter qmgr ccsid(37)
1 : alter qmgr ccsid(37)
AMQ7090: The queue manager CCSID is not valid.

The WMQ documentation explains the AMQ diagnostic messages in greater detail:
Quote:
Explanation: The CCSID to be used by the QMGR is not valid, because:
  1. It is a DBCS CCSID.
  2. The CCSID encoding is not ASCII or ASCII related. EBCDIC or UCS2 encodings are not valid on this machine.
  3. The CCSID encoding is unknown.


The broker is quite capable of working with EBCDIC directly, independent of the qmgr ccsid.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Tue Aug 17, 2010 7:33 pm    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.

Quote:
Perhaps this should be moved to the WMB forum.

Done.
_________________
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
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Support for new code page set to 1047 on Unix MQ
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.