Can anyone assist me in the incremental backup... I have taken full backup of db and tablespace.. But, again i get this error.. Please look into this command....
>db2 backup database mydb3 online incremental toc:\DB2\bkup_db3\SQL2426N The database has not been configured to allow the incremental backup
operation. Reason code = "2".
>db2 ? sql2426nSQL2426N
The database has not been configured to allow the incremental
backup operation. Reason code = "<reason-code>".
Incremental backups are not enabled for a table space until after
modification tracking has been activated for the database and a
non-incremental backup has been performed on the table space.
Possible reason codes:
1. The configuration parameter TRACKMOD has not been set for the
2. The TRACKMOD configuration parameter has been set but at least one
table space has not had a non-incremental backup taken since the
TRACKMOD parameter was set.
The action is based on the reason code as follows:
1. Activate modification tracking for the database by setting the
TRACKMOD database configuration parameter to on, then perform a full
2. Consult the db2diag log file to determine the name of the table
space, then perform a full backup of that table space.
As per the error description, have you enabled the db parameter trackmod.Please also mention the db version and platform, it would be easier for us to give you teh commands.
db2 get db cfg for dbname and find the trackmod and check whether it is enabled.
Last edited by sharaths_81; 05-18-12 at 00:08.
Reason: more clarity