Restoring Database

Posted on 2005-04-26
Last Modified: 2008-01-09
When I am trying to restore a DB2 database, I am getting the following error.

SQL2069N  An invalid image was encountered on media "C:\a\SALESQA.0\DB2\NODE0000\CATN0000\20050426\103526.001".  The image was created for database alias ""

I need to resolve this issue ASAP. Pl. help me.
Question by:rajesh_agr
    LVL 13

    Accepted Solution

    db2 restore database salesqa into <new database name>
    LVL 7

    Assisted Solution


    Looks like you are not using the correct backup image file. If thats not the case

    Check with the 'db2ckbkp' utility to make sure the backup image is good.

    db2ckbkp filename

    LVL 13

    Expert Comment

    either one of these answers is correct

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    This video discusses moving either the default database or any database to a new volume.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now