updatable catalog tables



IBM's flagship relational database management system

updatable catalog tables

Postby MohamedEsmael » Wed Aug 30, 2017 4:14 pm

Dear all

what the meaning about privileges on updatable catalog tables
MohamedEsmael
 
Posts: 3
Joined: Wed Aug 30, 2017 4:12 pm
Has thanked: 0 time
Been thanked: 0 time

Re: updatable catalog tables

Postby NicC » Wed Aug 30, 2017 4:42 pm

What are you referring to - a manual? office gossip? something else?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: updatable catalog tables

Postby MohamedEsmael » Wed Aug 30, 2017 4:49 pm

MohamedEsmael
 
Posts: 3
Joined: Wed Aug 30, 2017 4:12 pm
Has thanked: 0 time
Been thanked: 0 time

Re: updatable catalog tables

Postby NicC » Wed Aug 30, 2017 6:41 pm

What do you not understand? It seems pretty clear to me.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: updatable catalog tables

Postby MohamedEsmael » Wed Aug 30, 2017 6:46 pm

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
MohamedEsmael
 
Posts: 3
Joined: Wed Aug 30, 2017 4:12 pm
Has thanked: 0 time
Been thanked: 0 time

Re: updatable catalog tables

Postby NicC » Thu Aug 31, 2017 5:05 pm

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).
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post