Re: Hello:
At 07:05 AM 9/10/97 -0700, you wrote:
}
}
}
}
}Well...
}
}The only way to change the size of logical logs is to re-initialize the
}instance... as in: unload all data, reinitialize the engine, recreate
}the database(s), load data.
}
}Many ways to do it - you choose your poison... dbexport/dbimport,
}unload/load, etc, etc, etc...
}
}Manual: INFORMIX-Online Dynamic Server : Administrator's Guide, Volume 1,
}Version 7.1, pg 23-10.
In version 7.x, you can add new logs, specifying the new size, then
drop your old, smaller (or larger) logs, thus accomplishing the same result.
This too is the in the 7.x TFM, under usage of 'onspaces'.
Jon
}
}Sometimes it pays to read the manual...
}
}Eric
}
}
}
}
}
}
}cfran@opn.dem.state.in.us on 09/09/97 07:26:00 AM
}
}Please respond to cfran@opn.dem.state.in.us
}
}To: informix-list@rmy.emory.edu
}cc: (bcc: Eric Melillo/AGInc)
}Subject: Hello:
}
}
}
}
}
}
}
}
}
}Hello:
}I am encountering an error when attempting to add logical logs.
}In this particular situation, I needed to add some logs while
}changing the size of others. I began by dropping 3 logical
}logs (to change the size), and then added 3 logs. When I at-
}tempted to add another log (to increase the size from 1 MB to 4
}MB, I encountered the following error:
}Cannot add a logical log. ISAM error: bad log record
}What do I need to examine when running onlog (if that is the
}first task), and what other items should I investigate to find
}a solution? I used onparams to add/drop logical logs. Our
}current version of OnLine is 7.10.UC2 on AIX 3.2. 5. Thank
}you for your assistance.
}
}
}
}
}
}
}
}
----------------------------------------------------------------------------
---
Jon C. Vemo "Life is like a dogsled team, if you ain't the
jvemo@cyberspace.com lead dog the scenery never changes."
----------------------------------------------------------------------------
---