updatable catalog tables

[MohamedEsmael]

Dear all

what the meaning about privileges on updatable catalog tables

[NicC]

What are you referring to - a manual? office gossip? something else?

[MohamedEsmael]

IBM Manual
https://www.ibm.com/support/knowledgece ... ities.html

[NicC]

What do you not understand? It seems pretty clear to me.

[MohamedEsmael]

did he mean by updatable catalog table
1- that tables that updated through runstats utility or
2- tables that updated when user create DB or Table so there is record added to catalog tables

[NicC]

I Googled "updatable catalog tables" and the first entry (which was for DB2/Linux but that should not matter) has this on the first page:

SYSSTAT views are updatable catalog views that are found in the SYSSTAT schema. The updatable views contain statistical information that is used by the optimizer. The values in some columns in these views can be changed to test performance. (Before changing any statistics, it is recommended that the RUNSTATS command be invoked so that all the statistics reflect the current state.)

I did not investigate further but you can if you need to (unless you are an admin then you probably do not).