Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    5

    Question Unanswered: DB2 backup under Win2k3

    I try to make an offline backup of a database, but everytime DB2 report to me:

    SQL1035N Database already in use. SQLSTATE=57019


    My info:
    Product SQL08013
    Level ident 02040106
    Level DB2 v8.1.3.132
    Build level s030728
    PTF WR21324

    I've already try to use command quiesce / force application to, but nothing to do.


    Thank you veru much.

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Try This

    Hi,

    Can you please try the following commands.

    start--> run --> db2cmd

    db2 force applications all.

    db2stop

    db2start

    db2 backup database <database-name> to d:\db2bk

    This will work.

    Please let us know if it does not.
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Apr 2004
    Posts
    5

    Smile Now it work!

    Hi nitingm,
    thank you for your post.

    Yesterday I forgot an active WebSphere app that used my db, and when I try to do backup again without WS active backup job work fine.

    Thank you again,
    fRANz

Posting Permissions

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