I have 3 questions about DB2 schema's , for which I can't find the answer. They are:
- What is the difference between the SYSPROC and SYSFUN schema's (as they both contain functions)?
- Why is, in non-restricted databases, public granted both select on tables in SYSIBM, as select on the views in SYSCAT; I would say the last should be enough?
- Is select on the views in the SYSSTAT schema neccesary for a user to be able to use the query optimizer (this might be a dumb question, I'm not sure)?
Thanks in advance.