Personal tools
You are here: Home Forums DB2 SYSPROC. ADMIN_REVALIDATE_DB_OBJECTS() error
Navigation
Log in


Forgot your password?
 
Document Actions

SYSPROC. ADMIN_REVALIDATE_DB_OBJECTS() error

Up to DB2

SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() error

Posted by Pawan at May 25. 2011

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.

Re: SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() error

Posted by perallis at May 26. 2011


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.




Re: SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() error

Posted by Pawan at May 27. 2011

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.










Powered by Ploneboard
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls