Results 1 to 5 of 5

Thread: restore error

  1. #1
    Join Date
    Oct 2013
    Posts
    39

    Unanswered: restore error

    Hi DBA's,

    Am getting the below error in DB2 V9.7 LUW:-

    SQL1119N A connection to or activation of database "ABC" cannot be made
    because a previous restore is incomplete. SQLSTATE=57019

    So, Am not able to find who has performed that incomplete restore and which DB backup they used.

    So, What can be the possible way to solve it?

    Thanks in advance

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as no details are supplied about operations/commands going on
    redirected restore ? aborted restore ?
    if redirect : stop/complete the restore (see infocenter for detailed command)
    drop db and restart restore
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Oct 2013
    Posts
    39
    Hi,
    I got this error when trying to connect to the DB
    Command is:-

    db2 connect to abc

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have a look at diaglog and try to find out what happened
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Apr 2012
    Posts
    156
    Try running db2 list utilities , this will show the status of the restore. Most likely you need to rollforward . As far as who did the restore, you will need to check shell history or other logging you have

Posting Permissions

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