| Author |
Message
|
| paulgroo |
 Posted: Thu Aug 03, 2006 2:31 am Post subject: The CCSID Blues |
 |
|
Centurion
Joined: 07 Jul 2005
Posts: 138
Location: Ireland
|
Hi,
I was wondering about a CCSID issue that I'm having with a queue manager running on an iSeries system.
We have a java application that creates messages using CCSID1208 and tries to post the messages to a queue manager using CCSID500, but the messages are just stopping on the transmission queue. When I quit the job (because the queue fills up), all the messages are backed out.
Is it possible to use CCSID 1208?
Should I be setting the queue manager to CCSID1208 (although when I try to do this, it tells me that 'this option isnt available' or something)? |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Aug 03, 2006 2:42 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Are you sure the channel's ok? IHMO (based on the last time this blew up in my face) unconvertable messages should go to the DLQ.... 
(Opposing comments welcomed, especially those backed with evidence)
Do you have conversion on the channel, or is it on the get?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| paulgroo |
| Posted: Thu Aug 03, 2006 2:56 am Post subject: Hi there |
|
|
Centurion
Joined: 07 Jul 2005
Posts: 138
Location: Ireland
|
Thanks for the reply!
Yes, I thought it was a bit weird too that they werent dropping into the DLQ. It looks like the Java program is actually just spawning messages onto the the Transmission queue and not transferring them to the Channel. This eventually gets to the point where the queue just fills up and the the program ends (?!). (Pah! I wish I knew some Java coding...)
Normally, this application transfers files to a Windows machine, so the application does the conversion for us.
ie: Files are created; files are then converted to CCSID 500. The queue manager is CCSID 500 and the destination (windows) CCSID is 819. Its only now when theyve started messing about with 1208 that the problem has arisen.
I'm just after setting CONVERT = *YES on the channel so I'll recycle the queue manager and see what happens.
I dunno why I cant specify 1208 as the queue manager CCSID though, maybe it's not supported? I'll have a look about in the IBM maze for that one. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Aug 03, 2006 2:58 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
So, wait.
If you stop the job, the messages are backed out?
Doesn't that mean that the Java program hasn't committed them?
So how could they go anywhere if they aren't committed.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| paulgroo |
| Posted: Thu Aug 03, 2006 3:17 am Post subject: Yes |
|
|
Centurion
Joined: 07 Jul 2005
Posts: 138
Location: Ireland
|
| Yes, it seems that the messages arent getting committed. The only difference in the configuration is that when the files are sent using CCSID500 everything works grand, but with 1208 it doesnt work. I've tried changing the queue manager CCSID to various different settings but it still stays the same. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Aug 03, 2006 3:24 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
So with CCSID 500 the messages are committed, go to their destination and do whatever it is that they do? With 1208 they don't even get committed? That's not just weird it's bizarre (and embarassing I didn't pick it up in your first post  )
What's the programmed scope of the UOW in the Java programme?
Changing the channel CONVERT only requires the channel to be stopped and restarted, though recycling the queue manager never hurts.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Aug 03, 2006 3:33 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There is (and this is where markt pops in and corrects me) no way that the CCSID can affect the success of a properly issued commit.
The CCSID of the remote queue manager has no bearing here. If the messages are uncommitted on the transmit queue, then the MCA on the sending side hasn't touched them yet and the remote CCSID is irrelevant.
This is squarely an issue with the Java program failing to issue a commit when it needs to.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| paulgroo |
| Posted: Thu Aug 03, 2006 3:36 am Post subject: Sorry... |
|
|
Centurion
Joined: 07 Jul 2005
Posts: 138
Location: Ireland
|
It's my turn to be embarrassed now  What do you mean UOW?
(I did a google search and only found University Of Wollongong...) |
|
| Back to top |
|
|
| paulgroo |
| Posted: Thu Aug 03, 2006 3:39 am Post subject: Ah ok... |
|
|
Centurion
Joined: 07 Jul 2005
Posts: 138
Location: Ireland
|
So it sounds like the Java code is written to specifically handle certain CCSID's...
I think I'm trying to overcompensate for this by changing the CCSID of the queue manager. I'll test of a few different queue managers CCSIDs and see what happens.
I hate it when contractors write code and then bog off.... |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Aug 03, 2006 3:42 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Sorry - Unit Of Work. It's (I thought ) a common terms for the group of operations finalised by a commit. For instance, reading a message, updating a database & sending a reply would be a single unit of work because you want them all to succeed or all to fail.
Basically, how many messages do you think your program should process before committing?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Aug 03, 2006 3:45 am Post subject: Re: Ah ok... |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| paulgroo wrote: |
| So it sounds like the Java code is written to specifically handle certain CCSID's... |
I can't imagine how you could or why you'd bother, but my Java is not far above the "Hello World" level. With luck, someone will offer an informed opinion.
| paulgroo wrote: |
| I hate it when contractors write code and then bog off.... |
I make a point of being a safe distance away when any of my code is implemented ....  
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| paulgroo |
| Posted: Thu Aug 03, 2006 4:02 am Post subject: |
|
|
Centurion
Joined: 07 Jul 2005
Posts: 138
Location: Ireland
|
Thanks for the input all the same!
I'll see if I can track down the developer and torture him (not before finding out some answers though).
Thanks again! |
|
| Back to top |
|
|
| tleichen |
| Posted: Mon Aug 07, 2006 10:15 am Post subject: Re: Hi there |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
| paulgroo wrote: |
...
Normally, this application transfers files to a Windows machine, so the application does the conversion for us.
ie: Files are created; files are then converted to CCSID 500. The queue manager is CCSID 500 and the destination (windows) CCSID is 819. Its only now when theyve started messing about with 1208 that the problem has arisen.
|
I'm probably getting rusty on this and I may be wrong, but if my memory isn't totally blown away, isn't 819 normally a UNIX codeset? As I recall, we always used 437 on Windows...
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
|
|
