zOs/TX/PER11CON

delete from A540769.tPer11
    where type like 'u0322=%'
;
insert into A540769.tPer11
  select
     sum(Cnt       )
   , sum(s1Rows    )
   , min(s1RowF    )
   , max(s1RowT    )
   , sum(vrRows    )
   , min(vrRowF    )
   , max(vrRowT    )
   , sum(buRows    )
   , min(buRowF    )
   , max(buRowT    )
   ,     'u0322=d'
       from A540769.tPer11
       where type like 'u0322*%'
      group by
               floor(log(3*max(s1RowF  , 0.1)))
             , floor(log(3*max(vrRowF  , 0.1)))
             , floor(log(3*max(buRowF  , 0.1)))
;
insert into A540769.tPer11
  select
     sum(Cnt       )
   , sum(s1Rows    )
   , min(s1RowF    )
   , max(s1RowT    )
   , sum(vrRows    )
   , min(vrRowF    )
   , max(vrRowT    )
   , sum(buRows    )
   , min(buRowF    )
   , max(buRowT    )
   ,     'u0322=1'
       from A540769.tPer11
       where type like 'u0322*%'
;
select count(*), type
    from A540769.tPer11
    group by type
    order by type;
select *
    from A540769.tPer11
    where type = 'u0322=1' ;
select
    t.*
  from A540769.tper11 t
  where type = 'u0322=d'
  order by 2 desc, 3 desc, 4 desc