Question Re: DB2 database restore : SQL1035N The operation failed because the specified database in Technology Q&A

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

Former Member — Thu, 11 Feb 2016 06:09:13 GMT

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

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

former_member182505 — Thu, 11 Feb 2016 06:24:22 GMT

Hi Vivek

Check below IBM detaisl

User response

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.
Deactivate the database using the command DEACTIVATE DATABASE <DBALIAS>.
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

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

Former Member — Thu, 11 Feb 2016 06:54:58 GMT

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

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

Former Member — Thu, 11 Feb 2016 07:48:58 GMT

issued resolved after changed the script.

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

former_member182505 — Thu, 11 Feb 2016 09:25:59 GMT

Hi Vivek

Thanks for the confirmation ,

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

Thanks

Sadiq