Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

shutdown.exe - implications on sybase

3 posts in Windows NT Last posting was on 2000-01-11 16:51:59.0Z
mfield Posted on 2000-01-11 15:26:51.0Z
Message-ID: <387B4BBB.4F1C4ABC@luthersem.edu>
Date: Tue, 11 Jan 2000 09:26:51 -0600
From: mfield <mfield@luthersem.edu>
Organization: luthersem
X-Mailer: Mozilla 4.7 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: shutdown.exe - implications on sybase
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 19
NNTP-Posting-Host: mfield.luthersem.edu 209.224.25.197
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2708
Article PK: 1090523

Greetings from Minnesota,

We are running Sybase 11 on NT 4 with Service Pack 5. We are interested
in
having our server reboot occasionally during the weekend. Using
Scheduled
Tasks (WIN AT), we planned on using the following script to automate the

reboot.

c:\ntreskit\shutdown.exe /l /r /y

Questions:
1) Is there a better way to achieve our goal?
2) If the script is used alone, without any direct commands aimed at
Sybase
such as the sybase command "shutdown", are there any negative
implications
on the database?
3) In summary, as a new DBA, I feel like it is "rude" of me to just
reboot
the server without warning Sybase. :) Thoughts?

Thanks in advance for your insight.

Mark
mfield@luthersem.edu


AnaMaria Stirbet Posted on 2000-01-11 16:51:59.0Z
Message-ID: <387B5FAF.275BB080@sybase.com.no.spam>
Date: Tue, 11 Jan 2000 11:51:59 -0500
From: AnaMaria Stirbet <astirbet@sybase.com.no.spam>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: shutdown.exe - implications on sybase
References: <387B4BBB.4F1C4ABC@luthersem.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 33
NNTP-Posting-Host: astirbet-pc.sybase.com 172.31.140.205
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2705
Article PK: 1090157

Hi Mark,

What we recommend is running at batch that invokes isql with a shutdown
command.
This will be a "polite" (or graceful) shutdown to your Sybase server.
The NT shutdown is a "impolite" (or ungraceful) shutdown, the net stop is in
the middle.
Sybase doesn't recommend customers shutting down the server impolitely.
You can read more in System Admin Guide Chapter 4 (?) Diagnosing System
Problems
- Shutting Down Servers.

AnaMaria Stirbet
Sybase TS

mfield wrote:

> Greetings from Minnesota,
>
> We are running Sybase 11 on NT 4 with Service Pack 5. We are interested
> in
> having our server reboot occasionally during the weekend. Using
> Scheduled
> Tasks (WIN AT), we planned on using the following script to automate the
>
> reboot.
>
> c:\ntreskit\shutdown.exe /l /r /y
>
> Questions:
> 1) Is there a better way to achieve our goal?
> 2) If the script is used alone, without any direct commands aimed at
> Sybase
> such as the sybase command "shutdown", are there any negative
> implications
> on the database?
> 3) In summary, as a new DBA, I feel like it is "rude" of me to just
> reboot
> the server without warning Sybase. :) Thoughts?
>
> Thanks in advance for your insight.
>
> Mark
> mfield@luthersem.edu


Dee Roghelia Posted on 2000-01-11 15:43:55.0Z
From: "Dee Roghelia" <droghelia@ciber.com>
References: <387B4BBB.4F1C4ABC@luthersem.edu>
Subject: Re: shutdown.exe - implications on sybase
Date: Tue, 11 Jan 2000 10:43:55 -0500
Lines: 48
Organization: Ciber
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <oM8FEtEX$GA.303@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 38.208.177.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2707
Article PK: 1090524

You can create a batch file to stop and start the Sybase services and
schedule these files to run using the at command. We have batch files do
this nightly while the tape backup is running. The syntax would be

net stop "service name"
net start "service name" ( you may not need this if you are rebooting NT as
long as your services are set to Startup Automatic)

You can even write sql to checkpoint the databases and have this run in your
at command as well before shutting down the server.

Just a suggestion!

Dee Roghelia

mfield <mfield@luthersem.edu> wrote in message
news:387B4BBB.4F1C4ABC@luthersem.edu...
> Greetings from Minnesota,
>
> We are running Sybase 11 on NT 4 with Service Pack 5. We are interested
> in
> having our server reboot occasionally during the weekend. Using
> Scheduled
> Tasks (WIN AT), we planned on using the following script to automate the
>
> reboot.
>
> c:\ntreskit\shutdown.exe /l /r /y
>
> Questions:
> 1) Is there a better way to achieve our goal?
> 2) If the script is used alone, without any direct commands aimed at
> Sybase
> such as the sybase command "shutdown", are there any negative
> implications
> on the database?
> 3) In summary, as a new DBA, I feel like it is "rude" of me to just
> reboot
> the server without warning Sybase. :) Thoughts?
>
> Thanks in advance for your insight.
>
> Mark
> mfield@luthersem.edu
>
>