Hi Judy
If you have the control center working on NT monitoring your AIX system,
then if you click on the tablespace folder (under the database name)and
scroll right in the right hand panel, then you can see whether your
tablespaces are SMS or DMS and how much space they have allocated/are using.
This might be a little on the "manual" side, but it depends on how many
tablespaces you have and how often you have to report.
HTH
Pav
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: DB2EUG: How to determine size of database in UDB?
>Date: Mon, 2 Jul 2001 10:19:55 -0500
>
>
>
>Hello all,
>
>I was wondering if someone could help an old mainframe DB2 DBA! We
>recently
>migrated our DB2/390 v5.1 database to DB2 UDB for AIX v6.1. I have to
>provide a
>monthly report to management to show the actual size of the database. I
>used to
>calculate it as the sum of (reclength * card) for all tables in the
>database
>(from SYSIBM.SYSTABLES). I just noticed that reclength is not included in
>the
>SYSCAT.TABLES table. Can someone point me in the right direction to show
>me how
>to report the actual size of the database in our new environment?
>
>Thanks, in advance, for your help!
>
>Judy
>
>
>
>=====
>To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
>For other info (and scripts), see
>http://people.mn.mediaone.net/scottrmcleod
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
