469,573 Members | 1,044 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,573 developers. It's quick & easy.

UDB: Backup Image Size & Used Pages Size

Hi,
I posted this on other user-groups.
Hardly got any responses. Here goes the question:

PLATFORM = DB2 UDB 8.2+ on AIX 5.x, DPF

Two Topics broadly:
(A) I wish to find out a rough correlation between the size
of Used Pages in the database and its backup image size
(Have to do some space calculation).
(B) How many partitions should be backed up in parallel to
gain the most optimum performance?

Specifically, the questions / observations on Topic A are
(Assuming Used Pages Size is fixed):
(1) Backup Image Size changes with number of buffers
specified in the backup command.
(2) Is backup image size related to number of partitions
even when the used pages are same?
(3) Does datatype have an impact on backup size?
OR
If the used pages add upto 1G, approx how much would be the
size of uncompressed backup image?

All answers / hints / experience-sharing are appreciated.

Regards,
Anurag

Feb 23 '06 #1
3 2140
Your USED PAGES in a database is always not correct. It depends on the
activity on database.
For example if u delete lot of records in a table and if there is no
REORG done it may not show up the correct usage of the USED PAGES.

But generally if your database is well maintained this USED PAGES is
the good indicator of how much space your tablespaces have used.

Where as your BACKUP image of the database contains everything.

As far as tuning the performance of BACKUP process is concerned please
explore the PARALLESIM ...etc options
you can check them in the DB2 ADMIN GUIDE.

cheers...
Shashi Mannepalli

Feb 24 '06 #2
Shashi Mannepalli wrote:
Your USED PAGES in a database is always not correct. It depends on the
activity on database.
The used pages indicator _is_ correct. It shows how many pages are
allocated in a tablespace. It is not intended to show on how much pages
the data in the DB would fit if it were optimally stored and not
fragmented.
But generally if your database is well maintained this USED PAGES is
the good indicator of how much space your tablespaces have used.
Even if it is not well maintained. ;-)
Where as your BACKUP image of the database contains everything.


Unless you are doing an incremental backup.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Feb 24 '06 #3
Sorry....i was referring to the HIGH WATER MARK usage...some
times....it may show higher than the intended
if u don't do REORG...etc

Knut Stolze is correct.

Feb 24 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Rob S | last post: by
27 posts views Thread by Raquel | last post: by
6 posts views Thread by Raquel | last post: by
2 posts views Thread by Raquel | last post: by
4 posts views Thread by Erik Hendrix | last post: by
4 posts views Thread by uthuras | last post: by
1 post views Thread by Joachim Klassen | last post: by
5 posts views Thread by zgh1970 | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.