That is my take on it. So we plan to take 500GB from the 1TB space
assigned to the ARCHFAILOVERLOG filesystem and expand the ARCHLOG
filesystem with it. If we have any more incidents like this, we will
simply get rid of ARCHFAILOVERLOG and roll with 2TB in ARCHLOG space.
On Thu, May 23, 2019 at
That is very odd as we have utilized the failover space a couple times and it
worked as advertised.
Now you don’t have any confidence the failover space would work in the future
and I agree with your idea to expand the archive log so you don’t run into this
same situation going forward.
-O
Yes it shows/showed proper usage/stats for the filesystem. It showed
archfailoverlog filesystem at 12% used while archlog was 100% and every ISP
server based DBBackup would run for a while and fails with:
5/20/2019 4:30:05 AM ANR2993E The database backup terminated with a log
problem. DB2 sqlcode
Zoltan,
We have had our archive log fill 4 or 5 times in the last couple years and in
each case the TSM server started using the archive failover space which allowed
the database backup time to complete and clear the full archive log.
We just have ARCHFAILOVERLOGDIR setting in our dsmserv.opt f
The problem with doing it within the ISP environment was it kept trying to
write additional records to the ARCHLOG filesystem which was at 100% (which
makes no sense - what is the purpose of the ARCHFAILOVERLOG filesystem if
not to prevent this kind of issue) and therefore the DB backup run as an
I
A native DB2 (without using it as a ISP Instance DB) is capable to do a backup
of archivelogs.
But if used as ISP Instance DB the archivelogs wirhin the configured archivelog
destination will removed by running a full backup within ISP.
Regards Uwe
> Am 21.05.2019 um 16:00 schrieb Hans Christi
Does DB2 have the ability to do just an archivelog backup(no full) and
clear them afterwards like other RDBMs(Oracle/MSSQL)? That would be
convenient where the log space is filling up too fast for a full +
archivelog to go through. Been in that desparate situation several times.
Hans Chr.
On Mon,
