More opportunities to be a DBA ;--)

This seems to be the likely cause since my NUM_LOG_SPAN value was still at
the original 2GB (3) value.

This also makes sense as the catalyst for IC62978.

My ex-DB2 DBA (we are now completely Oracle) also thought the daily REORG
was too frequent as well as the forced reindex at startup (which would
explain why my last crash/restart ran 3+ hours).  I am loath to change any
DB2 values since I don't know how it will effect the TSM side of the
equation.

Of course turning off the daily reorg begs the question as to how
frequently to push a DB reorg (I assume this would be a direct DB2
command, not TSM - please correct me if I am wrong).



From:
Wanda Prather <wprather AT JASI DOT COM>
To:
ADSM-L AT VM.MARIST DOT EDU
Date:
10/27/2009 10:13 AM
Subject:
Re: [ADSM-L] How big is your V6.1 server log file?
Sent by:
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



Zoltan,

My server is Windows, but had the exact problem - clients failing with
ANS1316E when the server recovery log is obviously not full, and the
server
doesn't go down (which it would if truly out of log space).

Look at IC63373.

Local fix (which is to reset a DB2 variable) seems to have solved it,
we've
gone 5 days now without the failure (longest so far, she said with fingers
still crossed...)  If you issue the DB2 GET DB  CFG as shown in the APAR,
it
will at least display the variable and you can see if the problem applies.

W

On Tue, Oct 27, 2009 at 9:27 AM, Zoltan Forray/AC/VCU
<zforray AT vcu DOT edu>wrote:

> Another failure with my V6.1.0.2 server.
>
> This morning the ONLY user (a total of 3-active nodes) of my V6.1.2.0
> server reported his backups failing with his dsmerror.log showing:
> 10/26/2009 23:21:15 ANS1316E The server does not have enough recovery
log
> space to continue the current operation
> The activelogsize is set to 60000 and I run 3-FULL DB backups daily
> (followed by BACKUP VOLHIST).  This mornings check shows the log at
under
> 200MB used (a full DB backup had already run at 22:00:00).
> How big do I need to make this?  Should I max it out at 128G?
> What are your experiences/settings for activelogsize, for folks running
a
> V6 server in production?
>