Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2014
    Posts
    8

    Unanswered: SQL0294N The container is already in use. SQLSTATE=42730

    Hi,

    We are getting an error while trying to do a DB2 restore operation.

    C:\backup\RTCDB Backup12-08-2014>db2 restore database RTCDB taken at 20140812132738
    SQL0294N The container is already in use. SQLSTATE=42730

    Referring to IBM technote is not clear and is taking to some where else.

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Check the db2diag.log. There should be a message about which namely container in use.
    Probably an absolute path to some container in your backup image is the same as one used for another database...
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

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