IBM Support

SQL2426N The database has not been configured to allow the incremental backup RC 2

Troubleshooting


Problem

After enabling TRACKMOD parameter to YES , an incremental backup may fail with SQL2426N rc 2

Cause

After enabling TRACKMOD , an instance recycle is required for the paramter to take effect or atleast a datbase deactivation and activation. Once it is done, a full database backup should be taken. It could be either offline or Online. An incremental backup taken after these steps will complete successfully

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Recovery - Backup","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21977323