Best way to avoid SQL1035N during backup? 2

[SantaMufasa]

Twice in a row now, while backing up databases, I have encountered (on different databases) this fatal error:

SQL1035N  The database is currently in use.  SQLSTATE=57019

Following is an excerpt of the code I run (after having properly set the system variables that appear in the code:

...
    db2 disconnect all > /dev/null
    db2 connect to $SCHEMA user $DB2USER using $DB2USERPW >> $SCHEMALOG 2>&1
    db2 backup database $SCHEMA to $EXPPIPE without prompting >> $SCHEMALOG 2>&1
********************************************************************************

This code has worked perfectly for months on my DB2 databases, but I obviously need to do something more to avoid the above error.

Do you have any suggestions?


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[TSch]

We had to deal with the same problem some time ago. In our case we found out that this was a bug of the current version but I'm not sure whether the next db2 fixpak or a corrected dmdb6bkp solved it for our environment ...

Anyway .. Installing the latest (!) fixpax can't hurt so you might want to check this out ...

Regards
Thomas

 

[Truusvlugindewind]

You are aware of the differences between an offline and an online backup?

 

[SantaMufasa]

Truusvlugindewind, I would appreciate the benefit of your knowledge on whatever method will help us avoid this problem.

What syntax needs to change in my invocation(s), above, to achieve an error-free run?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Truusvlugindewind]

I take that as a "No". I'd suggest you read this:

http://wwwdb.inf.tu-dresden.de/files/teaching/ibmcert/701/db2cert7016-a4.pdf

Bottom line:
1st configure your log-method
2nd determine your backup schedule.

When 24x7 is required archival logging must be configured.
When you (still) use circular logging the problems mentioned by you cannot be avoided. The database needs to come down for the backup.

If the pdf is not clear I'd recommond:

http://www.amazon.co.uk/Understandi...5430840?ie=UTF8&s=books&qid=1192483125&sr=8-1

 

[SantaMufasa]

Thanks, Truusvlugindewind and TSch, for your help. Hava

.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]