cancel
Showing results for 
Search instead for 
Did you mean: 

Db2 alternet restore

Jimesh_Makawana
Level 2

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

1 REPLY 1

Marianne
Level 6
Partner    VIP    Accredited Certified

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:

https://vox.veritas.com/t5/NetBackup/Redirected-DB2-restores-error-out-with-SQL2062N-an-error/td-p/3...

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.