calculating extents

Hello. Does anyone know of a utility that will allow assist in recalucating extent sizes, so I can plug in my variables and the utility will do the calcuating? Thanks, Michele

michele.orcutt@Windmere.com wrote: > > Hello. > Does anyone know of a utility that will allow assist in recalucating extent > sizes, > so I can plug in my variables and the utility will do the calcuating? > Thanks, Michele $ dbaccess - <<EOF DATABASE sysmaster; SELECT dbsname, tabname, sum(size), count(*) extents FROM sysextents WHERE dbsname NOT IN ("sysmaster", "sysutils") AND tabname != "TBLSpace" AND tabname[1,3] != "sys" GROUP BY 1, 2 ORDER BY 4 DESC; EOF Regards Markus

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> michele.orcutt@Windmere.com wrote: <blockquote TYPE=CITE>Hello. <br>Does anyone know of a utility that will allow assist in recalucating extent <br>sizes, <br>so I can plug in my variables and the utility will do the calcuating? <br>Thanks, Michele</blockquote> <p><br>I use the dbschema utility, or information of dbexport. <p>rsize : Row Size <br>isize : Index Size <br>nrows : Number of rows. <p>First Extend Size (recommended) = (rsize + isize) * nrows <p>Total / 1024 = Will be the parameter to use in create table ... <p>I hope this information is util for you.</html>

michele.orcutt@Windmere.com wrote: > > Hello. > Does anyone know of a utility that will allow assist in recalucating extent > sizes, > so I can plug in my variables and the utility will do the calcuating? > Thanks, Michele There are several sets of scripts and 4gl programs available from the IIUG Software Repository which will do this specifig job for you. In addition if you use my myschema utility (a replacement for dbschema) it will automatically generate extent and next sizes for you as an option. Options are included to specify the growth factor. Myschema is part of the package utils2_ak available from the Repository. -- Art S. Kagel & Family kagel@erols.com