SYSPROC.ENV_GET_INST_INFO() not working...

[Andy S.]

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,

[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.

[Andy S.]

> 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!

[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.

[Andy S.]

Oh, ok...Thanks for the info!