zOs/SQL/IMSFRE4

          SELECT SP.DB_NAME,  SP.DD_NAME,
                 (SP.HI_ALLOC-SP.FREESPC) AS ALLOC,
                 CASE
                   WHEN SP.TRK_SEC = 0 THEN
                    SP.HI_ALLOC2
                   WHEN SP.DB_TYP  = 'HDAM'
                    AND SP.TRK_SEC > 0 THEN
                    8589934590
                   WHEN SP.DB_TYP  = 'PHDAM'
                    AND SP.TRK_SEC > 0 THEN
                    4294967295
                   ELSE 0
                 END AS MAX_SPC,
                 CASE
                   WHEN SP.DB_TYP = 'HDAM' THEN
                    (real(8589934590)- (real(SW.FREESPCP)
                   * 8589934590 / 100))
                   WHEN SP.DB_TYP = 'PHDAM' THEN
                    (Real(4294967295)- (real(SW.FREESPCP)
                   * 4294967295 / 100))
                   ELSE 0
                 END AS HIGHWATER,
                 CASE
                   WHEN SP.TRK_SEC  = 0
                    AND SP.HI_ALLOC2 > 0
                    AND SW.FREESPCP  > 0 THEN
                     real(SP.HI_ALLOC2)  * SW.FREESPCP / 100
                   WHEN SP.DB_TYP  = 'HDAM'
                    AND SW.FREESPCP > 0
                    AND SP.TRK_SEC  > 0 THEN
                     real(8589934590)    * SW.FREESPCP / 100
                   WHEN SP.DB_TYP  = 'PHDAM'
                    AND SW.FREESPCP > 0
                    AND SP.TRK_SEC  > 0 THEN
                     real(4294967295)    * SW.FREESPCP / 100
                   ELSE 0
                 END AS THRESHOLD, SW.FREESPCP AS SW_FREE,
                 SP.HI_ALLOC, SP.HI_ALLOC2,
                 SP.FREESPCP AS SP_FREE,
                 SP.IFREESPCP AS SP_IFREE, SP.DB_TYP,
                 SP.TRK_SEC * CAPACITY AS TRK_SEC,
                 SP.EXTENTS, SP.HI_ALCSPC, SP.CAPACITY
            FROM oa1t.TADM31A1 SP,
                 oa1t.TADM32A1 SW
    WITH UR