Thanks for the reply Abhijit! I wonder, though. Won't that give me somewhat of
a skewed view of actual usage? That will show the number of pages with data on
them, but the whole page might not be full, right?
"Sinha, Abhijit" <[EMAIL PROTECTED]> on 07/02/2001 11:17:01 AM
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc: (bcc: Judy Kibler/Nashville)
Subject: RE: DB2EUG: How to determine size of database in
UDB?
Hi,
>From the DB2 CLP, use the following command:
list tablespaces show detail.
You will get a list of the used pages. Just add them up.
Abhijit
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 11:20 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: How to determine size of database in UDB?
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
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
