Showing results for 
Search instead for 
Did you mean: 

Db2 alternet restore

Level 2


I want to restore DB2 database from PRD to SBX.

I am stuck in roll forward activity as  theguide which shared by Veritas technician said that log backup should takes via User Exit program.

While I am checking I found that logs are backed up via Vendor Method.

So which command I should enter to restore database without roll forward.

db2 without rolling forward restore db PRD load /usr/openv/netbackup/bin/ ON '/db2/SBX/sapdata1','/db2/SBX/sapdata2','/db2/SBX/sapdata3','/db2/SBX/sapdata4' DBPATH ON '/db2/SBX/' into SBX redirect

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "without rolling forward restore db PRD loa" was
found following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<values>". SQLSTATE=42601


Partner    VIP    Accredited Certified

Disclaimer: I do not have any 1st-hand experience with DB2.

Herewith the NBU8 for DB2 manual:

I have read through the section under About log archiving. I do not see anything that says User Exit method is required? 

Not sure if it will help, but herewith a post where a user managed to solve his own problem:

The Symantec links in the post should redirect to these Veritas links:

Hope this helps.