restore IBM OnDemand Content Manager database

narnold33 · #1 (**permalink**) 07-20-11, 16:38

need to move IBM OnDemand Content Manager off old hardware to new.
server 1 current environment: Using DB2 v9.5.0.808. I ran BACKUP DATABASE ARCHIVE TO C:\backup. Copied backup file to server 2. Stopped all ondemand services. restore database ARCHIVE from "C:\backup" taken at 20110429163152 without rolling forward. The RESTORE DATABASE command completed successfully. However I can no longer start up the ondemand services? I'm sure I'm missing some steps. Thanks for any help

dr_te_z · #2 (**permalink**) 08-01-11, 06:20

Hmm, not the right forum I'm afraid. Try this: IBM Support Portal:Overview

przytula_guy · #3 (**permalink**) 08-01-11, 06:42

as indicated on entry 1 : without rolling forward.. was specified

have a look : ROLLFORWARD DATABASE
or try to connect to db and you will see the msg indicating the db is in rollforward pending state

n_i · #4 (**permalink**) 08-04-11, 07:42

WITHOUT ROLLING FORWARD means that the database will NOT be placed in the rollforward pending mode.

przytula_guy · #5 (**permalink**) 08-04-11, 08:41

for the last entry : n_i : I presume if it was an offline backup
otherwise : according the doc :
If, following a successful restore operation, the database is in rollforward pending state, the ROLLFORWARD command must be invoked before the database can be used again.

n_i · #6 (**permalink**) 08-04-11, 11:20

You won't be able to restore an offline backup with the option WITHOUT ROLLING FORWARD. In other words, if this option is specified, there are two possible outcomes:
- restore of an offline backup succeeds, and the database is not placed in the ROLLFORWARD PENDING mode. Rollforward is not needed or possible.
- restore of an online backup fails.