473,320 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DB2 8.2 on Linux - Table Functions get_dbm_cfg get_db_cfg

Hi,

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

Controlcenter gives errors as well (example: Try to create
Lock-chains-view from "list applications"-Window

Any clue?

Thanks!

regards,

Norbert
Nov 12 '05 #1
7 4415
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()
Nov 12 '05 #2
Norbert Munkel <nm@acoreus.de> wrote in message 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()

I guess that you might refer the functions in wrong place or
parameters might be wrong.
Please show me complete SQL statement.
Nov 12 '05 #3
Hi,

Tokunaga T. wrote:
addition: If I create a new database, the get_dbm_function is there but
still not the get_db_cfg()


I guess that you might refer the functions in wrong place or
parameters might be wrong.
Please show me complete SQL statement.


The above is a typo. Here are the whole statements from Chris Eations
snapshot-skripts:

-- GET_DB_CFG
create view DB2$DB_CFG as select * from table(get_db_config()) as sntable;

-- GET_DBM_CFG
create view DB2$DBM_CFG as select * from table(get_dbm_config()) as sntable;

AS I said: The lower view works on a "new" database. The upper does not
work in either updated or new databases.

regards,

Norbert
Nov 12 '05 #4
I'm sorry. I couldn't find a problem.
First, I thought you have not used exact function name.
But, you wrote you have used actually get_db_config.
Nov 12 '05 #5
Hi,

some things I found out in between:

Norbert Munkel <nm@acoreus.de> wrote in message

news:<a3**************@se2-cb104-9.zrh1.ch.colt.net>...
-- GET_DB_CFG
create view DB2$DB_CFG as select * from table(get_db_config()) as sntable;
this is never going to work as get_db_config() is not a table function
but a stored procedure which creates a temporary table. Thats solved
so far.
-- GET_DBM_CFG
create view DB2$DBM_CFG as select * from table(get_dbm_config()) as sntable;


works great on new databases but is missing in databases/instances
updated from 8.1.5 or 8.1.6. Would I need to bind a special package
(other than the ones referred in the FixpackReadme?

best regards,

Norbert
Nov 12 '05 #6
Hi,

i found it. db2updv8 has not been run on the database. Everything fine
now (exept our hardware is buggy -> segfault). ;-)

THX!

Tokunaga T. wrote:
I'm sorry. I couldn't find a problem.
First, I thought you have not used exact function name.
But, you wrote you have used actually get_db_config.

Nov 12 '05 #7
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()

Nov 12 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Fausto Arinos Barbuto | last post by:
Hi All; I have Psyco (on Windows XP) and now I want to install it on Linux, too. I FTP'd the tarball (tar.gz) from Psyco's site but can't get it compiled. First, I tried the usual "python...
8
by: tunity5 | last post by:
I recently installed DB2 v8.1 on Linux. The installation went smoothly. I can now connect to the "sample" database and work with it. However, I noticed the following. How do I go about fixing...
23
by: Rudolf Bargholz | last post by:
Hi, I have a ralatively simple SQL: select FK from TABLE where upper(A) like 'B%' and upper(C) like 'D%' We have DB2 UDB v7.1 FP 12 installed on Linux and on Windows 2003 On Linux using...
22
by: markus | last post by:
Hi, There are more than 1000 defined system calls in the Unix standard specification, however, a majority of them are optional and the availability of system calls are dependent on the OS...
3
by: A.M | last post by:
Hi, I am planning to develop python applications on windows and run them on Linux. Are ActivePython scripts compatible with Linux? Is there any guideline that explains the compatibility...
2
by: chmmr | last post by:
Hello, I would like to ask if there are any differences between DB2 in these versions (e.g. support of triggers, Java stored procedures and such). Also, does anyone know from which DB2 AS/400...
7
by: raghu | last post by:
Hello How to create a task in C on linux operating system? Awaiting for the reply Thanking you in advance -Raghu
0
by: okonita | last post by:
Hi all, I am looking to find the GET_DB_CFG function. We are DB2v8.2 fixpack 14 and I looked in the user defined function folder of db2 control center but it is not there. Should it be somewhere...
0
by: c0d3lib | last post by:
I am attempting to implement, what I believe to be, an unusual scenario, and am hoping to find someone that has experience with something similar. I currently have a series of physical and logical...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.