You have to correct this procedure  - drop and recreate it with the correct objects.

Previously Pawan wrote:

Hi,

    I tried to use

SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() procedure to revalidate the invalid

objects.

DB2 9.7 FP2,Window 32 BIT

SP1 is invalid procedure and SP2 is valid.

$ db2 "CALL

SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('procedure', 'A',

'SP1')"
SQL20508N  An error occurred during the revalidation of

object "A
.SP1". Operation "REVALIDATION" failed with

SQLCODE "-551",
SQLSTATE "42501", and message tokens "PKUMAR|EXECUTE|DTOP". 

SQLSTATE=5UA03

Its throwing error related to permission

but there exist all permissions even Its running for valid objects.

$ db2 "CALL

SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('procedure', 'A',

'SP2) "

  Return Status = 0

I also did db2rbind for all but same

error.

SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() link=> http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.rtn.doc/doc/r0053626.html

Could anyone throw some light on this.

thanks but then whats use of SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS()?

could you tell me few reasons why objects are getting invalid?

Previously wrote:

You have to correct this procedure  - drop and recreate it with the correct objects.

Previously Pawan wrote:

Hi,

    I tried to use


SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() procedure to revalidate the invalid


objects.

DB2 9.7 FP2,Window 32 BIT

SP1 is invalid procedure and SP2 is valid.

$ db2 "CALL


SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('procedure', 'A',


'SP1')"
SQL20508N  An error occurred during the revalidation of


object "A
.SP1". Operation "REVALIDATION" failed with


SQLCODE "-551",
SQLSTATE "42501", and message tokens "PKUMAR|EXECUTE|DTOP". 


SQLSTATE=5UA03

Its throwing error related to permission


but there exist all permissions even Its running for valid objects.

$ db2 "CALL


SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('procedure', 'A',


'SP2) "

  Return Status = 0

I also did db2rbind for all but same


error.

SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() link=> http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.sql.rtn.doc/doc/r0053626.html

Could anyone throw some light on this.