Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Unhappy Unanswered: DB2 v8.1 on Solaris 8 - Backup fails

    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

  2. #2
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Red face

    Any Suggestions?

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2click.com has a script that does what Marcus has suggested

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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