Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008

    Thumbs down Unanswered: DB2 Start Problem

    We are trying to restore a backup, we have made the same thing las friday, but now we have the following problem (I attach startdb.log):

    startdb.log" 32 lines, 1019 characters

    ------------------------------ Mon, Aug 18, 2008 10:34:12 PM

    ------------------------------ Mon, Aug 18, 2008 10:34:12 PM
    checking required environment variables

    DB2INSTANCE is >db2tst<
    INSTHOME is >/db2/TST<
    DB2DBDFT is >TST<

    ------------------------------ Mon, Aug 18, 2008 10:34:12 PM
    starting database manager

    08/18/2008 22:34:18 0 0 SQL1063N DB2START processing was successful.
    SQL1063N DB2START processing was successful.
    Database Manager started
    SQL1119N A connection to or activation of database "TST" cannot be made
    because a previous restore is incomplete or still in progress. SQLSTATE=57019
    Activate database failed

    ------------------------------ Mon, Aug 18, 2008 10:34:19 PM
    R3trans connect to the database

    Please, Help us!
    Thank you in advance,

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    I can not see the attached file, but have a look at db2diag logfile
    probably a log file is missing or corrupt and undo/redo can not be done
    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

Posting Permissions

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