Online backup using INCLUDE LOGS may fail with SQL2428N error.
The error is returned due not being able to retrieve logs even
though logs were available in all log paths defined for the
database (active, mirror, overflow, archive).
db2diag.log messages look like this:
2011-09-29-04.40.59.229038-240 I7491744A365 LEVEL: Warning
PID : 39977310 TID : 6170 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 6170 EDUNAME: db2logmgr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLogFile, probe:4130
MESSAGE : Started retrieve for log file S0007548.LOG.
2011-09-29-04.41.00.228963-240 I7492110A388 LEVEL: Error
PID : 39977310 TID : 6941 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 6941 EDUNAME: db2lfr (SAMPLE) 0
FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:25
DATA #2 : Hexdump, 4 bytes
0x07000000097FDA50 : 860F 000A
....
2011-09-29-04.41.00.229463-240 E7492499A572 LEVEL: Severe
PID : 39977310 TID : 679646 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-48649 APPID:
*LOCAL.db2inst1.111003125943
AUTHID : db2inst1
EDUID : 679646 EDUNAME: db2bm.2068183.18
(SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent,
probe:1790
MESSAGE : ADM8010E Backup was unable to copy requested log file
"S0007547.LOG"
for inclusion in the backup image. The backup has been
aborted.
2011-09-29-04.41.00.230717-240 E7493623A563 LEVEL: Severe
PID : 39977310 TID : 679646 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-48649 APPID:
*LOCAL.db2inst1.111003125943
AUTHID : db2inst1
EDUID : 679646 EDUNAME: db2bm.2068183.18
(SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent,
probe:1861
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2428
DATA #2 : Hexdump, 4 bytes
0x00000002527F0998 : FFFF F684
....
2011-09-29-04.41.00.231109-240 E7494187A966 LEVEL: Severe
PID : 39977310 TID : 679646 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-48649 APPID:
*LOCAL.db2inst1.111003125943
AUTHID : db2inst1
EDUID : 679646 EDUNAME: db2bm.2068183.18
(SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent,
probe:1861
MESSAGE : SQL2428N The BACKUP did not complete because one or
more of the
requested log files could not be retrieved.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2428 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlubPro
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
This error can happen when currently committed transaction is
trying to read a log record at the same time online backup is
trying to retreive an archived log file. |
