Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Location
    Chennai
    Posts
    45

    Question Unanswered: Regarding Incremental backup

    Hi All,

    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>".

    Explanation:

    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
    database.
    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.

    User response:

    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
    database backup.
    2. Consult the db2diag log file to determine the name of the table
    space, then perform a full backup of that table space.

  2. #2
    Join Date
    Jan 2009
    Posts
    33
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •