Hi all,

DB2 v8.1 fixpak 6 on Solaris 8

I am trying to do a backup task with the following script:

CONNECT TO DPS00001;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE DPS00001 TO "/home/dps/dpsbackup/" WITH 1 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO DPS00001;
UNQUIESCE DATABASE;
CONNECT RESET;

It fails to do the backup. I checked the db2diag.log, it says:

" A transaction is still active, please retry backup again.
Backup terminated."

I added "FORCE APPLICATION ALL;" to the above script but it did not help.

Thanks in Advance,
Newbie

Any Suggestions?

The FORCE APPLICATION ALL is ashynchronous and does not take effect immediately. Try adding a "sleep 10" to a unix script to wait 10 seconds. Or try using two FORCE APPLICATION ALL statements.

Also, you should do a "list applications show detail" to see if there are some connections that are automatically reconnecting, even after they are disconnected.

db2click.com has a script that does what Marcus has suggested

Cheers
Sathyaram