Tool to read output of dbanalys tool

Posted by Admin on 11-Apr-2010 13:26

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

All Replies

Posted by ChUIMonster on 11-Apr-2010 18:04

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.

Posted by Admin on 12-Apr-2010 02:15

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?

Posted by ChUIMonster on 12-Apr-2010 03:51

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

This thread is closed