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

    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
    Posts
    127
    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
    Location
    Austin, TX, USA
    Posts
    278

    Prefered Sequence

    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

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    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

Posting Permissions

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