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?

Please help.

AK.

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! =-----

"Alan Kwan" <alan_kwan@lsl.com.hk> wrote in message news:<cjt7hv$q947@imsp212.netvigator.com>...
> 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?
>
> Please help.
>
> AK.


Use the control center or "alter bufferpool".