468,117 Members | 1,500 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,117 developers. It's quick & easy.

SYSPROC.ENV_GET_INST_INFO() not working...

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
4 3942
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
> 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
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
Oh, ok...Thanks for the info!

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Sathyaram Sannasi | last post: by
1 post views Thread by richard | last post: by
3 posts views Thread by efiryago | last post: by
3 posts views Thread by chettiar | last post: by
1 post views Thread by Roger | last post: by
reply views Thread by David Beardsley | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.