Attachment uploads are currently disabled. This is a temporary situation and will resume as normal in the coming days.
UNSOLVED
DB2 backup fails with SQL2428N error.
Hello
I am using Avamar 7.1.
Our daily schedule online db2 database backups are failing to Avamar with
"SQL2428N The BACKUP did not complete because one or more of the requested log files could not be retrieved."
A thread here suggested below
Set in the option/flagfile the following variable:
--fallback-mins-search=How_many_minutes_ago_avdb2_will_look_for_archivelogs
Note: if the archivelog DB2 needs was done 4 hours ago then the variable can be set to 5 hours ago
--fallback-mins-search=300
Where do I set the option? I am facing the same issue and when entered that as free form in the GUI for backup it fails with invalid flag.
Any help is appreciated
Thanks
ionthegeek
2 Intern
•
2049 Posts
1249
0
Posted November 15th, 2016 08:00
Beta is Zhou's English name, not the name of an Avamar flag.
Zhou
1 Rookie
•
53 Posts
1249
0
Posted November 11th, 2016 18:00
This flag can be set into avdb2.cmd under the avs/var directory.
I saw this issue when the log is set to archive automatically. Once the log is backed up, it will be removed from DB2 server. When an online backup is taken, it will retrieve the logs from Avamar. For some reasons, DB2 takes too much time to retrieve the logs and it will result in this issue.
A workaround will be to turn off the log exit.
--Beta