I tried to use
SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() procedure to revalidate the invalid
DB2 9.7 FP2,Window 32 BIT
SP1 is invalid procedure and SP2 is valid.
$ db2 "CALL
SQL20508N An error occurred during the revalidation of
.SP1". Operation "REVALIDATION" failed with
SQLSTATE "42501", and message tokens "PKUMAR|EXECUTE|DTOP".
Its throwing error related to permission
but there exist all permissions even Its running for valid objects.