| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Logging |
« View previous topic :: View next topic » |
| Author |
Message
|
| Biju |
 Posted: Fri Feb 24, 2006 5:06 am Post subject: Logging |
 |
|
Acolyte
Joined: 03 Oct 2005
Posts: 71
|
Hi all,
| Quote: |
| 6. Primary log files are made available for reuse during a checkpoint. The queue manager takes both the primary and secondary log space into consideration before taking a checkpoint because the amount of log space is running low. If you do not define more primary log files than secondary log files, the queue manager might allocate secondary log files before a checkpoint is taken. This makes the primary log files available for reuse. |
I have read this from system admin document and its kind of confusing me. If I define 2 primary and 3 log files and the first two logs become full what will happen? Does the document mean that the primary logs will be over written?
Thank you for your help.
Cheers
Biju |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Feb 24, 2006 5:40 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Active transactions should never be overwritten.
What it's telling you is that new transactions can flow into secondary log files in cases where empty space in the primary log files would normally be used. So if you have a transaction that uses, say, 60% of your primary log files, and you start another transaction that will use 60%. During the second transaction, the first one commits, so that space is available to be reused. But where you have fewer primary logs than secondary logs, the second transaction will still flow into secondary logs. When you have more primary logs, then a checkpoint can occur and the space in the primary logs will get reused.
At least, that's the way I read it. It may be that inflight transactions will always get rolled over to secondary logs - so pretend that the second transaction was actually two transactions that took 30%.
But if the first transaction doesn't commit during the life of the second, then the secondary logs will always get used.
_________________
I am *not* the model of the modern major general.
Last edited by jefflowrey on Fri Feb 24, 2006 5:56 am; edited 1 time in total |
|
| Back to top |
|
|
| Biju |
| Posted: Fri Feb 24, 2006 5:54 am Post subject: |
|
|
Acolyte
Joined: 03 Oct 2005
Posts: 71
|
Thank you Jeff for a quick reply. 
Regards,
Biju |
|
| 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
|
|
|
|
