To calculate the size of the database you could use db2 list tablespaces . There were some publicly available scripts ..
If you are using V8 then another option is to the query the snapshot table as pointed out by someone yesterday.
I use backup to pipe for one of the databases here . The key steps are as below.
db2 "backup database mhpi01 online to $mhpi01_bkppipe" >> $TEMPFILE &
cat $mhpi01_bkppipe | gzip -1 > MHPI01.0.mhpi01.NODE0000.CATN0000.z
Cheers
-----Original Message-----
From: BBlake
[mailto:db2udbdba-ezmlmshield-x41762800.[Email address protected]
Sent: 16 February 2005 22:50
To: LazyDBA Discussion
Subject: [SPAM] - RE: How to determine total DB size - Bayesian Filter
detected spam
Well, that is the problem - I back up one of the databases, and it is
about 2 gigs. Then I start backing up another one, and it gets up to
about 10 Gigs, then I have to kill it, for lack of disk space - I don't
know how big it's going to get. Is there a way within the database to
find out what the total size is?
Also, does anyone have any experience with running a backup, and piping it
through winzip or gzip, so it zips it as it creates the backup?
"Blair Jensen " <db2udbdba-ezmlmshield-x41811912.[Email address protected]
02/16/2005 03:46 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: How to determine total DB size
I simply use the backup file size. This will tell you the size without
free
space. If you want free space added in, then add up all your table space
containers sizes (DMS tablespaces).
-----Original Message-----
From: BBlake
[mailto:db2udbdba-ezmlmshield-x35870243.[Email address protected]
Sent: Wednesday, February 16, 2005 2:43 PM
To: LazyDBA Discussion
Subject: How to determine total DB size
In one particular instance, I have 6 DB2 databases. How can I determine
the total size of each of these databases?
Thanks,
Brad Blake
[Email address protected]
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
"Attention: This message is intended only for the individual to whom it is
addressed and may contain information that is confidential or privileged.
If
you are not the intended recipient, or the employee or person responsible
for
delivering it to the intended recipient, you are hereby notified that any
dissemination, distribution, copying or use is strictly prohibited. If you
have received this communication in error, please notify the sender and
destroy or delete this communication immediately."
==============================================================================
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page