database utilization

[madunix]

Am running TSM on Windows Servers, my daily reports shows the following




check db: database utilization 87%, Warning



ANS8000I Server command: 'q db'

Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
7,600 7,600 0 972 4,096 1,945,600 1,696,795 87.2 87.3

ANS8002I Highest return code was 0. GROWTH IBM Tivoli Storage Manager Command Line Administrative Interface - Version 5, Release 4, Level 0.0
(c) Copyright by IBM Corporation and other(s) 1990, 2007. All Rights Reserved.

Session established with server TSM1_SITEA_SERVER1: Windows
Server Version 5, Release 5, Level 0.0
Server date/time: 03/01/2009 08:59:59 Last access: 03/01/2009 08:58:15

ANS8000I Server command: 'select cast(float(capacity_mb / 100 * pct_utilized)/1024 as decimal(14,2)) as dbsize from db'

DBSIZE
----------------
6.47


What do I need to do to observe the daily growth of my DB and how?

 

[moon-buddy]

All you need is to run OR if you are using it. OR can alert you if it goes beyond a certain value so you can do something about it.

Otherwise, run scripts using dsmadmc, displaying the PCT utilized value (maybe through e-mail), and plotting it on a daily basis if you want.