Results 1 to 5 of 5

Thread: Sql2048n Rc7

  1. #1
    Join Date
    Sep 2003
    Posts
    84

    Unanswered: Sql2048n Rc7

    We are on UDB V8.1 on AIX.


    I had encountered this problem earlier -
    We did a redirected restore and now I cannot connect to the database.
    I saw lots of stuff on the net ( as well as the replies to my earlier post on the same topic) -
    I tried to do a db2stop and start - still the problem persisted.
    Then I tried db2stop and tried to delete the files manually but OS did not allow me to delete the file.
    It seems in some cases the db2dari process keeps a lock on this file but I could not find a db2fmp process running on our system.

    Can someone tell me how to find which db2 process is locking these files ?
    Also I thought that this was a problem exisiting in V7 and had been rectified in V8 - am I wrong ?

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

    Re: Sql2048n Rc7

    Stop your database and as root do slibclean ...

    To find which process is holding the files, you can use fuser command ...

    HTH

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

  3. #3
    Join Date
    Mar 2003
    Posts
    343
    What does slibclean do?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Sep 2003
    Posts
    84
    Thanks a lot. Worked fine.

Posting Permissions

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