NMDA: Full DB2 Database backup with logs included fails for large Database reporting SQL2428N error constantly.

Summary: NetWorker Module for Databases and Applications (NMDA) backup of DB2 Database including log files was previously successful, then started failing constantly with no changes that are made to configuration. ...

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

Backup previously successful then started failing.
Errors seen in NMDA logs: 

Unable to backup <DB2 DB name> 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.

DB2diag.log file shows that the following errors reported: -

RETCODE : ZRC=0x82100016=-2112880618=SQLPLFR_RC_RETRIEVE_FAILED
          "Log could not be retrieved"
MESSAGE : ADM8010E  Backup was unable to copy requested log file "<Log Sequence No>.LOG" 
          for inclusion in the backup image. The backup has been aborted.
MESSAGE : SQL2428N  The backup operation did not complete because an error was 
          encountered while the backup utility was retrieving the log files.

Cause

Large Database (over 1 TB) which has many log files to secure due to rate of change or specific processing at point in time.
The communication between DB2 and NetWorker and NMDA times out before all log files can be identified and passed to NMDA to secure. The number of queries required to complete the process for all logs available to backup takes longer than time allowed. By default we query in batches of 100 between NMDA and DB2.

Resolution

Use the NMDA variable NSR_XBSA_MAX_INDEX_COUNT=<value>. Value can be anything over 100 to a max of 5000, typically you would set to 1000 and increase in smaller increments until backup is successful.

To set the variable, you can either:
In the NetWorker Management Console wizard

  1. Go to Protection -> Clients.
  2. Open the DB2 client properties.
  3. In the Apps and Modules tab's Application Information section, create variable NSR_XBSA_MAX_INDEX_COUNT=<value>

In the configuration file for the DB2 database:

  1. Add variable NSR_XBSA_MAX_INDEX_COUNT=<value> 
NOTE: You can adjust the value to suit the specific database needs, but should not exceed 5000 to avoid causing NetWorker server issues with performance.

Affected Products

NetWorker Module for Databases and Applications

Products

NetWorker Family, NetWorker, NetWorker Module
Article Properties
Article Number: 000192104
Article Type: Solution
Last Modified: 21 أبريل 2026
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.