| Author |
Message
|
| ucbus1 |
 Posted: Wed Dec 31, 2003 10:54 am Post subject: Error: AMQ7469: Transactions rolled back to release log spac |
 |
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
we are getting
AMQ7469: Transactions rolled back to release log space.
EXPLANATION:
The log space for the queue manager is becoming full. One or more long-running
transactions have been rolled back to release log space so that the queue
manager can continue to process requests.
ACTION:
Try to ensure that the duration of your transactions is not excessive. Consider
increasing the size of the log to allow transactions to last longer before the
log starts to become full.
How do we make duration of your transactions is not excessive?
how do we increase the size of the log? Where is it located? |
|
| Back to top |
|
 |
| Prahasith |
| Posted: Wed Dec 31, 2003 11:09 am Post subject: |
|
|
Disciple
Joined: 16 May 2003
Posts: 184
Location: Kansas City
|
you can create a dummy qmgr with larger log files and then copy
those larger logs and amqhlctl.lfh file from the dummy qmgr to the
existing qmgr to replace the existing logs. you have to be sure to
not change permissions or ownership of those files from the values on
the current files. you also will need to change the mqs.ini
LogDefaults: stanza to make the LogFilePages match the size of the
new logs. (of course you will need to end the qmgr before making any
changes) |
|
| Back to top |
|
|
| ucbus1 |
| Posted: Wed Dec 31, 2003 11:36 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
Thanks Prahasit,
Could you please tell me where actually this log is located?
Is that possible to rename the log.. just in case of AMQ7469 error?. This I am asking what I can do.... before I can get help from our AIX(MQ) folks
Thanks |
|
| Back to top |
|
|
| Prahasith |
| Posted: Wed Dec 31, 2003 11:48 am Post subject: |
|
|
Disciple
Joined: 16 May 2003
Posts: 184
Location: Kansas City
|
you need to work this out with your MQ folks
the log is located under the directory
var/mqm/log/qmname/active/S0000000.LOG, S0000001.LOG, S0000002.LOG.
var/mqm/log/qmname/amqhlctl.lfh
This is IBM recommended solution. |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Dec 31, 2003 12:10 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| You can also increase the number of primary and secondary log files. You should do this in the qm.ini file (/var/mqm/<QMGRNAME>/qm.ini). I thin a QMGR restart is required. Even for the above solution(from Prahasith), I think a QMGR restart is required(but I am not sure). |
|
| Back to top |
|
|
| ucbus1 |
| Posted: Wed Dec 31, 2003 12:46 pm Post subject: |
|
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
Thanks vennela and Prahasit
One more question
Is it possible to move the logs to some other folder when ever I find this error? These logs need to be there for the qmanager for tracking internally?
Thanks |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Dec 31, 2003 1:19 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Quote: |
| increase the number of primary and secondary log files |
For this you don't have to copy the files, because you are not deleting them.
| Quote: |
var/mqm/log/qmname/active/S0000000.LOG, S0000001.LOG, S0000002.LOG.
var/mqm/log/qmname/amqhlctl.lfh
|
For this solution, it is always a good idea to move the files rather than delete the files. |
|
| Back to top |
|
|
| ucbus1 |
| Posted: Tue Jan 06, 2004 2:45 pm Post subject: |
|
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
vennela,
Just to make sure I understand it right.
Suppose if the number of logs are mentioed as five. Then if I find five logs (which means I am reaching maximum limiet), you mean I can move the logs located at /var/mqm/log/FMCQM/active to some other directory?
Here is another observation.
I find the number of logs varay during the time when Workflow is processing. I can understand the logs number increasing, but what makes the number decrease? Is it done by clean up server? But in our case clean up server is not running.
We are running into this error quite often because of our increased number of work instance due to year end processing.We get this error first and then users just timeout. The only we could get it back is to "sto/start" workflow. Please let me know if something is wrong
Thanks |
|
| Back to top |
|
|
| vennela |
| Posted: Tue Jan 06, 2004 4:25 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| Quote: |
| Suppose if the number of logs are mentioed as five. Then if I find five logs (which means I am reaching maximum limiet), you mean I can move the logs located at /var/mqm/log/FMCQM/active to some other directory? |
Yes.
| Quote: |
| I find the number of logs varay during the time when Workflow is processing. I can understand the logs number increasing, but what makes the number decrease? |
I have never seen them decreasing but now that you say so I have to believe it. But, does that happen when the Queue Manager is running or when the Queue Manager is restarted.
| Quote: |
| Is it done by clean up server? |
NO, |
|
| Back to top |
|
|
|
|
