Ok, but how much is actually used when looking at Q LOG?

There could also be background tasks running that do not show up in Q PROC
like reorgs for example.  No Spectrum Protect activity is not always
synonym to no database activity.l

-
Thanks,
Marc...
________________________________________________________
Marc Lanteigne
Accelerated Value Specialist for Spectrum Protect
416.478.0233 | marclanteigne AT ca.ibm DOT com
Office Hours:  Monday to Friday, 7:00 to 16:00 Eastern

Follow me on: Twitter, developerWorks, LinkedIn


-----Original Message-----
From: Remco Post [mailto:r.post AT PLCS DOT NL]
Sent: Thursday, November 9, 2017 9:16 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] log not flushing

> On 9 Nov 2017, at 13:57, Marc Lanteigne <marclanteigne AT CA.IBM DOT COM> 
> wrote:
>
>
> Hi Remco,
>
> When looking at Q LOG F=D, is it 96 GB in " Used Space on File System
(MB)"
> or " Used Space(MB)"?
> If the former, that's normal.  New log files are created as soon as
> old ones are archived.

I know, so we have 128 GB in use on the filesystem, and about 30 GB free on
disk because apparently now a db backup can copy archived log files back to
the active log directory.

> If the latter, you may want to revisit the capacity planning to assess
> if
> 128 GB is sufficient for that environment.

that would make a valid recommendation if the active log was filling up
during the backup window, or for that matter any other activity on the
server. As stated, this server appears to be idle. No sessions, no
processes, no activity whatsoever. So there should be (I guess) also 0
transactions in progress on the database.

( I thought the max was 128 GB, turns out that with 8.1 this has een raised
to 512 GB)

>
> For a medium size environment, 128 GB is normally sufficient.  For
> large implementations, 256 GB is recommended (in some cases larger).
> -
> Thanks,
> Marc...
> ________________________________________________________
> Marc Lanteigne
> Accelerated Value Specialist for Spectrum Protect
> 416.478.0233 | marclanteigne AT ca.ibm DOT com Office Hours:  Monday to
> Friday, 7:00 to 16:00 Eastern
>
> Follow me on: Twitter, developerWorks, LinkedIn
>
>
> -----Original Message-----
> From: Remco Post [mailto:r.post AT PLCS DOT NL]
> Sent: Thursday, November 9, 2017 8:47 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] log not flushing
>
>> On 9 Nov 2017, at 13:09, Marc Lanteigne <marclanteigne AT CA.IBM DOT COM>
wrote:
>>
>>
>> Hi Remco,
>>
>> That's normal, that's how active logs work.  Only the archive log
>> will be purged after a database backup.
>>
>> The active log includes transactions that are in-flight, that is that
>> they are currently running.  The only reason that they go away when
>> you restart the server is that when the server shuts down, it ends
>> all the transactions.  No transactions=no active logs.
>>
>> Your server is working normally.  Just make sure you have sufficient
>> active log space and that the filesystem/LUN used for the active log
>> is not shared with anything.
>
> Hi Marc,
>
> you are right, my bad.
>
> But, 96 ff-ing GB of active log on an idle TSM server? no processes,
> no sessions, nothing… We have configured 128 GB of active log space
> for these servers, so I guess all I can do is wait until the server
crashes?
>
>>
>> -
>> Thanks,
>> Marc...
>> ________________________________________________________
>> Marc Lanteigne
>> Accelerated Value Specialist for Spectrum Protect
>> 416.478.0233 | marclanteigne AT ca.ibm DOT com Office Hours:  Monday to
>> Friday, 7:00 to 16:00 Eastern
>>
>> Follow me on: Twitter, developerWorks, LinkedIn
>>
>>
>> -----Original Message-----
>> From: Remco Post [mailto:r.post AT PLCS DOT NL]
>> Sent: Thursday, November 9, 2017 7:59 AM
>> To: ADSM-L AT VM.MARIST DOT EDU
>> Subject: [ADSM-L] log not flushing
>>
>> Hi All,
>>
>> for my current customer we’ve build a number of SP 8.1.1 servers. One
>> thing that is new is that sometimes the server doesn’t empty the DB2
>> active log after a full database backup. The only way it seems that
>> the log gets flushed is by restarting the TSM server. I’ve seen this
>> now 2 or 3 times in the few months that we’re actively using these
>> servers and it makes me feel uneasy. And no, it’s not like the server
>> is very busy, the server was completely idle as far as I can see.
>>
>> --
>>
>> Met vriendelijke groeten/Kind Regards,
>>
>> Remco Post
>> r.post AT plcs DOT nl
>> +31 6 248 21 622
>>
>
> --
>
> Met vriendelijke groeten/Kind Regards,
>
> Remco Post
> r.post AT plcs DOT nl
> +31 6 248 21 622
>

--

 Met vriendelijke groeten/Kind Regards,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622