zOs/SQL/CATSTOR

  select char('<' || storName || '>', 10), count(*)
    from sysIbm.sysTablePart
    group by length(storName), storName
    WITH UR
;
  select char('<' || storName || '>', 10), count(*)
    from sysIbm.sysTablePart
    group by char('<' || storName || '>', 10)
    WITH UR
;
  select char('<' || storName || '>', 10), count(*)
    from sysIbm.sysTablePart
    group by storName
    WITH UR
;
select substr('<' || storName || '>', 1, 10), count(*)--length(storName)
    from sysIbm.sysTablePart
    group by '<' || storName || '>'
    with ur
;
X
select sg, count(*)
from
( select substr('<' || storName || '>', 1, 10) sg
    from sysIbm.sysTablePart
) SG
    group by sg
    with ur
;
X