updatable catalog tables
Posted: Wed Aug 30, 2017 4:14 pmDear all
what the meaning about privileges on updatable catalog tables
what the meaning about privileges on updatable catalog tables
IBM Mainframe Forum
Mainframe Technical Support Forums
https://www.ibmmainframeforum.com/
updatable catalog tables
Page 1 of 1
Posted: Wed Aug 30, 2017 4:14 pmRe: updatable catalog tables
Posted: Wed Aug 30, 2017 4:42 pmWhat are you referring to - a manual? office gossip? something else?
Re: updatable catalog tables
Posted: Wed Aug 30, 2017 4:49 pmRe: updatable catalog tables
Posted: Wed Aug 30, 2017 6:41 pmWhat do you not understand? It seems pretty clear to me.
Re: updatable catalog tables
Posted: Wed Aug 30, 2017 6:46 pmdid 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
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
Re: updatable catalog tables
Posted: Thu Aug 31, 2017 5:05 pmI Googled "updatable catalog tables" and the first entry (which was for DB2/Linux but that should not matter) has this on the first page:
I did not investigate further but you can if you need to (unless you are an admin then you probably do not).
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).