zOs/SQL/CATDBCNT

select count(*) cnt
     , SUM(case when name like 'DXB%' then 1 else 0 end) dxb
     , SUM(case when name like 'XB%' then 1 else 0 end)  xb
     , min(dbid) dbidMin
     , max(case when dbid < 0 then dbid else -99000 end)  dbidNegMax
     , mAX(dbid) dbidMax
     from sysibm.sysDatabase