Retrieving get_db_config information in SQL statement.

[Erik Hendrix]

Hi,

Using UDB 8.2 there is a procedure called get_db_config. What I would like
to do is to retrieve a certain value from the DB Config in a SQL Statement.

To give some more detail, I created a view which will show me my complete
bufferpool configuration. However, now with V8.2 I would like to show the
value from BUFFPAGE for the size of the bufferpool if the npages in
syscat.bufferpools is null.
Now how can I do this?

I thought on creating a function which would call the get_db_config
procecure but I do not know how to then get the result from the procedure in
the function to be able to return the result.

Anyone any ideas on this?

Thanks.

[Serge Rielau]

Erik Hendrix wrote:

Hi,

Using UDB 8.2 there is a procedure called get_db_config. What I would like
to do is to retrieve a certain value from the DB Config in a SQL Statement.

To give some more detail, I created a view which will show me my complete
bufferpool configuration. However, now with V8.2 I would like to show the
value from BUFFPAGE for the size of the bufferpool if the npages in
syscat.bufferpools is null.
Now how can I do this?

I thought on creating a function which would call the get_db_config
procecure but I do not know how to then get the result from the procedure in
the function to be able to return the result.

Anyone any ideas on this?

Thanks.

Hi Erik,

You need to digest the result set in another procedure.
Then, if you wish you can wrap that procedure in an SQL Function.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Mark A]

"Erik Hendrix" <he**********@hotmail.com> wrote in message
news:1109757651.a841407300bdd4e8b3d5e0218db4dcde@t eranews...

Hi,

Using UDB 8.2 there is a procedure called get_db_config. What I would like
to do is to retrieve a certain value from the DB Config in a SQL Statement.
To give some more detail, I created a view which will show me my complete
bufferpool configuration. However, now with V8.2 I would like to show the
value from BUFFPAGE for the size of the bufferpool if the npages in
syscat.bufferpools is null.
Now how can I do this?

I thought on creating a function which would call the get_db_config
procecure but I do not know how to then get the result from the procedure in the function to be able to return the result.

Anyone any ideas on this?

Thanks.

IBM has said in the version 8 manuals that BUFFPAGE is obsolete and one
should explicitly alter the bufferpool to change the size (not use -1). That
may mean that it is no longer be supported in a supported release.