Alan Kwan wrote:
> Hi
>
> AIX 4. DB2 7.2
>
> I try to increase the buffer pool with the ID 1 using the following SQL to
> find out what size currently had:
>
> SELECT bpname
> FROM syscat.bufferpools
> WHERE bufferpoolid = 1
>
> My questions is can I using SQL update statement to change the size or I
> need to change it in control centre?

Updates to the system catalog will fail. Use ALTER BUFFERPOOL (or
Control Center).



-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----