Re: Logical logs *newbie* question

OK, everyone has given you a piece of your answer, let me wrap it up all neatly for you. The 206 pages are free in the sense that they have not been allocated to any server disk object. The existing logical logs which are taking up the remaining 75050 pages are allocated to the logical log 'files' which are only files in the sense that they are discrete disk allocation units like OS files but are created within the logdbs dbspace. When you back up the logical logs they are 'freed' ONLY in the sense that they are then available for reuse unless the oldest of them contains parts of an open transaction. Here free does not mean available to be allocated to another file. The oldest freed logical log will be recycled by the engine and assigned the next sequential logical log unique id (see the onstat -l output to see how these logical ids are assigned to the physicallogical log files. Hope this helps, along with everyone else's takes, but if not post your remaining thoughts and we'll help out some more. Art S. Kagel Gary Quiring wrote: > > We are running IDS 7.3. When I do an onstat -d there's only 206 free pages > available from a total of 75259. > > Here's what I don't understand. I do an entire backup ontape -s 0 over the > weekend when there's nobody using the system. After the backup the free > pages remains the same. If there's no transactions going on and the backup > has flagged the logs as being backed up, why does the free pages not get > larger? > > Thanks > Gary Quiring > > onstat -d output: > Informix Dynamic Server Version 7.30.UC2 -- On-Line -- Up 4 days 23:17:22 > -- 3> 23584 Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > 8fc4613c 1 1 1 1 N informix rootdbs > 8fc47198 2 1 2 1 N informix data1dbs > 8fc47254 3 1 3 3 N informix data2dbs > 8fc47310 5 1 5 1 N informix data4dbs > 8fc473cc 7 2001 7 1 N T informix tempdbs > 8fc47488 8 1 8 1 N informix logdbs > 6 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > 8fc461f8 1 1 0 100000 73515 PO- /dev/rrootdbs > 8fc46b94 2 2 0 1024000 1023947 PO- /dev/rdata1dbs > 8fc46c70 3 3 0 1024000 9007 PO- /dev/rdata2dbs > 8fc46d4c 4 3 0 997997 600938 PO- /dev/rdata3dbs > 8fc46e28 5 5 0 1024000 785866 PO- /dev/rdata4dbs > 8fc46f04 6 3 0 1024000 1023997 PO- /dev/rdata5dbs > 8fc46fe0 7 7 0 1024000 1022577 PO- /dev/rtempdbs > 8fc470bc 8 8 0 75259 206 PO- /dev/rlogdbs > 8 active, 2047 maximum