Hi,
we are currently working on optimizing our db structure using Areas. Therefore we used dbanalys on an existing production db.
however, interpreting the result is extremely cumbersome (the DB has approx. 1000 tables).
Are there any tools that help in analysing the output of dbanalys? Or that convert the format in a way that one can import it into a progress db or into MS Excel?
Any help greatly appreciated!
Regards,
Mike
What is your strategy for interpreting the output? (That might impact what sort of tool you need...) Generally speaking you're going to want more than just dbanlys data to make a good storage area design -- if it were just a matter of looking at dbanalys it would probably be automated
Parsing the output is messy. Especially if you have long table or index names -- then you have to deal with line breaks in inconveinient places
If you don't have that problem one quick cheat that works well for UNIX is:
grep "^PUB." tabanalys.out > tabledata.dat
(This assumes that you did a table analysis instead of a dbanalys...) So long as no table names are too long you will end up with a fairly clean report that has one table on each line with all its data.
The next challenge is dealing with big numbers. On old release they just sort of run into the next column -- which makes it nearly impossible if the space between columns gets wiped out. If you have a modern release of Progress (i.e. OpenEdge 10) there is a unit appended "B' for bytes, "K" for kilobytes and so forth.
we are running on OE 10.1A.
Our strategy for interpreting the output is to find tables that should get there own Area, tables that are similar in terms of record size and/or # of recs, and therefore could be put together in the same Area and so on...
So i should have been more precise: We do not expect a tool to do the analysing for us and come up with the ideal structure for our db. We just need a tool that makes it easier to read the output, e.g. by beeing able to sort by #records, record size and so on, to make it easier to see the .
What exactly is the difference between dbanalys and tabanalys?
What exactly is the difference between dbanalys and tabanalys?
Tabanalys reports only on table statistics. Ixanalys reports on
indexes. Dbanalys combines them. There is no report available on LOB
statistics -- you just have to guess about those.
--
Tom Bascom
+1 603 396 4886
tom@greenfieldtech.com
http://greenfieldtech.com