NMDA DB2: The backup operation did not complete while retrieving the log file

Summary: NMDA DB2 backup fail "NSR error Unable to backup DEV02DB database due to backup request failure, SQLCODE : -2428, SQL2428N The backup operation did not complete because an error was encountered while the backup utility was retrieving the log files. ." ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

NMDA DB2 backup fails
Messages in the nsrdasv log:

nsrdasv NSR error Unable to backup <database> database due to backup request failure, SQLCODE : -2428, SQL2428N The backup operation did not complete because an error was encountered while the backup utility was retrieving the log files. .
nsrdasv NSR error \nNMDA backup failed.
nsrdasv NSR notice Backing up the '<DATABASE>' database.
nsrdasv NSR error Unable to backup <DATABASE> database due to backup request failure, SQLCODE : -2428, SQL2428N The backup operation did not complete because an error was encountered while the backup utility was retrieving the log files. .

Cause

A possible reason for the failure could be long-running transactions or other operations holding onto the log files, preventing DB2 from accessing them.

Resolution

Change the backup start time  of <DATABASE> backup.
Article Properties
Article Number: 000228605
Article Type: Solution
Last Modified: 14 Jan 2025
Version:  1
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.