Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    84

    Unanswered: backup database?

    I am getting DB in use error when I try to backup using command line or GUI..
    Here is the command I use and error....I am new to DB2..:-(
    CONNECT TO AGILE;
    QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
    CONNECT RESET;
    BACKUP DATABASE AGILE TO "D:\IBM\SQLLIB\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
    CONNECT TO AGILE;
    UNQUIESCE DATABASE;
    CONNECT RESET;

    ---------------------
    SQL1035N The database is currently in use.

    Explanation:

    One of the following conditions exists:

    o Exclusive use was requested, but the database is already in
    use as a shared database by another user (in the same
    process).

    o Exclusive use was requested, but the database is already in
    use as an exclusive database. (Two different processes are
    trying to access the same database.)

    o The maximum number of connections to the database has been
    reached.

    o The database is being used by another user on another
    system.

    o Activate/Deactivate database is in progress.



    The command cannot be processed.

    User Response:

    Possible solutions include:

    o Resubmit the command later when the database is not in use.

    o Change the authorization to match the current user or wait
    until the database is not in use.

    o Wait until the database is not in exclusive use.

    o Wait until other users on another system have disconnected
    from the database.



    sqlcode : -1035

    sqlstate : 57019

    -------------------
    Kishore

  2. #2
    Join Date
    May 2004
    Posts
    1

    backup

    Use "DB2 LIST APPLICATIONS" to see users connected to DB2.
    If you want to backup the database when users are connected, use "online backup" (log archive).

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Just a note that QUIESCE only works for non-admin users, so if you have any users connected with SYSADM, DBADM, etc. they will maintain their connections.

    The only sure way to force everyone off is FORCE APPLICATIONS as noted above.
    --
    Jonathan Petruk
    DB2 Database Consultant

  4. #4
    Join Date
    Jan 2003
    Location
    Schaumburg, IL
    Posts
    79
    If nothing else works,

    db2 force applications all;db2 deactivate db xpsdb;db2stop force; db2start;db2 activate db xpsdb; backup command.

    all in the same command line.
    Naveen Urs
    DBA Manager
    IBM Certified Solutions Expert - DB2 LUW V7, V9

  5. #5
    Join Date
    Mar 2004
    Posts
    84
    Thanks a lot guys. it works.
    Kishore

Posting Permissions

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