zOs/SQL/ELAR200

 SELECT DBNAME, NAME, PARTITIONS
   FROM SYSIBM.SYSTABLESPACE
  WHERE PARTITIONS > 200
  AND DBNAME not LIKE 'XB%'
 ORDER BY PARTITIONS DESC
 WITH UR
;