469,927 Members | 1,781 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

DBHEAP usage during backup

Hi all,

Env: DB2 ESE/DPF 8.1.6 64 Bit on AIX 5.2.0

we recently had problems with an offline backup of a database with 5
partitions that fails with SQL0956 - Not enough storage in dbheap.
DBHEAP at that time was 5000 Pages per partition. The last backup ran
just fine with that dbheap - no objects (bufferpools, tablespaces,
tables ..) were added or changed since then. We rerun the failing
backup with greater dbheap sizes until it succeeded with a dbheap of
20000 pages. During backup we took snapshots to watch the dbheap high
watermark. We saw that dbheap grows slowly but at the end of the backup
(last 2 to 3 minutes) it grew dramatically. I know that at the end of
backup the recovery history file gets pruned and the log control file
is put into the backup. Can this be the reason for such more dbheap
requirement ?
Can someone share some insights into usage of dbheap during backup ?

the backup ran like this:
db2 backup db <dbname> use tsm compress

TIA for any answer

Joachim

Feb 21 '06 #1
2 1830
Try this.
update db cfg for xxx using dbheap 200000
backup db <dbname> use tsm compress
update db cfg for xxx using dbheap 2000

Joachim Klassen wrote:
Hi all,

Env: DB2 ESE/DPF 8.1.6 64 Bit on AIX 5.2.0

we recently had problems with an offline backup of a database with 5
partitions that fails with SQL0956 - Not enough storage in dbheap.
DBHEAP at that time was 5000 Pages per partition. The last backup ran
just fine with that dbheap - no objects (bufferpools, tablespaces,
tables ..) were added or changed since then. We rerun the failing
backup with greater dbheap sizes until it succeeded with a dbheap of
20000 pages. During backup we took snapshots to watch the dbheap high
watermark. We saw that dbheap grows slowly but at the end of the backup
(last 2 to 3 minutes) it grew dramatically. I know that at the end of
backup the recovery history file gets pruned and the log control file
is put into the backup. Can this be the reason for such more dbheap
requirement ?
Can someone share some insights into usage of dbheap during backup ?

the backup ran like this:
db2 backup db <dbname> use tsm compress

TIA for any answer

Joachim


Feb 21 '06 #2
Thanks for that. Of course this will work. I was just curious if anyone
could give me some insights into usage of DBHEAP during backup
(especially at the end of the backup).

Feb 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Vincent | last post: by
48 posts views Thread by Joseph | last post: by
reply views Thread by Jean-Marc Blaise | last post: by
5 posts views Thread by Sandeep S. Mutalik | last post: by
1 post views Thread by alex | last post: by
1 post views Thread by Norbert Munkel | last post: by
11 posts views Thread by Issam | last post: by
6 posts views Thread by michael.spoden | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.