Hi,
i really have trouble restoring my database into the same database using HP Data Protector with rollforward to end of logs.
i'm getting the error
SQL1268N Roll-forward recovery stopped due to error "24" while retrieving log
file "S0000021.LOG" for database "<name>" on node "0".
backup and restore without rollforward works perfectly,although afterwards i'm not able to rollforward to end of logs manually..i then use the command to get the database out of the pending state:
=> rollforward db <name> stop
i configure the database as follows
=> CREATE DATABASE <name>
=> UPDATE DB CFG FOR <name> USING USEREXIT ON DEFERRED
=> UPDATE DB CFG FOR <name> USING LOGRETAIN RECOVERY
=> UPDATE DB CFG FOR <name> USING TRACKMOD YES DEFERRED
=> BACKUP DATABASE <name> TO "" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
i think all the environmental variables are set right. i can see the logs in the folder /app/db2inst2/db2inst2/NODE0000
i don't know why they have trouble restoring them
i'm working on the platform
HP UX B.11.31 U ia64
DB2 V9.7
hope someone can help me with this problem
Regards