Hi,
The example in the manual is wrong.
7 GET_DB_CONFIG table function
7
7
7 >>-GET_DB_CONFIG--(--)-----------------------------------------><
7
7
7 The schema is SYSFUN.
7
7 The GET_DB_CONFIG function returns database configuration information. The
function does not take any arguments. It returns a table with
7 two rows containing a column for each parameter. The row with a value of 0
for the DBCONFIG_TYPE column gives the values of the
7 database configuration parameters stored on disk. The row with a value of
1 for the DBCONFIG_TYPE column gives the 7 current values of the
7 database configuration parameters stored in memory.
7
7 Example:
7
7 SELECT LOCKLIST, MAXAPPLS
7 FROM TABLE(SYSFUN.GET_DB_CONFIG()) AS DBCFG
Regards / Gruß Stefan
----------------------------------
Stefan M. Mihokovic
email:
st***@stemi.de
----------------------------------
"Norbert Munkel" <nm@acoreus.de> schrieb im Newsbeitrag
news:%c**************@se2-cb104-9.zrh1.ch.colt.net...
Hi again,
Norbert Munkel wrote:
If I try the new table functions get_dbm_cfg or get_db_cfg on a 8.2
(upgraded from 8.1.6) I always get the following Error:
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "GET_DB_CONFIG" of type "FUNCTION"
having compatible arguments was found. SQLSTATE=42884
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "GET_DBM_CONFIG" of type "FUNCTION"
having compatible arguments was found. SQLSTATE=42884
addition: If I create a new database, the get_dbm_function is there but
still not the get_db_cfg()