When running a FORCE APPLICATION, I receive the following message in return:

DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.

I was wondering if it waits until all current transaction complete or if it rolls them back.

Some of our offline backups have been receiving the follow error:
SQL1035N The database is currently in use. SQLSTATE=57019

I was thinking of runnig a loop until the "LIST APPLICATIONS" comes up Null......

Any suggestions would be appriciated...

Thanks in advance....

I think it should rollback as you are terminating the apps. If this is the
only database residing under that instance, do
db2 force applications all; db2stop force;db2start.
Then start the offline backup.

May not be the best way of doing it.

The prefered sequence is

db2 force applications all
db2 terminate
db2 backup database <database-name>
db2stop
db2start

I advise you not to use a stop force as I've faced an error when the db restarts saying that an agent could not be allocated due to a previous stop force command.

Hope this helps

Nitin

Hi,

Moderator of this forum sathyaram_s has his own www page, where force application script is available. Please see db2 click page for more info.

Hope this helps,
Grofaty