|   | 
	 
  
    | 
RSS Feed - WebSphere MQ Support
 | 
RSS Feed - Message Broker Support
 |   
 
  
	     | 
	 | 
   
 
  
	|  Support for new code page set to 1047 on Unix MQ | 
	« View previous topic :: View next topic »  | 
   
  
  	
	  
		
		
		  | Author | 
		  Message
		 |  
		
		  | Sam Uppu | 
		  
		    
			  
				 Posted: Tue Aug 17, 2010 7:34 am    Post subject: Support for new code page set to 1047 on Unix MQ | 
				     | 
			   
			 
		   | 
		 
		
		    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 | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | zonko | 
		  
		    
			  
				 Posted: Tue Aug 17, 2010 7:45 am    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		   Voyager
 
 Joined: 04 Nov 2009 Posts: 78
  
  | 
		  
		    
			  
				| 37 is an EBCDIC code page for use on mainframes only | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | Vitor | 
		  
		    
			  
				 Posted: Tue Aug 17, 2010 8:08 am    Post subject: Re: Support for new code page set to 1047 on Unix MQ | 
				     | 
			   
			 
		   | 
		 
		
		    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 | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | rekarm01 | 
		  
		    
			  
				 Posted: Tue Aug 17, 2010 7:18 pm    Post subject: Re: Support for new code page set to 1047 on Unix MQ | 
				     | 
			   
			 
		   | 
		 
		
		   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:- It is a DBCS CCSID.
 - The CCSID encoding is not ASCII or ASCII related. EBCDIC or UCS2 encodings are not valid on this machine.
 - The CCSID encoding is unknown.
 
  | 
   
 
 
 
The broker is quite capable of working with EBCDIC directly, independent of the qmgr ccsid. | 
			   
			 
		   | 
		 
		
		  | Back to top | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | bruce2359 | 
		  
		    
			  
				 Posted: Tue Aug 17, 2010 7:33 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		    Poobah
 
 Joined: 05 Jan 2008 Posts: 9486 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 | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | 
		    
		   | 
		 
	   
	 | 
   
 
  
	     | 
	 | 
	Page 1 of 1 | 
   
 
 
 
  
  	
	  
		
		  
 
  | 
		  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
  | 
  		 
	   
	 | 
   
 
  	 | 
	  |