Re: how to determine size of database

On Wed, 10 Mar 1999, Tony Flaherty wrote: > Hi, > > We have installed some nice new disk space and I'm planning out the > reorg of my databases to make best use of them. Currently we have multiple > database in a dbspace, I intend to implement a 1:1 relationship between > dbspaces and databases. The question is how do I determine how much space I > need for each database? > > I'm to to see the wizard, the wonderfull wizard of IIUG, hoping a nice > script will be available to do this for me! > The following script was posted some months ago by Markus Holzbauer and I have found it works well: database sysmaster; Select round(sum((nptotal * sh_pagesize)/1024)) kBytes from sysptprof p, sysptnhdr h, sysshmvals where dbsname = <your database name> and p.partnum = h.partnum; ==================================================================== Harold Luse Phone: (970) 491-4120 Veterinary Teaching Hospital Fax: (970) 491-4123 Colorado State University Pager: (970) 229-8173 Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu ====================================================================

Thanks for all the replies guys, problem now solved! -- --------------------------------------- Tony Flaherty aef@mfs.misys.co.uk Analyst Programmer Misys Financial Systems All statements and opinions are my own, Misys don't pay me enough to have opinions on their behalf