ibm-db2 >> Retrieving get_db_config information in SQL statement.

by Erik Hendrix » Wed, 02 Mar 2005 18:00:52 GMT


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?


ibm-db2 >> Retrieving get_db_config information in SQL statement.

by Serge Rielau » Wed, 02 Mar 2005 20:57:38 GMT

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.


Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

ibm-db2 >> Retrieving get_db_config information in SQL statement.

by Mark A » Thu, 03 Mar 2005 00:27:49 GMT

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.

Similar Threads

1. retrieving table information with an SQL statement

I have a form with a text box.  I want the value of the text box to display 
the names of certain judges.  I have a select statement as follows:
Set rs = CurrentDb.OpenRecordset( _
  "SELECT JudgeID from tblChosenJustices WHERE CaseName = " & 
Form_frmAllData.CaseName _
  & "AND JudgeValue=" & varJudgeValue)
This part seems to work fine.  Each judge is assigned a certain numeric 
value and I now want to compare this value to the value (JusticeID) in 
another table which is simply a 2 field list of judge names and judge values, 
for instance Ruth Bader Ginsberg (JusticeName)=18(JusticeID).  I want the 
justice's name to show in the text box, so I did the following:

MySQL = ("SELECT JusticeName FROM tblJusticenames WHERE" & 
rs.Fields("JudgeId") & "=" & TblJusticeNames.JusticeID)    
      Next intI
Do Until rs.EOF
  Set rs = Nothing
End If

Me.txtAuthorofMajority.Value = ???
Nothing seems to work.  I'm extremely confused at this point.

Thank you for any help you can provide.

2. Retrieve Exit Information (QUSRTVEI, QusRetrieveExitInformation) API - AS/400

3. Retrieve Active Directory Information into a DB2 Database


We need to retrieve Windows 2000 active directory information into a DB2
database file on our iSeries.
This information will mainly be used to associate a user ID to a e-mail
address.  We would like to refrain from seperatly maintainly a external
We currently do not have any enterprise sign-on management software or LDAP.
We are also using Exchange Server for our Mail.
Ex: Maybe query the exchange server( or Win2000)  nightly to update the
Does anybody have a successfull simple approach to this?
Any suggestions on best approach or solutions would be greatly appreciated.



4. Retrieve Resource Information (QRZRRSI) API - AS/400

5. how to retrieve information from sql

6. Retrieve Service Account Login Information from t-SQL - SQL Server

7. SQL 6.5: How to retrieve dump file information

I know, I know... It's a SQL 6.5 question, but here's the issue we're facing.

One of our server blew up and we have no DRP for this server other than its 
tape backup.

So, we've been able to rebuild another server and have installed SQL 6.5 on 
it and have also restored the backup file from tape. However, before I can 
LOAD (restore) the database I would first need to create its database 
devices, and herein lies the problem. How can I tell, looking at the dump 
file, what its database device and other properities are? Or is there another 
way to determine that?


8. How do I retrieve job information from SQL Server