Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    30

    Unanswered: restoring db from 7.2 Fp 8 to 8.1 Fp3

    Hi,

    we restored a backup from a 7.2 FP8 db into version 8.1 FP3.

    worked well so far, but when we tried to view the source of out Stored procedures we got an error. Execution failed with sqlcode S1131N SQLSTATE=38503.

    Anybody any suggestion??

    Cheers

    Thorsten

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: restoring db from 7.2 Fp 8 to 8.1 Fp3

    How did you do this :

    "view the source of out Stored procedures "

    Did you check the db2diag.log file

    Cheers

    Sathyaram

    Originally posted by tmoeller
    Hi,

    we restored a backup from a 7.2 FP8 db into version 8.1 FP3.

    worked well so far, but when we tried to view the source of out Stored procedures we got an error. Execution failed with sqlcode S1131N SQLSTATE=38503.

    Anybody any suggestion??

    Cheers

    Thorsten
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    Did you migrate the database after the restore?
    Fred Prose

Posting Permissions

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