hrmmmm, when I try this on my setup..
I get connections on both the attach, and the connect statements..
then I get a SQL300081n error (i.e.- tcpip communication error) on the force application all
and it stops the instance on the local machine on the db2stop.. (i.e.- doesnt hit the remote db2 server)
hrmmmm any other idea?? this script below wont even work from command center....
any help at all would be mucho appreciated..
-----Original Message-----
From: Kurt Sahlberg [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 10:22 AM
To: [EMAIL PROTECTED]
Subject: Re: DB2EUG: how to stop and restart instances on remote server
Hi,
You must first attach to the remote instance.
Here is a similar script from a remote client.
ATTACH TO xxxxxxx USER xxxxxxx USING xxxxxxx;
CONNECT TO xxxxxxx USER xxxxxxx USING xxxxxxx;
FORCE APPLICATION ALL;
DB2STOP;
DB2START;
I'm on V7.2 on W-2K and this works for me. Output from script center follows :
ATTACH TO xxxxxxx USER xxxxx USING Instance Attachment Information Instance server = DB2/NT 7.2.0 Authorization ID = xxxxxxx Local instance alias = xxxxxxx CONNECT TO xxxxxxx USER xxxxxxx USING Database Connection Information Database server = DB2/NT 7.2.0 SQL authorization ID = xxxxxxx Local database alias = xxxxxxx FORCE APPLICATION ALL DB20000I The FORCE APPLICATION command completed successfully. DB21024I This command is asynchronous and may not be effective immediately. DB2STOP DB20000I The DB2STOP command completed successfully. DB2START DB20000I The DB2START command completed successfully.
HTH
Kurt
>>> [EMAIL PROTECTED] 09/17/01 05:22PM >>>
I created a script to stop and restart services on remote servers, but it is
failing... anyone know a better way? and FYI: for some reason my script
centers on remote servers will not work. Script centers always give me Login
failure, although I can run the scripts in command center or from a CLP
without any problems... OTHER FYI: we are running db2 udb 5.2 on NT
script is as follows
DB2 CONNECT TO %1 USER admin USING password
DB2 FORCE APPLICATION ALL
DB2STOP
DB2START
all the above script does, is stop the instance on the LOCAL workstation
that I am running the script from...
any help would be greatly appreciated
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
