Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    6

    Unanswered: Can I use "db2stop" to stop a remote server?

    Hi all,

    I am using V8.1 on WIN2000 (for production it is AIX) and there is an WebSphere Application connect to it (running on another machine).

    What I want to do is to schedule an offline backup. Since I want to stop both DB2 and WebSphere using single script, I need to stop DB2 remotely.

    I have already catalog the database but I found there is no way for me to stop the remote DB2. Do anyone has suggestion?

    Thanks very much!

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    db2stop

    as the doc indicates :
    This command is not valid on a client.
    to have an offline backup you can connect to the db - execute the quiesce command - take an offline backup and reset the quiesce
    Hope this will help
    Best Regards, Guy Przytula

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi levin001,

    Like przytula suggested, you can do something like this:
    Code:
    db2 CONNECT TO <db> user <userid> using <password>
    db2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
    db2 CONNECT RESET
    db2 BACKUP DATABASE <db> TO D:\backup\ WITH 1 BUFFERS BUFFER 1024 PARALLELISM 1
    db2 CONNECT TO <database> user <userid> using <password>
    db2 UNQUIESCE DATABASE
    db2 CONNECT RESET
    Hope this helps,
    Grofaty

  4. #4
    Join Date
    Nov 2004
    Posts
    6

    Thanks very much!

    Hi grofaty & przytula,

    Your advise is very useful. Now I could do the remote backup.
    Thanks very much!

    Best regards,
    Levin

Posting Permissions

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