Re: Massive Non-DB paging on (nearly) quiescent system

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Hi Jason!  It doesn't "matter".  I was just taking an inventory and 
anomalies always irk me.  Our local replication machine (which actually 
does more replication than the HA machine, because it's used for backups 
and daisy-chains to a development machine) has almost zero paging.  But 
yes, I suppose I could suspend QEDD and see what it looks like.

I was just looking for a more surgical method than that.  :)



On 4/23/2020 3:16 PM, Jason Olson wrote:
> One thing you could do here first, close down QEDD and see if it 
> stops. If it does then you know for sure that QEDD is causing it.
>
> But, since it's an HA system, and if it's running normally, does it 
> even matter?
>
>
> On 4/23/2020 3:10 PM, Joe Pluta wrote:
> > So I've got a machine whose only official purpose in life is as an 
> > offsite HA machine. It talks to our production machine over an 
> > adequate but not extremely large pipe. It's very simply configured 
> > with three pools, machine, base and spool.  It's running at 8% CPU 
> > utilization, and that's nearly all due to the QEDD (replication) jobs 
> > (and an occasional appearance by our good friend QDBFSTCCOL).
> >
> > And yet, I'm getting a ridiculous amount of Non-DB faulting and 
> > paging.  I mean it's crazy:
> >
> > % CPU used . . . . . . . :        7.8    System ASP . . . . . . . 
> > :     9674 G
> > Elapsed time . . . . . . :   00:09:20    % system ASP used  . . . 
> > :    32.9795
> > Jobs in system . . . . . :        819    Total aux stg  . . . . . 
> > :     9674 G
> > % perm addresses . . . . :       .108    Current temporary used . 
> > :    21897 M
> > % temp addresses . . . . :      1.118    Peak temporary used  . . 
> > :    25593 M
> >
> >
> > Sys      Pool   Reserved    Max  ------DB------- ----Non-DB-----
> > Pool    Size M   Size M     Act  Faults    Pages Faults    Pages
> >   1    3110.39   1519.69  +++++       .0      .0 .0      .0
> >   2   52876.82      9.46    372     14.3  1583.1 623.8  2405.6
> >   3    6220.78       .00    126       .0      .0 .0      .1
> >
> > It's been a while since I tracked this stuff down.  Where do I go for 
> > an initial look?  And WRKSYSACT shows nothing out of the ordinary 
> > either.  The QEDD jobs, and tiny percentages from things like 
> > RMTMSAFETA and SMXCAGERnn.
> >
> > Thanks as always!