RE: Tape capacity planning?
Yes, it is a rough estimate - will have to go back to my queries if you
want more precise info ....
-----Original Message-----
From: Darren_Jacobs@carmax.com [mailto:Darren_Jacobs@carmax.com]
Sent: 23 March 2005 04:28 PM
To: Dirk Moolman
Cc: informix-list@iiug.org
Subject: RE: Tape capacity planning?
Dirk,
Thanks for the response. However, the sum below is more than the total
allocated in my database. I did perform a sum on systabinfo on
ti_pagesused and ti_npused and ti_npdata. Does anyone know if this
would
reflect the amount being backed up?
BTW, 9.40 FC2 on HPUX 11
Thanks
"Dirk Moolman"
<DirkM@mxgroup.co
.za>
To
<Darren_Jacobs@carmax.com>,
03/23/2005 09:10 <informix-list@iiug.org>
AM
cc
Subject
RE: Tape capacity planning?
On my version of Informix, it is the "used space" in the database chunks
that gets backed up(would guess that it is the same in the new versions
as well)
I run a query that calculates this for me, on Informix:
database sysmaster;select sum(chksize - nfree) * 2048 (2048 for the 2k page size in my
opsys)
from syschunks
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Darren_Jacobs@carmax.com
Sent: 23 March 2005 03:12 PM
To: informix-list@iiug.org; ids@iiug.org
Subject: Tape capacity planning?
Greetings,
By chance, does any one have a script that will calculate the amount of
space a backup will use on a tape?
Thanks
sending to informix-list
sending to informix-list