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

levin001 · #1 (**permalink**) 11-22-04, 23:54

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!

przytula · #2 (**permalink**) 11-23-04, 01:40

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

grofaty · #3 (**permalink**) 11-23-04, 01:58

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

levin001 · #4 (**permalink**) 11-23-04, 03:36

Hi grofaty & przytula,

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

Best regards,
Levin

Internet Services

Web Development

Digital Marketing

Consumer Tech