Re: [ADSM-L] log not flushing

 Content preview:  Hi Remco, This sounds like database reorganization to me.
   You can verify by looking for ANR0293I ("reorganization for table ... 
started")
    and ANR0294I ("reorganization for table ... ended") messages in the activity
    log. There are some server option tunings you can do to control it 
(ALLOWREORGTABLE,
    ALLOWREORGINDEX, REORGBEGINTIME, REORGDURATION) but in general it's a good
    thing for long-term performance and disk utilization. When the server is
   otherwise idle is actually the best time to do the reorgs, since it won't
   interfere with your production loads. [...]

 Content analysis details:   (0.7 points, 5.0 required)

  pts rule name              description
 ---- ---------------------- --------------------------------------------------
  0.7 SPF_NEUTRAL            SPF: sender does not match SPF record (neutral)
 -0.0 RP_MATCHES_RCVD        Envelope sender domain matches handover relay 
domain
X-Barracuda-Connect: mx.gs.washington.edu[128.208.8.134]
X-Barracuda-Start-Time: 1510238307
X-Barracuda-Encrypted: ECDHE-RSA-AES256-GCM-SHA384
X-Barracuda-URL: https://148.100.49.27:443/cgi-mod/mark.cgi
X-Barracuda-Scan-Msg-Size: 1450
X-Virus-Scanned: by bsmtpd at marist.edu
X-Barracuda-BRTS-Status: 1
X-Barracuda-Spam-Score: 0.00
X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=3.5 
QUARANTINE_LEVEL=1000.0 KILL_LEVEL=5.5 tests=
X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.3.44663
        Rule breakdown below
         pts rule name              description
        ---- ---------------------- 
--------------------------------------------------

Hi Remco,

This sounds like database reorganization to me. You can verify by looking
for ANR0293I ("reorganization for table ... started") and ANR0294I
("reorganization for table ... ended") messages in the activity log. There
are some server option tunings you can do to control it (ALLOWREORGTABLE,
ALLOWREORGINDEX, REORGBEGINTIME, REORGDURATION) but in general it's a good
thing for long-term performance and disk utilization. When the server is
otherwise idle is actually the best time to do the reorgs, since it won't 
interfere
with your production loads.

On Thu, Nov 09, 2017 at 12:57:05PM +0100, Remco Post wrote:
> 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

--
-- Skylar Thompson (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine