Re: Number of pages written by a restore

On Apr 1, 7:28 am, "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 It's been awhile since we even considered taking all the pages of a table. Certainly in the 10.x family the archive should only be considering pages in a table with logical addresses smaller then npused of the partition page. So if you do have tables with a large number of allocated but unused pages in them your free space at the onstat -d level compared to the pages archived could be verydifferent. I don't recall exactly when the change to archive stratagey was introduced, but it has been around a pretty long time.