Oninit cdi / Archive
Talk to an expert →

Number of pages written by a restore

Posted in 2007

Topics: Storage & Space Management, Platform-Specific Issues, Versions, Editions & End-of-Life

Neil Truby — — source: Usenet: comp.databases.informix

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

↪ replying to Neil Truby
david@smooth1.co.uk — — source: Usenet: comp.databases.informix

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?

Related threads

Glossary