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

[former_member182505]

Hi Vivek

Check below IBM detaisl

User response

1. Valid options are:
   • Resubmit the command later when the database is not in use.
   • Change the authorization to match the current user or wait until the database is not in use.
   • Wait until the database is not in exclusive use.
   • Wait until other users on another system have disconnected from the database
   • Issue a QUIESCE DATABASE DEFER WITH TIMEOUT <minutes> command and a CONNECT RESET command to free connections to the database and prevent application users from re-connecting. The DEFER option will wait for applications until they commit the current unit of work instead of rolling back all running transactions.
   • Issue a LIST APPLICATIONS command to list connections to the database. Issue a FORCE APPLICATION ALL command to free connections to the database. Note: FORCE APPLICATION ALL is an asynchronous command which might return as successful even though it is still continuing to clean up connections. A varying interval of time might be required for the command to complete.
2. Deactivate the database using the command DEACTIVATE DATABASE <DBALIAS>.
3. Issue a SET WRITE RESUME FOR DATABASE command to resume write operations for the database.

Re-issue the command.

For more information on the syntax of commands, and related topics, search the Information Center (http://publib.boulder.ibm.com/infocenter/db2luw/v9) using phrases such as "force application", "deactivate database", and "quiesce database".

IBM SQL1035N during execution of an offline backup - United States

IBM Offline database backup failing with SQL1035N - United States

db2 quiesce instance <inst_name> restricted access immediate force connections
db2 deactivate db <dbname>
db2 backup db <dbname>
db2 activate db <dbname>
db2 unquiesce instance <inst_name>

try above and send us more details like, which backup you are using sap and db version, Your backup script details,

Thanks

Sadiq

[Former Member]

we are using the online backup db2 9.7 can i execute the below command & try.