Oninit cdi / Archive
Talk to an expert →

Creating new logical logs on OnLine 5

Posted in 2003

Topics: Logging & Checkpoints

Simon Gosney — — source: Usenet: comp.databases.informix

Hi everyone Can anyone tell me whether it is possible to create new logical logs on an OnLine 5 instance that are larger than the value of LOGSIZE that was set when the instance was initialized? I know that modifying LOGSIZE, bouncing the engine and then creating new logs sizes them correctly to the new LOGSIZE on an IDS engine, but it doesn't seem to work on OnLine. The new logs are created but sized according to the original value of LOGSIZE. Can anyone confirm that this is the case or tell me what I'm doing wrong? Many thanks Simon

↪ replying to Simon Gosney
Art S. Kagel — — source: Usenet: comp.databases.informix

On Wed, 05 Nov 2003 08:32:38 -0500, Simon Gosney wrote: > Hi everyone > > Can anyone tell me whether it is possible to create new logical logs on an > OnLine 5 instance that are larger than the value of LOGSIZE that was set when > the instance was initialized? IMS OL5 logical logs MUST all be the same size and the engine enforces that. The logical logsize that was in the TBCONFIG file at startup is encoded on one or the reserve pages and cannot be changed and that is where tbparams looks for the size to make new logical logs. You'll have to unload your data and initialize a new instance. Art S. Kagel. > I know that modifying LOGSIZE, bouncing the engine and then creating new logs > sizes them correctly to the new LOGSIZE on an IDS engine, but it doesn't seem > to work on OnLine. The new logs are created but sized according to the > original value of LOGSIZE. > > Can anyone confirm that this is the case or tell me what I'm doing wrong? > > Many thanks > > Simon

↪ replying to Simon Gosney
Paul Watson — — source: Usenet: comp.databases.informix

AFAIK you can't do this, all the logs must be the size as spec'd in tbconfig. If you want to change the size you will need to re-initialise the instance, taking a copy of the data first of course. Simon Gosney wrote: > > Hi everyone > > Can anyone tell me whether it is possible to create new logical logs > on an OnLine 5 instance that are larger than the value of LOGSIZE that > was set when the instance was initialized? > > I know that modifying LOGSIZE, bouncing the engine and then creating > new logs sizes them correctly to the new LOGSIZE on an IDS engine, > but it doesn't seem to work on OnLine. The new logs are created but > sized according to the original value of LOGSIZE. > > Can anyone confirm that this is the case or tell me what I'm doing > wrong? > > Many thanks > > Simon -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

Glossary