DB2 database restore : SQL1035N The operation failed because the specified database

8346 Views

Hi experts,

During database backup restore we are getting below error. already change in the script file.

db2PRD> db2 -tvsf PRD_NODE0000.scr

UPDATE COMMAND OPTIONS USING S ON Z ON PRD_NODE0000.out V ON

DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

SET CLIENT ATTACH_NODE 0

DB20000I The SET CLIENT command completed successfully.

SET CLIENT CONNECT_NODE 0

DB20000I The SET CLIENT command completed successfully.

@./PRD_NODE0000.scr@

RESTORE DATABASE PRD FROM /DBbackup ,/DBbackup ,/DBbackup TAKEN AT 20151102074108 ON /db2/PRD/sapdata4 ,/db2/PRD/sapdata3 ,/db2/PRD/sapdata2 ,/db2/PRD/sapdata1 INTO PRD WITH 2 BUFFERS BUFFER 1024 REDIRECT

SQL1035N The operation failed because the specified database cannot be

connected to in the mode requested. SQLSTATE=57019

Regards,

Vivek