By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

SYSPROC.ENV_GET_INST_INFO() not working...

P: n/a
Hi,

I'm running DB2 v 7.2 FP 9.

After connecting to DB2, i ran the following commands:

set path = "SYSIBM","SYSFUN","DB2ADMIN","SYSPROC"

SELECT * FROM TABLE(SYSPROC.ENV_GET_INST_INFO()) AS INSTANCEINFO

This is the output of the second command:

"SQL0440N No function by the name "ENV_GET_INST_INFO" having
compatible
arguments was found in the function path. SQLSTATE=42884"

Any ideas why this isn't working??

Thanks in advance,

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Ian
Andy S. wrote:
Hi,

I'm running DB2 v 7.2 FP 9.
I assume you meant DB2 8.2 FP9.

"SQL0440N No function by the name "ENV_GET_INST_INFO" having
compatible arguments was found in the function path. SQLSTATE=42884"

Any ideas why this isn't working??


Looks like you didn't run 'db2udpv8' after installing the fixpack.

Nov 12 '05 #2

P: n/a
> I assume you meant DB2 8.2 FP9.

Actually I'm running "DB2 v7.1.0.77" with FP9

Looks like you didn't run 'db2udpv8' after installing the fixpack.


Frow where do I run this command and what exactly does it do?

Thanks!

Nov 12 '05 #3

P: n/a
Ian
Andy S. wrote:
I assume you meant DB2 8.2 FP9.

Actually I'm running "DB2 v7.1.0.77" with FP9


Oh! Then you're out of luck. None of the SYSPROC functions exist
prior to DB2 UDB V8.x.

Nov 12 '05 #4

P: n/a
Oh, ok...Thanks for the info!

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.