If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Database Size ...

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-05-06, 14:49
nagasurir nagasurir is offline
Registered User
 
Join Date: Nov 2003
Location: California,USA
Posts: 71
Post Database Size ...

DB2 UDB V8.2 (FP10)
AIX 5.2.0.0

I noticed total usage of all filesystems which were used for occupancy of each filesystems which were used for these tablespaces is 325GB where as the database size is 200GB only.

I restored (redirect) a backup of a database of 200GB size into a new database with combination of DMS and SMS tablespaces. I was having 250GB free space in all the file systems before restore which I used for the containers for this database TS's. Finally the RESTORE failed because all the containers were running out of space. Finally I got added more space to each filesystem and restored successfully.

So, what way I should check for the freespace in this kind of senario?

thank you,
-Ram
Reply With Quote
  #2 (permalink)  
Old 09-06-06, 12:08
santosh2005 santosh2005 is offline
Registered User
 
Join Date: May 2005
Posts: 10
The Backup Image consists of used pages. It does not take backup of free pages. So if you have a tablespace of 100 GB size and has only 50GB used, then the backup image will be abt 50GB in size. But when restoring the tablespaces, DB2 sets the container size as defined in the original database say 100GB in this example. So you need 100GB of freespace in your filesystem.
-Santosh
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On