When you increase log size you need to re-create QMGR where as when you
increase number of logs, it is just a restart.
I must admit, option 3 is probably the best, keep transactions at reasonable
(what is this) size.

Thanx
Emile Kearns


-----Original Message-----
From: Marty Frasier [mailto:[EMAIL PROTECTED]
Sent: 02 October 2003 04:06 PM
To: [EMAIL PROTECTED]
Subject: Re: AW: AMQ7469 Transactions rolled back to release log space

Mr bee-oh double-bee double-ee,

You are to be commended for not believing everything you read but in this
case
I think it's true ;-)

The log parameters do pertain to linear logs, most noticeably for large or
long-running transactions.  i.e. a transaction that exceeds space available
in LogPrimaryFiles+LogSecondaryFiles log files will be rolled back with a
2003 reason code (if i remember correctly).

Some 'fixes' are 1) increasing # logs 2) increase log size and/or 3) keep
transactions to a reasonable size.

HTH,
Marty

On Thursday 02 October 2003 07:35 am, you wrote:
> Just a note from prior postings.
>
> Someone had said once, and I never seen this proven (and personally I
don't
> believe it from what I personally know), BUT...the statement at that time
> form someone I do not remember is that the Prim and Sec log parameters
> effect LINEAR Logging. It may be a red herring but look at your parameter
> definations and the number of LOG files that are actually created. I would
> be interested in the number. (That comment always bugged me!!!)
>
>
>               bobbee
>
> PS given the disclaimers in the above message. I think I just set myself
> up. Hold on let me bend over to receive the kick!!!!!!!! (hahaha)
>
>
> From: "Fleck, Michael" <[EMAIL PROTECTED]>
>
> >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: AW: AMQ7469 Transactions rolled back to release log space
> >Date: Thu, 2 Oct 2003 09:47:39 +0200
> >
> >Hi Matthew,
> >
> >this was our first error. The transaction stops after 10.000 messages. I
> >increased the parameter from 10.000 to 300.000. After this it stops after
> >about 15.000 messages with AMQ7469.
> >
> >Best regard,
> >Michael Fleck
> >
> >-----Urspr|ngliche Nachricht-----
> >Von: Gurney, Matthew [mailto:[EMAIL PROTECTED]
> >Gesendet: Donnerstag, 2. Oktober 2003 11:37
> >An: [EMAIL PROTECTED]
> >Betreff: -Re: AMQ7469 Transactions rolled back to release log space
> >
> >
> >Have you looked at the queue manager attribute Max Uncommitted Msgs?
> >
> >-----Original Message-----
>
> From: Fleck, Michael [mailto:[EMAIL PROTECTED]
>
> >Sent: 02 October 2003 08:27
> >To: [EMAIL PROTECTED]
> >Subject: AMQ7469 Transactions rolled back to release log space
> >
> >
> >Hi list members,
> >
> >I'm relatively new in dealing with MQ-Series.
> >We use MQ Version 5.3 on a Windows 2000 Server. We have a long running
> >transaction, which sends about 100.000 messages to a queue without
> > commits. After 15.000 messages we get the error "AMQ7469 Transactions
> > rolled back to release log space ". I checked our parameters. We have
> > defined linear logging. There's enough space on the volume to keep
> > hundreds of additional log files, but the transaction is stopped and
> > rolled back. Are there any other parameters involved?
> >
> >Best regard
> >Michael Fleck
> >
> >Instructions for managing your mailing list subscription are provided in
> >the Listserv General Users Guide available at http://www.lsoft.com
> >Archive: http://vm.akh-wien.ac.at/MQSeries.archive
>
> _________________________________________________________________
> Get McAfee virus scanning and cleaning of incoming attachments.  Get
> Hotmail Extra Storage!   http://join.msn.com/?PAGE=features/es
>
> Instructions for managing your mailing list subscription are provided in
> the Listserv General Users Guide available at http://www.lsoft.com
> Archive: http://vm.akh-wien.ac.at/MQSeries.archive

Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive

Any views expressed in this message are those of the individual sender, and T-Systems 
South Africa (Pty) Ltd accepts no liability therefore, except where the sender 
specifically states them to be those of T-Systems South Africa (Pty) Ltd.  Although 
this message has been scanned for the possible presence of computer viruses prior to 
despatch, T-Systems South Africa (Pty) Ltd cannot be held responsible for any viruses 
or other material transmitted with, or as part of, this message.

Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive

Reply via email to