We have a corrupt server and the DB2 7.2 database will not come up. The datafiles (SMS) are intact. Is there a way to import the data into a newly created Database?
As long as the directory in which the the database was cataloged is intact, you can use " "DB2 CATALOG DATABASE xxxxxx ON PATH yyyyyyyyy"
Where yyyyyyyy is the path to the database directory.
After you've installed the software and recreated the instance if necessary.
This works fine in AIX, I'm not sure of the directory structure in windows.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.