Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    84

    Unanswered: SQL2048N RC 7 and restoring from an identical image

    We are working on UDB V8.1 on AIX.

    I tried to restore a db from its image copy ( which was identical to the db). While restoring it gave me a warning saying that the image copy was idenitcal and that the db files will be deleted. After carrying on with the restore ( which it said was successful) I can't connect to the db as it returns SQL2048N with RC7 ( says error accessing SQL PROCEDURE FILES ).

    In db2diag.log it says 'PSM - SQL Procedure psm_remove_database_executables
    &
    file sharing violation has occurred' but does not give me the file name.

    How can this be fixed ?

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

    Re: SQL2048N RC 7 and restoring from an identical image

    Stop the instance and start

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

  3. #3
    Join Date
    Sep 2003
    Posts
    84

    Re: SQL2048N RC 7 and restoring from an identical image

    Had tried that but was of no use.

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

    Re: SQL2048N RC 7 and restoring from an identical image

    Stop the instance
    Manually delete the directory referred in the db2diag.log file
    Start the instance

    See if this helps
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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