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=> IBM DB2 9.7 for Linux, UNIX and Windows Information Center

Could you throw some light on this.