Re: ontape sizing
I think even this small script should give the level-0 archive size for
ontapes:
sz=`onstat -d | awk '/Chunks/,/active/ { print $0}' |egrep -v
"^Chunks|^address|active"
| awk'{ tot+=($5-$6+$7)}END { print tot}'`
## get the PAGE_SIZE from the system
echo "0-Level archive size is : `expr $sz \\* $PAGE_SIZE` bytes"
Vj - Remember, we are not alone ...
Tim Schaefer wrote:
}
} Silvester_Valiente@tnt.com.au wrote:
} >
} > Has anyone discovered a reliable way of estimating the size of an
} > ontape archive?
} >
} > ie how many bytes are required to perform a level 0 archive?
} >
} > - TIA
} >
} > Silvester Valiente
} > Informix/Ingres DBA
} > TNT Australi
}
} Silvester,
}
} I would think you'd have to know how much data you have in each
} chunk, for a given data base. If there's a command for this then
} I look silly but so be it. So I wrote a cheezy little report
} to add up used space for each chunk.
}
} :-)
}
} It's called chk_chunks and you can find it at my little web site.
} A variety of sorted reports comes out of it.
}
} Look either in the May ezine or the master tools listings. Output
} can be sorted by disk or by chunk. It may help you understand
} your dbspaces a little better especially on systems with lots of
} disks or lots of spaces.
}
} There's another one called Dspace, which somebody here in the group
} wrote a while back, but it had an error in it. The error was that
} it would eliminate counting up temp-dbspaces in the listing, which
} you might want to watch along with other spaces. So, I fixed it,
} and expanded the listing to include a little more information.
}
} Awk will overflow quite easily on a variety of systems big and small
} so sizes are in KB.
}
} There may be other ways to this, so count this as only one way among
} many. It's amazing with the myriad of options onstat comes with that
} they haven't put this in it. Or separated onstat -d into two separate
} reports.
}
} Tim
} --
} Tim Schaefer \\\\|//
} tschaefe@mindspring.com (6 6)
} ------------------------oOOo---( )---o00o---------
} http://www.inxutil.com
} MAKE TIDAL WAVES JUMP IN THE OCEAN IS BIG