Dear all
what the meaning about privileges on updatable catalog tables
updatable catalog tables
Previous topic • Next topic • 6 posts
• Page 1 of 1
updatable catalog tables
by MohamedEsmael » Wed Aug 30, 2017 4:14 pm
- MohamedEsmael
- Posts: 3
- Joined: Wed Aug 30, 2017 4:12 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: updatable catalog tables
by 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
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
by 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
by 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
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
by 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
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
by 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:
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).
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
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
Previous topic • Next topic • 6 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Catalog tables
by Gurpreet Kaur » Tue May 05, 2009 12:21 pm - 1 Replies
- 2260 Views
- Last post by dick scherrer
Tue May 05, 2009 12:34 pm
- Catalog tables
-
- Initial Catalog
by jaggz » Wed Mar 09, 2011 5:23 pm - 3 Replies
- 2722 Views
- Last post by dick scherrer
Fri Mar 11, 2011 1:05 am
- Initial Catalog
-
- Catalog table details
by tjegan » Sun Apr 19, 2015 5:26 pm - 2 Replies
- 2102 Views
- Last post by NicC
Mon Apr 20, 2015 4:40 pm
- Catalog table details
-
- SQL Generations from DB2 tables
by atodpquery » Fri May 28, 2010 7:34 pm - 2 Replies
- 2169 Views
- Last post by atodpquery
Sat May 29, 2010 7:45 pm
- SQL Generations from DB2 tables
-
- Temporary tables
by Panda15 » Mon Mar 14, 2011 3:42 pm - 2 Replies
- 1978 Views
- Last post by Panda15
Tue Mar 15, 2011 8:29 pm
- Temporary tables