Is there a Report Designer report I can run that reports on the average row size that appears in Volumetrics in erwin DM? Also, is it doable using ODBC query?
The 'Average Row Size' is calculated and is not stored in the metadata, so cannot be queried, either using ODBC or Report Designer. There is an option in the Volumetrics Editor and the Report tab to 'Save as CSV' Button, as below:
To define a Volumetrics report
1. Click Volumetrics on the Tools menu - the Volumetrics dialog opens.
2. Click the Report tab and select from the following options:
Select to display the Volumetric Report grouped by physical storage object.
Select to display the Volumetric Report grouped by database object.
Select to display the Volumetric Report grouped by table.
Select to display the Volumetric Report using initial table row size.
Select to display a Volumetric Report using projected table values. The projection uses the Grow By estimates in the Settings tab.
Select or type the projected number of months in the Months field (available only when you click Projections).
3. Save as CSV
Select to save the calculated data as an external CSV file. You are prompted to save the file, which you open using a spreadsheet or database application that supports CSV files.
4. Click OK.
The report executes. You can view the object size calculations in the Physical Objects list.