See support ticket for more details, but the slow query in question is ->

  SELECT DISTINCT res.instance_id, res.sort_name FROM EAM_RESOURCE res, EAM_SUBJECT_ROLE_MAP srm, EAM_ROLE_OPERATION_MAP rom, EAM_ROLE_RESOURCE_GROUP_MAP rgm, EAM_RES_GRP_RES_MAP rgrm, EAM_OPERATION op WHERE res.fsystem = N AND srm.role_id = rom.role_id AND rom.role_id = rgm.role_id AND rgm.resource_group_id = rgrm.resource_group_id AND rgrm.resource_id = res.id AND ( srm.subject_id = N OR res.subject_id = N) AND res.resource_type_id = N AND rom.operation_id = op.id AND op.resource_type_id = res.resource_type_id AND (op.name = 'S' OR op.name = 'S' OR op.name = 'S' OR op.name = 'S' OR op.name = 'S') AND (res.sort_name like upper('S') OR res.instance_id in (SELECT appdef_id FROM EAM_CPROP, EAM_CPROP_KEY WHERE keyid = EAM_CPROP_KEY.id AND appdef_type = N AND lower(propvalue) like lower('S'))) ORDER BY res.sort_name DESC