07-18-2018 12:44 AM
Hi,
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/nbdb2.so 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
07-18-2018 03:10 AM
Disclaimer: I do not have any 1st-hand experience with DB2.
Herewith the NBU8 for DB2 manual: https://www.veritas.com/content/support/en_US/doc/ka6j00000000AAyAAM
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:
https://www.veritas.com/support/en_US/article.TECH51846
https://www.veritas.com/support/en_US/article.TECH77284
Hope this helps.