Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem with incremental backup in V7.2

86 views
Skip to first unread message

Joachim Klassen

unread,
Aug 1, 2001, 8:19:51 AM8/1/01
to
Hi all,

I'm currently testing the new incremental backup feature of DB2 V7.2
on AIX.
My scenario:
db2 update db cfg for mydb using TRACKMOD ON
db2 backup db MYDB to /db2/backup -> OK
made some modifications (INSERT/UPDATE ...)in a sample table then
db2 backup db MYDB incremental delta to /db2/backup -> OK
created a new DMS tablespace then
db2 backup db MYDB incremental delta to /db2/backup -> Error SQL2426:

SQL2426N Incremental backup is not enabled for this database.
Ensure that modification tracking is activated, and
perform a full backup of this database.
Only a full database backup was possible after creating a new
tablespace. After that further incremental backups were possible. Am I
doing something wrong or is this works as designed ?. Haven't found
any restricions in the Release Notes for V7.2

TIA
Joachim

David Mooney

unread,
Aug 1, 2001, 1:03:22 PM8/1/01
to

The message is somewhat misleading. It's only the new tablespace that
can't be backed up incrementally. The rule is that you have to take
a non-incremental backup of each tablespace before you can take an
incremental backup of that tablespace. So you should have been able to
modify your scenario to

db2 update db cfg for mydb using TRACKMOD ON
db2 backup db MYDB to /db2/backup -> OK
made some modifications (INSERT/UPDATE ...)in a sample table then
db2 backup db MYDB incremental delta to /db2/backup -> OK
created a new DMS tablespace then

-- New
db2 backup db MYDB tablespace(newDMS) to /db2/backup
-- end new


db2 backup db MYDB incremental delta to /db2/backup

Taking full backups of each tablespace will make your recovery scenario a
bit more complicated than taking a full database backup, but it can
simplify the backup part of the process somewhat.

dave

Joachim Klassen

unread,
Aug 2, 2001, 6:05:30 AM8/2/01
to
Thanks for that quick answer,

one more thing: Do I need to reserve any extra space for the
modification tracking ? Any formulas to calculate this ?

Joachim

David Mooney <d...@vnet.ibm.com> wrote in message news:<9k9coq$r18$1...@tornews.torolab.ibm.com>...

David Mooney

unread,
Aug 2, 2001, 12:31:07 PM8/2/01
to
Joachim Klassen <JOkl...@email.com> wrote:
> one more thing: Do I need to reserve any extra space for the
> modification tracking ? Any formulas to calculate this ?

No more space is required. All new data structures for modification
tracking use previously unused bits that are already in the tablespace
control structures.

dave

0 new messages