Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011
    Location
    Chennai
    Posts
    27

    Unanswered: Sysproc.admin_revalidate_db_objects

    Hi all,

    I'm re validating my invalid routines using the admin proc SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS. I'm facing the below error for some procs while doing this. I'm unable to find the exact cause for this.

    SQL20508N An error occurred during the revalidation of object "QATETL
    .AMR_LOAD_ADJUSTMENTS". Operation "REVALIDATION" failed with SQLCODE "-901",
    SQLSTATE "58004", and message tokens "No procedure rec". LINE NUMBER=6.
    SQLSTATE=5UA03

    Any help will be greatly appreciated.

    Thanks
    Thawfii

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What's your db2level? Check db2diag.log for errors. For -901, most likely you would need to open a pmr.

  3. #3
    Join Date
    Nov 2011
    Location
    Chennai
    Posts
    27
    Thanks a lot !!
    I've recompiled them using work bench tools .. some procs failed because of alterations in their base table ..

    Thawfii

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •