Re: Number of pages written by a restore

<david@smooth1.co.uk> wrote in message news:1175459131.027264.49570@e65g2000hsc.googlegroups.com... > On 1 Apr, 13:28, "Neil Truby" <neil.tr...@ardenta.com> wrote: >> IDS 10.0FC5 on AIX 5.3: >> >> Just for my own interest's sake: >> I did a redirected restore today. At its end the onstat -D output looked >> like this: >> >> Chunks >> address chunk/dbs offset page Rd page Wr pathname >> 7000000101ad028 1 1 1 12 1422 >> /opt/informix/dbspaces2/rootdbs_1 >> 7000000114fcdf8 2 2 1 3 65485 >> /opt/informix/dbspaces2/physdbs_1 >> 7000000114fd028 3 3 1 10 2614607 >> /opt/informix/dbspaces2/llogdbs_1 >> 7000000114fd1c8 4 4 1 0 4 >> /opt/informix/dbspaces2/tempdbs1_1 >> 7000000114fd368 5 5 1 0 4 >> /opt/informix/dbspaces2/tempdbs2_1 >> 7000000114fd508 6 6 1 0 4 >> /opt/informix/dbspaces2/tempdbs3_1 >> 7000000114fd6a8 7 7 1 3 3995115 >> /opt/informix/dbspaces2/appdbs_1 >> 7 active, 32766 maximum >> >> But onstat -d shows: >> >> Chunks >> address chunk/dbs offset size free bpages >> flags pathname >> 7000000101ad028 1 1 1 32621 30479 >> PO-B >> /opt/informix/dbspaces2/rootdbs_1 >> 7000000114fedf8 2 2 1 65535 0 >> PO-B >> /opt/informix/dbspaces2/physdbs_1 >> 7000000114ff028 3 3 1 2621439 202 >> PO-B >> /opt/informix/dbspaces2/llogdbs_1 >> 7000000114ff1c8 4 4 1 524287 524234 >> PO-B >> /opt/informix/dbspaces2/tempdbs1_1 >> 7000000114ff368 5 5 1 524287 524234 >> PO-B >> /opt/informix/dbspaces2/tempdbs2_1 >> 7000000114ff508 6 6 1 524287 524234 >> PO-B >> /opt/informix/dbspaces2/tempdbs3_1 >> 7000000114ff6a8 7 7 1 26214399 13867624 >> PO-B >> /opt/informix/dbspaces2/appdbs_1 >> 7 active, 32766 maximum >> >> In times past the total number of used pages (26214399 - 13867624 or >> about >> 12,400,000 pages) would have been a pretty good estimate of the number of >> pages that a restore would write, but this no longer seems to hold true. >> Is >> IDS 10 doing something smart with unallocated space within tables ...? >> >> thx >> Neil > > DId you rebuild your tables to use less extents at some point? I don't believe so. But what are you driving at?