Re: Logical logs from rootdbs to own logspace
Discussion of moving logical logs out of rootdbs. Neil Truby pointed to the OnLine 5 manual; the original poster said a pointer from Paul Watson sufficed. Andrew Hamm showed that on IDS 9.30 onparams -a -d adds a logical log in another dbspace, with a level 0 archive needed to activate it. Jonathan Leffler noted the manuals, including OnLine 5.x, are online as PDFs.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
"Andrew Hamm" <ahamm@mail.com> wrote in message news:2kedj5F1e6leU1@uni-berlin.de... > Neil Truby wrote: > > > > RTFOVFM. > > OVF? zzzzzzt pass Read the "fine" OnLine Version Five Manual. It might also be in later versions but that's where I remember learning it from! What great manuals they were btw .... > > Quiesce the database Since ancient times, long before the dawn of history ...
Neil Truby wrote: > Read the "fine" OnLine Version Five Manual. It might also be in later > versions but that's where I remember learning it from! What great manuals > they were btw .... Exactly why I wanted a pointer - I have no manuals. I did kinda know how to do this just needed that small pointer that Paul Watson gave.
Neil Truby wrote:
> "Andrew Hamm" <ahamm@mail.com> wrote ...
>> Neil Truby wrote:
>>>
>>> RTFOVFM.
>>
>> OVF? zzzzzzt pass
>
> Read the "fine" OnLine Version Five Manual.
OK then.
>>> Quiesce the database
>> Since when?
> Since ancient times, long before the dawn of history ...
Really? I hope you are talking about a long-forgotten feature of a Version
Five then, 'cos this works beaudifully:
09:27 //bocks/root onparams -a -d data01dbs
Logical log successfully added.
09:27 //bocks/root onstat -l
Informix Dynamic Server Version 9.30.UC2 -- On-Line -- Up 124 days
22:41:27 -- 83908 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 16 692 78 8.87
phybegin physize phypos phyused %used
100107 5000 3402 0 0.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 16 17928 1211 226 14.8 5.4
Subsystem numrecs Log Space used
OLDRSAM 17928 2213668
address number flags uniqid begin size used %used
13414900 1 U-B---- 63 10148f 2500 2500 100.00
13414938 2 U-B---- 64 101e53 2500 2500 100.00
13414970 3 U---C-L 65 102817 2500 1207 48.28
134149a8 4 U-B---- 62 1090d2 2500 2500 100.00
13b52fa8 5 A------ 0 3093fc 2500 0 0.00
5 active, 5 total
09:27 //bocks/root
then a level zero to activate and Jah smiles upon da engine.
Geezer From The Freezer wrote: > Neil Truby wrote: >>Read the "fine" OnLine Version Five Manual. It might also be in later >>versions but that's where I remember learning it from! What great manuals >>they were btw .... > > Exactly why I wanted a pointer - I have no manuals. I did kinda > know how to do this just needed that small pointer that Paul Watson > gave. There is no real excuse not to get the manuals. They're available online at http://www.ibm.com/software/data/informix/library That assumes you don't have an unreasonable prejudice against PDF files. Even the OnLine 5.x manuals are available. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/