Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002

    Unanswered: Force Application All

    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....

  2. #2
    Join Date
    Jun 2003
    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.

  3. #3
    Join Date
    Jul 2003
    Austin, TX, USA

    Prefered Sequence

    The prefered sequence is

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

    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


  4. #4
    Join Date
    Jan 2003
    Provided Answers: 1

    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,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts