backup error in db2 v10.1

[Former Member]

hi

when i am trying to take backup , following error came :

db2 => backup database TRP to e:\backup

SQL1035N  The operation failed because the specified database cannot be

connected to in the mode requested.  SQLSTATE=57019

regards

yuvraj

[former_member213250]

Hi Harjinder
Is your DB MCOD ? Are there multiple DB instances ?
Also please check the user and password that you are using to run backup.
Did you tried to run the backup manually from command line  are they successful or failing ?

May be these points can be helpful

Regards
Venkat

[Former Member]

Hi Yuvraj,

I think you are trying to take a offline backup of the db2 database.

For offline database follow this.

  1.stop sap

  2.stop db2

  3.start only db2

  4.trigger the offline backup command

  5.Once backup gets completed, start sap also

Regards,

Suresh Daniel.

[Former Member]

hi suresh

as i already mentioned that i had taken offline backup successfully.

now i want to take online backup from sap as db2 v10.1 offline backup is not supported.

when i am taking online backup these messages are coming :

Parameter UTIL_IMPACT_PRIORITY has not been set

SQL Message: SQL2413N Online backup is not allowed because the database

is not recoverable or a backup pending condition is in effect row=1

REASON=ADBC error

regards

harjinder singh

[Former Member]

Hi Yuvraj,

It looks you have activated archive log mode and after that you have not taken offline backup. Please schedule offline backup then system will come out of backup pending mode. After that you can schedule online backup.

Refer this link

How to backup IBM DB2 Database online? - Database Administrators Stack Exchange

Br Vaibhav

[Former Member]

Check to this link also.

Br Vaibhav

[Former Member]

Hi,

*After* you have set LOGARCHMETH1 (or 2) to an appropriate archive logging mode, you need to make an *offline* backup as a one-off baseline.  Once that is complete you will be able to perform online backups.

Regards, Jeremy

[Former Member]

Hi Yuvraj,

If possible can you do below steps and check.

Restart database and try again.

or you can try with

db2 list applications (if any connection shows)

db2 connect reset (closes the database connection held by that user)

and then execute the backup.

Br Vaibhav

[Former Member]

hi vaibhav

i had taken a full offline backup successfully, but again when i am trying to take online backup it showing error :

Parameter UTIL_IMPACT_PRIORITY has not been set

SQL Message: SQL2413N Online backup is not allowed because the database

is not recoverable or a backup pending condition is in effect row=1

REASON=ADBC error

regards

yuvi

[Former Member]

Hi Yuvraj,

For taking online backup you need to enable the archive logging in db2.

Then only db2 will allow you take online backup.

Regards,

Suresh Daniel.

[hugo_amo]

Hi Yuvraj,

Perform the following troubleshooting steps:

1. Identify which user applications or system applications have open connections to the database by using the LIST APPLICATIONS command with the SHOW DETAIL parameter and the GLOBAL parameter.
2. Wait for those applications that have open connections to close their connections to the database.
3. Terminate any remaining connections to the database using the following commands or statements: 
   • QUIESCE DATABASE command
   • CONNECT RESET statement
   • FORCE APPLICATION ALL command
   • DEACTIVATE DATABASE command
4. In a DB2 pureScale environment restart any member that was shut down while an offline operation was taking place (which I don't think it is your case).
5. Connect again.

Regards,

Hugo