Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    177

    Unanswered: Facing issues with drop the database + restore

    Hi all,

    In our setup db2 v9.7 with fixpack 4

    Facing issues with drop the database
    =============================

    Actually, i tried to restore the backup i went successfully.

    But i tried to connect the database i am getting the below error:

    [db2inst1@XXXXX ~]$ db2 connect to XXXXX
    SQL1119N A connection to or activation of database "XXXX" cannot be made
    because a previous restore is incomplete or still in progress. SQLSTATE=57019

    Even i tried to drop the database i can't

    [db2inst1@XXXX ~]$ db2 drop db XXXX
    SQL1035N The database is currently in use. SQLSTATE=57019


    How to drop the database?

    Thanks,
    laxman....

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Check if there are any applications connected to this db or if there any db2 process associated with this db (probably restore is still "attached" to it). Try db2 terminate or force application connected to this db, if any.

  3. #3
    Join Date
    Sep 2012
    Posts
    177
    Hi girl,

    Thx for your valuable reply.

    Now it's working fine, i tried to force the applications...

    Thanks,
    laxman..

Posting Permissions

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