Re: AW: AMQ7469 Transactions rolled back to release log space
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
Re: AW: AMQ7469 Transactions rolled back to release log space
I played with this a little bit and discovered that only the primary logs are defined at QMGR creation and then it maintains that amount. I am yet to primary and secondary logs defined. -Original Message- From: Robert Broderick [mailto:[EMAIL PROTECTED] Sent: 02 October 2003 01:36 PM To: [EMAIL PROTECTED] Subject: Re: AW: AMQ7469 Transactions rolled back to release log space 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 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
Re: AW: AMQ7469 Transactions rolled back to release log space
TNX From: Marty Frasier <[EMAIL PROTECTED]> Reply-To: MQSeries List <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: AW: AMQ7469 Transactions rolled back to release log space Date: Thu, 2 Oct 2003 10:05:41 -0400 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 _ Help protect your PC. Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 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
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
Re: AW: AMQ7469 Transactions rolled back to release log space
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
AW: AMQ7469 Transactions rolled back to release log space
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