| Author |
Message
|
| roccks |
 Posted: Wed May 12, 2004 11:25 am Post subject: mqllm (qmgr log support pack) not consistant |
 |
|
Novice
Joined: 15 May 2003
Posts: 12
|
I can run this several times and it fails to recognize that logs are ready to be migrated off. I run it 5 minutes later, without making changes, and it suddenly finds 500 logs to migrate off. I first run rcrdcmqimg then the support pack mqllm. Any idea's of why it does not find logs the first 5 times I run the mqllm? Much thanks
Windows 5.3.4 |
|
| Back to top |
|
 |
| mqonnet |
| Posted: Wed May 12, 2004 11:31 am Post subject: |
|
|
Grand Master
Joined: 18 Feb 2002
Posts: 1114
Location: Boston, Ma, Usa.
|
Havent heard nor used this support pack. But if this support pack does not believe that the logs are ready to be migrated then most likely they are still in use. What return/error code do you get when you run this support pack.
Very much possible that whatever UOW or any write operation that was going on was using these logs, which finished after 5 minutes.
Just a thought.
Cheers
Kumar
_________________
IBM Certified WebSphere MQ V5.3 Developer
IBM Certified WebSphere MQ V5.3 Solution Designer
IBM Certified WebSphere MQ V5.3 System Administrator |
|
| Back to top |
|
|
| roccks |
| Posted: Wed May 12, 2004 11:43 am Post subject: Thanks. |
|
|
Novice
Joined: 15 May 2003
Posts: 12
|
No return codes. Just a reply stating "There are no logs to be migrated off"
While I thought that a Unit of Work may still be in progress, it would be hard to justify it finding 500 logs just 5 minutes later. The UOW would not be writing to each one of those 497 logs. Those logs had dates of a week ago. Perhaps 1 or 2 of todays work maybe...Thanks again. |
|
| Back to top |
|
|
| mqonnet |
| Posted: Wed May 12, 2004 11:48 am Post subject: |
|
|
Grand Master
Joined: 18 Feb 2002
Posts: 1114
Location: Boston, Ma, Usa.
|
Couple of things.
-If there is a UOW that has been there for a long time, then you may end up with a checkpoint that spans more logs.
-May be this utility waits for all UOW's to be over before it attempts to back them up. Which kind of makes sense. Because if it starts backing up and has done 497, but 3 of those are still in use, then the whole backup operation would fail. Since you want a complete consistency in the backup. All or none.
So, from the above two, i would go with the latter being the most possible reason.
Btw, where did you get this util from and for which platform. I couldnt find it on the IBM support site. :) May be its named differntly than what you referred as mqllm.
Cheers
Kumar
_________________
IBM Certified WebSphere MQ V5.3 Developer
IBM Certified WebSphere MQ V5.3 Solution Designer
IBM Certified WebSphere MQ V5.3 System Administrator |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed May 12, 2004 12:00 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Well, if he's using rcrdcmqimg, then his QM should be stopped. Otherwise it won't really work.
So there shouldn't be transactions that are in use, unless he hasn't allowed the QM to stop completely before he tries to run his log roller.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mqonnet |
| Posted: Wed May 12, 2004 12:12 pm Post subject: |
|
|
Grand Master
Joined: 18 Feb 2002
Posts: 1114
Location: Boston, Ma, Usa.
|
Jeff, what is rcrdcmqimg. I thought roccks misspelt it to for rcdmqimg, which one could run when the qmgr is active.
From the manuals.
"You use this command with an active queue manager. Further activity on the queue manager is logged so that, although the image becomes out of date, the log records reflect any changes to the object.
"
If it is rcrmqobj.
"Use this command on a running queue manager. All activity on the queue manager after the image was recorded is logged. To re-create an object, replay the log to re-create events that occurred after the object image was captured."
In any case, i believe its the 2nd point of my previous post that co-relates to roccks problem.
Just a thought.
BTW have you heard of this util. New to me.:)
Cheers
Kumar
_________________
IBM Certified WebSphere MQ V5.3 Developer
IBM Certified WebSphere MQ V5.3 Solution Designer
IBM Certified WebSphere MQ V5.3 System Administrator |
|
| Back to top |
|
|
| roccks |
| Posted: Wed May 12, 2004 12:14 pm Post subject: |
|
|
Novice
Joined: 15 May 2003
Posts: 12
|
It is IBM Support pack MS62 MS67 or MSOL. I am not sure which one I downloaded last year.
The UOW is a request reply model that would never have a long running transaction.
And actually the qmgr has to be up, or the record image media job will fail.
Thanks again |
|
| Back to top |
|
|
| mqonnet |
| Posted: Wed May 12, 2004 12:16 pm Post subject: |
|
|
Grand Master
Joined: 18 Feb 2002
Posts: 1114
Location: Boston, Ma, Usa.
|
"The UOW is a request reply model that would never have a long running transaction"
---What do you mean by that. Transactions could be as long as you want, of course there are limits. Such as the transaction co-ordinator not allowing transactions stay alive after a certain period of time, or may be you filling up the logs within a UOW etc...
Cheers
Kumar
_________________
IBM Certified WebSphere MQ V5.3 Developer
IBM Certified WebSphere MQ V5.3 Solution Designer
IBM Certified WebSphere MQ V5.3 System Administrator |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed May 12, 2004 12:56 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| mqonnet wrote: |
| Jeff, what is rcrdcmqimg. I thought roccks misspelt it to for rcdmqimg, which one could run when the qmgr is active. |
It was his mispelling that I was using.
And I thought it was the rcdmqimg that had to be run against a stopped QM, but I guess I was wrong.
That's what I get for posting an answer to a MQSeries question while otherwise wearing my DB2 hat.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Simon McAlister |
| Posted: Thu May 13, 2004 5:58 pm Post subject: Event log has a delay before issuing |
|
|
Novice
Joined: 05 May 2004
Posts: 11
|
| I had a similar problem using my own batch file to archive unneeded logs. If the support pac is checking for message 7468 in the event log then there is some delay between when the rcdmqimg is run and the message is written to the event log. On our machine it seemed to write an event about every 5-6 minutes regardless of whether a rcdmqimg had been issued. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu May 13, 2004 6:00 pm Post subject: Re: Event log has a delay before issuing |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Simon McAlister wrote: |
| On our machine it seemed to write an event about every 5-6 minutes regardless of whether a rcdmqimg had been issued. |
That's a checkpoint. You must have some volume, they come at intervals based on message traffic levels.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
