IBM Support

Error SQL2428N returned when running a backup with INCLUDE LOGS option due to error SQLP_EXT_DBID_INCORR

Troubleshooting


Problem

"Database ID does not match Extent probably for another database" error message in the db2diag.log running an online backup with the INCLUDE LOGS option.

Symptom

The following error message will be returned on a backup with the INCLUDE LOGS option, if there is a problem retrieving log files.

SQL2428N The BACKUP did not complete because one or more of the
requested log files could not be retrieved.

Further details of the problem can then be found in the db2diag.log

In one scenario, the db2diag.log may contain :

EDUID : 111 EDUNAME: db2logmgr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogFile, probe:4150
RETCODE : ZRC=0x071000D6=118489302=SQLP_EXT_DBID_INCORR
"Database ID does not match Extent probably for another database."

This signifies that the log retrieved by the db2logmgr EDU had information about a different database in it's header.

[{"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":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;9.1;10.1;10.5;11.1","Edition":"Enterprise Server;Express;Personal;Personal Developer\u0027s;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21450419

Page Feedback