Recently I have a project to list all the UDFs(User-defined Functions) and UDAs(User-defined aggregates) from db2. I found that I can select all the routines from SYSCAT.ROUTINES which has ROUTINETYPE 'F'. Then I can't find out which are UDAs. In fact, there is a column 'FUNCTIONTYPE' indicates aggregate function with type 'c', but user can't specify it in the statement 'CREATE FUNCTION ...' but only use 'SOURCE' to map an existed aggregate function to make it work.
Can someone tell me is there any way to find out the UDAs?