How to know the Physical Size of a Progress Database

Posted by Johnson Thomas on 29-Apr-2017 15:12

Hi All,

Could you please help me to identify the current physical size of a progress Database.

Version 9.1 E.

Also, how to list all the extends size.

Any help on this will be highly appreciated.

Thanks & Regards,

Johnson

All Replies

Posted by Thomas Mercer-Hursh on 29-Apr-2017 15:27

To get the physical size, just use the appropriate operating system utilities.

Posted by DimitriG4 on 29-Apr-2017 17:29

Running    prostrct statistics dbname  is way more fun if you are on 9.1E04 or later .

Posted by Paul Koufalis on 29-Apr-2017 21:08

If you run proutil db -C dbanalys you'll get the actual size of each table and index.

To get the list of extents, run prostrct list db.

To get the physical size, you look in the directory (ls -al or dir).

Posted by Johnson Thomas on 30-Apr-2017 20:56

Thanks all for your reply

This thread is closed