Does IDA rolled-up size estimation numbers across a database? I see that you can type in volumetrics and it will print these out in various points, but does it provide any intelligence besides just printing what you've directly typed in?
Thanks in advance.
This topic has been locked.
4 replies Latest Post - 2013-02-06T20:26:07Z by loicjulien
Pinned topic Size estimation?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-06T20:26:07Z at 2013-02-06T20:26:07Z by loicjulien
Re: Size estimation?2013-02-01T18:59:24Z in response to bmccarHi Brendan,
Our volumetrics basically consists of the following:
1. The ability to model volumetrics information for entities within a Logical Data Model and/or Physical Data Model
2. The ability to transform volumetrics information from a Logical Data Model into a Physical Data Model.
(Note: transformations between Models of different domains are key use-cases for IDA)
3. The ability to generate default tablespaces based on volumetrics information entered
4. The ability to validate (and subsequently recommend) mismatch between your volumetrics information entered and your storage elements
Hope this helps,
bmccar 270004NHQQ4 PostsACCEPTED ANSWER
Re: Size estimation?2013-02-06T02:17:16Z in response to loicjulienThanks for your reply, but honestly I'm still not getting it. Where is this 'mismatch' reported? The online docs recommends to 'generate reports' whereas I don't see any useful information in any report. Is there some sort of guide that walks thru this?
Re: Size estimation?2013-02-06T20:25:32Z in response to bmccarHi,
I am including 2 screencaps (in 2 posts) of how this may be used:
1/ If you select a TableSpace, you can leverage the menu: "Apply TableSpace" to add tables. As you do did, the option "Update table space design" will allow to update some of your tablespace properties based on the volumetrics of the assigned tables: extent size, page size, prefetch...
== Screencap 1 ==
2/ If you select a schema (for instance) you can leverage the menu called "Analyze Model" and select: Physical Data Model section / Index and Storage / Tablespace design check. We may then report validation problems based on your tablespace definition and the volumetrics of assigned tables.
== Screencap 2 ==
Let me know if this helps,