DB2: not able to restore from backup?

Without rolling forward can only be used when restoring from an offline backup. Was your backup taken offline? If not, you'll need to use roll forward.

When you do a redirected restore, you are telling DB2 that you want to change the locations of the data files in the database you are restoring. The first step you show above will execute very quickly. Normally, after you execute this statement, you would have one or more SET TABLESPACE CONTAINERS to set the new locations of each data file.It's not mandatory to issue these statements, but there's no point in specifying the redirect option in your RESTORE DATABASE command if you're not changing anything.

Then, you would issue the RESTORE DATABASE S18 COMPLETE command, which would actually read the data from the backup image, writing it to the data files. If you did not execute the RESTORE DATABASE S18 COMPLETE, then your restore process is incomplete and it makes sense that you can't connect to the database.

What I did and what has worked: Executed: db2 restore db S18 from /users/intadm/s18backup/ taken at 20110913113341 on / dbpath on / I got some warnings before, that some table spaces are not moved. When I specified dbpath to partition with sufficient disk space - warning has disappeared. After that, as I have an online backup, I issued: db2 rollforward db S18 to end of logs and complete That's it!

Now I'm able to connect.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.