Db2: To list schemas and when created

  

select     create_time, schemaname as schema_name,

    owner as schema_owner,

    case ownertype 

        when 'S' then 'system'

        when 'U' then 'individual user' 

    end as schema_owner_type,

    definer as schema_definer,

    case definertype 

        when 'S' then 'system'

        when 'U' then 'individual user'

    end as schema_definer_type

from syscat.schemata    

where schemaname not like 'SYS%'

and  schemaname not IN ('SQLJ', 'NULLID')

order by schema_name