DB2 Extract Database Size Information from UNIX List Commands

Topic: Code Place

Subtopic: DB2 for LUW

Have you ever run the db2 [call get_dbsize_info(?,?,?,0)] command to get the size of your DB2 LUW database and noticed that the size is much smaller than the space used on your UNIX file systems? Do you need to monitor database growth over time to help plan for future storage requirements? This article describes a script that will calculate the size of a DB2 LUW database on a UNIX server using UNIX commands that will give you a more accurate measure of the space used by the database. This script also stores this information in an operational table that you may use as part of your;DBA Monitoring Dash Board to help you monitor and manage space in relation to growth trends.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.