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

[Former Member]

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

[Former Member]

issued resolved after changed the script.

[former_member182505]

Hi Vivek

Thanks for the confirmation ,

Please close the thread and share the change you did that will help to others,

Thanks

Sadiq